MySQL Forums
Forum List  »  Newbie

Error importing (or even altering) database with TIME data type
Posted by: a b
Date: February 20, 2016 05:12PM

I've been trying to import a database, but I keep getting a #1064 error, claiming there's an error in my syntax.

I literally just exported this database from an myphpadmin database, and am importing it into another myphpadmin database.

I even tried doing a table create for everything leading up to the line with the supposed "error", and that went in just fine. Then when I went to ALTER the table and add that one column into it, it says there's a syntax error.

This is the line (column) I'm trying to add, do you guys see anything wrong with it?

`Prov_3_400Run` time(4) DEFAULT '25:59:59.0000',

I've tried it without the comma at the end all by itself, nothing... It's really getting on my nerves at this point.

Options: ReplyQuote


Subject
Written By
Posted
Error importing (or even altering) database with TIME data type
a b
February 20, 2016 05:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.