#mysql

27 October 2007

Total 16 pages. You are browsing page 16/16.

First :: Prev :: [...] [12] [13] [14] [15] [16] :: Next :: Last

22:32 <****> you can store them as binary if you want
22:32 <****> nyc-h0st_, I'm planning to use the times for a stats script
22:33 <****> if your script works better if they come in a particular way
22:33 <****> then you would need to achieve that particular way
22:33 <****> you can store them as anything you want, you can even store each value in a separate column and index them all
22:34 <****> there are functions to format the output from mysql
22:34 <****> if you look things up months (all events in january, any year) unix ts isn't good.
22:34 <****> so you dont have to store them in a particular way to view them in a particular way
22:35 <****> ok
22:35 <****> gotta go guys have fun
22:35 <****> nyc-h0st_: that's bad advice
22:35 <****> chad i'm kidding about the columns
22:36 <****> i wasn't talking about the columns
23:07 <****> i have an 'attachments' (key=id:integer) table, and a 'users' (key=hash:20byte binary) table, and a 'userattachments' table (key=id+hash).
23:07 <****> i only add new rows into attachments and userattachments. do i still need the foreign keys?
23:08 <****> the reason im asking is because the userattachment has lots of rows, and the index space is pretty big
23:12 <****> MySQL sucks donkey balls.
--- Log closed Sun Oct 28 00:00:54 2007

Total 16 pages. You are browsing page 16/16.

First :: Prev :: [...] [12] [13] [14] [15] [16] :: Next :: Last