MySQL Forums
Forum List  »  Newbie

field types syntax
Posted by: Mike Vitrano
Date: March 21, 2009 07:28PM

Hi, I have been trying to get MYSQL to add my field types for a table I created,but no matter what type I use char, varchar,text,numeric,int,etc... I can not get past the field for Author_Social_Security_Number! I have been typing over and over and over for 3 damn weeks now! I do know I hate MYSQL. Talk about user unfriendly! The database is Books_at_home, the table is Books, The fields are
ISBN Number char(20) primary key,
Book Title char(45),
Author_Social_Security numeric(9,0),
Book Cost decimal (4,2),
Year Published datetime >;
I have done them with commas w/o commas with brackets,braces,parentheses. The Soc Sec I have tried text char numeric int and the error points to right after the word security. What am I doing wrong,or is this another vista 64 bit issue. Oh yeah version 5.1.32. Thanks alot!!!!!

Options: ReplyQuote

Written By
field types syntax
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
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.