MySQL Forums
Forum List  »  Newbie

Re: Add Date to Column
Posted by: Jon Rios
Date: August 10, 2017 11:00AM

this is the error



12:59:26 [ALTER - 0 rows, 0.000 secs] [Code: 1064, SQL State: 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 '--add new column with DATE
alter table revisions ADD COLUMN test DATE default '2' at line 1

Options: ReplyQuote


Subject
Written By
Posted
August 10, 2017 07:19AM
August 10, 2017 09:14AM
Re: Add Date to Column
August 10, 2017 11:00AM
August 10, 2017 06:45PM
August 10, 2017 07:30PM


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.