Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re: MySQL Timestamp comparison

by tune (Curate)
on Oct 30, 2003 at 12:48 UTC ( #303242=note: print w/ replies, xml ) Need Help??


in reply to MySQL Timestamp comparison

I think it is a very bad idea. Consider you are having more than one record inserts within a secundum. You cannot issue a unique key to your new records since it would be identical. You better use an auto_increment integer as primary key, and keep the timestamp for other reasons. The auto_increment column is strictly growing in time too, and does not take up as much disk space.

Hey wait, where is the perl question in this???

--
tune


Comment on Re: MySQL Timestamp comparison

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://303242]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (11)
As of 2015-07-07 13:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (88 votes), past polls