You are here: Re: Modify MySQL time column values « All PHP « IT news, forums, messages
Re: Modify MySQL time column values

Posted by Ridge Burner on 10/10/24 11:51

Thanks lorento,
but what if I want to sort by this column? what if I want to add these
columns for a total?
I think data should be stored in a column that is designed to hold that type
of data, eg numbers go in INT() columns, dates go in DATE columns, text goes
in TEXT etc etc.
If you just throw data into a varchar, you seriously reduce your ability to
manage and manipulate the data you store.

--Ridge


>I think you should not use time as column type..
> better use VARCHAR(5)
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация