This sounds like what I need. However, I'm using mysqlcc to create and modify the tables. I've created a column of type "timestamp", but the value is "0000-00-00 00:00:00" unless I explicitly set it in the "INSERT" statement. I'm using a perl script to do the insertions. How can I set the default to "now()"?
dave -----Original Message----- From: Gary Thornock [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 12:00 PM To: BYU Unix Users Group Subject: RE: [uug] SQL help (most recent) Make sure that your table has a column of type timestamp. That provides the same functionality as a datetime field set to now(), but without your having to manually set it. (Warning, though: a timestamp field will update anytime the record is updated, unless you specifically set it to its current value). Then, SELECT * FROM your_table WHERE time_stamp = (SELECT MAX(time_stamp) FROM your_table); You can also use an auto_increment ID field to accomplish this. > Perhaps you can create a date field with the default value being > Now()-- then sort by said field. > > see also: > http://www.mysql.com/doc/en/Date_and_time_functions.html > > > >>> [EMAIL PROTECTED] 10/20/03 12:09 PM >>> > > I'm creating a simple mySQL database that is being populated by a > > perl script. Each entry will corresponds to an event that is > > happening on another machine. I'm looking for an SQL query that > > will return the most recent entry and I have no way of knowing > > when that might have been. It may have been two hours ago, or two > > weeks. > > > > The only way I can think of is to ask for the list to be sorted > > and take the first row, but this seems wrong in every way, > > especially once the list starts to grow. > > > > Any ideas? ____________________ BYU Unix Users Group http://uug.byu.edu/ ___________________________________________________________________ List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list ____________________ BYU Unix Users Group http://uug.byu.edu/ ___________________________________________________________________ List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list
