MySQL Forums
Forum List  »  Newbie

Re: HELP PLEASE!
Posted by: Stalin Lema
Date: November 03, 2014 11:54AM

SQL query:

INSERT INTO STUDENT
VALUES (

'JO100', 'Jones', 'Tammy', 'R', '1817 Eagleridge Circle', 'Tallahasse', 'FL', '32811', '7155559876', 'SR', '850714', '8891', 1, DATEDIFF( NOW( ) , "2011-08-01" ) , "2011-08-01" + INTERVAL 1189
DAY , NOW( ) ;

MySQL said: Documentation

#1064 - 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 '' at line 2

Options: ReplyQuote


Subject
Written By
Posted
October 31, 2014 12:54PM
October 31, 2014 01:10PM
October 31, 2014 03:41PM
October 31, 2014 04:30PM
October 31, 2014 09:43PM
November 01, 2014 05:32AM
November 02, 2014 04:08PM
November 02, 2014 04:32PM
November 02, 2014 06:00PM
November 03, 2014 05:17AM
November 03, 2014 09:58AM
Re: HELP PLEASE!
November 03, 2014 11:54AM
November 03, 2014 12:15PM
November 03, 2014 12:49PM
November 03, 2014 02:09PM


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.