MySQL Forums :: Newbie :: field types syntax


Advanced Search

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


Subject Written By Posted
field types syntax Mike Vitrano 03/21/2009 07:28PM
Re: field types syntax laptop alias 03/22/2009 03:26AM
Re: field types syntax Rick James 03/22/2009 12:13PM
Re: field types syntax Mike Vitrano 03/22/2009 06:07PM
Re: field types syntax Rick James 03/22/2009 07:14PM
Re: field types syntax Mike Vitrano 03/22/2009 08:56PM
Re: field types syntax Rick James 03/23/2009 01:03AM
Re: field types syntax Peter Brawley 03/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.