Re: underscore character?
Becoming Digital wrote: The error is in FLOAT(1). Think about that for a moment. What's a float with one-digit precision? It's an integer. :) While I agree with your analysis the error was a missing comma. The float(1), which I originally thought was array size of 1, appeared to work fine. --Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: soft real-time database
Curtis Maurand wrote: What's the client running on? Not the same machine as the server. Could either be a windows or linux box across ethernet. --Chris 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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
soft real-time database
Greetings, I'm new to databases, but I am considering one for soft real-time data recording of scientific data. Then any client/display program can grab data. I'll be recording 300-500 variables/columns per second for about 10 hours at a stretch. All variables are floats. a) Is there a way to insert/write floats to the DB without converting to ASCII first? Seems expensive. b) I'm still wading through the documentation, but what would be the prefered method for polling to see if a new row has been written? I assume there is no notification process available from the server TIA for any pointers. -- --Chris I don't approve of political jokes. I've seen too many of them get elected. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]
underscore character?
I'm getting an error with create table, appears that field names cannot have the underscore character. Is this correct? It would be quite fatal for us, as we need some sort of delimeter character, so we can group variables by instrument. You have an error in your SQL syntax near 'A2DEE1_RWO FLOAT(1), -- --Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]