field types syntax
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!!!!!