RE: Copy database to a file

2006-06-20 Thread Thomas Amundsen
I'm running MySQL server 5.0...??? mysql> mysqldump --help; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql dump --help' at line 1 -Original Message- From: J.R. Bullington [mai

Time of entry updates?

2006-06-14 Thread Thomas Amundsen
Is there any way to find the time of the most recent update for a row?

RE: INT wants a float/double?

2006-06-06 Thread Thomas Amundsen
mailto:[EMAIL PROTECTED] Sent: Tuesday, June 06, 2006 2:38 PM To: Thomas Amundsen; mysql@lists.mysql.com Subject: RE: INT wants a float/double? [snip] It seems to work with INTs when I do it from the MySQL commandline. I guess something is weird with the JDBC connector or something... [/snip] Ma

RE: INT wants a float/double?

2006-06-06 Thread Thomas Amundsen
It seems to work with INTs when I do it from the MySQL commandline. I guess something is weird with the JDBC connector or something... -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 06, 2006 2:26 PM To: Thomas Amundsen; mysql@lists.mysql.com Subject

RE: INT wants a float/double?

2006-06-06 Thread Thomas Amundsen
E name = 'Tom'" but that wouldn't work. And yes, I have made sure that it isn't a problem with the parseInt() method by using hard-coded values...only hard-coded doubles work, hard-coded ints wouldn't. -Original Message- From: Jay Blanchard [mailto:[EMAIL PROT

RE: INT wants a float/double?

2006-06-06 Thread Thomas Amundsen
Right...the thing is that they are supposed to be INTs, but I can only successfully perform an update query if I use doubles for the fields...? -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 06, 2006 1:59 PM To: Thomas Amundsen; mysql@lists.mysql.com

INT wants a float/double?

2006-06-06 Thread Thomas Amundsen
Hi, I am using Java to maintain a MySQL database. I have a table in the database created by: "CREATE TABLE track_char (" + "id INT UNSIGNED NOT NULL AUTO_INCREMENT," + "PRIMARY KEY (id)," + "name CHAR(40),"