> Assuming new values or rows are added once per second, how > would a client program go about polling the database to see when a new > value was ready? Check # of rows for a column and when it's > incremented grab the latest value?
Use an id field as the primary key with a statement like this: SELECT * FROM table ORDER BY id_field DESC LIMIT 1; You could also use a DATETIME type field for the id (primary key) so that it contains useful data. Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Chris Webster" <[EMAIL PROTECTED]> To: "Curtis Maurand" <[EMAIL PROTECTED]> Cc: "Becoming Digital" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, 12 June, 2003 19:03 Subject: Re: soft real-time database Curtis Maurand wrote: > I'd write a perl script to pool the device and send the data to the > database. Sorry for not being clearer. I can get the data into the database fine. Assuming new values or rows are added once per second, how would a client program go about polling the database to see when a new value was ready? Check # of rows for a column and when it's incremented grab the latest value? --Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]