Re: Modify MySQL time column values


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)



.

Relevant Pages

  • Re: Anyone interested in . . .
    ... Currently implemented is move, rename, copy, delete, create dir, delete ... dir. Sort by name, date, size. ... Ability to store without am HP header ...
    (comp.sys.hp48)
  • [8FOLD] Template #3
    ... "You lead a very eventful life, don't you, Mr. Kidman?" ... lunatics collapsing in the middle of your store... ... threats have some sort of motivation behind them. ...
    (rec.arts.comics.creative)
  • Re: Bad feelings in Wickes
    ... to sort it out. ... insisted that I should approach the exit without the carrier bag, ... test if the machine would beep. ... A few years My brother and I went into a Wicks Store and bought a large ...
    (uk.legal)
  • C 128s ROM socket
    ... sort of a new topic, so I didn't reply to that. ... I've thought about that ROM socket in the C128 a lot and have on occasion ... So I'm hoping to use something on the IEC port to store more ... up trying to read/write to a serial flash ram chip via the user port.. ...
    (comp.sys.cbm)
  • Re: all this talk of clothing made in china...
    ... USA." and in her store, she's only going to sell items that are made ... and just the sort of person that should think about joining the ... I was brought up by parents (mother, mostly) who instilled me with all ...
    (uk.people.support.depression)