MySQL Forums
Forum List  »  Newbie

Re: field types syntax
Posted by: Mike Vitrano
Date: March 22, 2009 08:56PM

1064 <42000> near'Insert at line 2 since I entered your code It is always the author social security line I,ve tried int,char,bigint,but it always shows error near either author or security
use Books_at_home;
CREATE TABLE Books
(ISBN Number BIGINT<20> (UNSIGNED) (ZEROFILL) PRIMARY KEY,
Book Title CHAR<45>,
INSERT INTO tbl_Books (..., Author_Social_Security, ...)INT(..., 123456789, ...)(UNSIGNED);
Book_Cost NUMERIC(4,2),
Year Published DATETIME ; but now it shows after insert I have tried brackets and parentheses around into but same error

Options: ReplyQuote


Subject
Written By
Posted
March 21, 2009 07:28PM
March 22, 2009 03:26AM
March 22, 2009 12:13PM
March 22, 2009 06:07PM
March 22, 2009 07:14PM
Re: field types syntax
March 22, 2009 08:56PM
March 23, 2009 01:03AM
March 22, 2009 01:01PM


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.