Hi guys, i'm not new to sql, but its my first time using mysql. i am creating a new table and keep getting errors when trying to insert a date feild or time feild:
create table MessageBoard
MessageID char(10) not null,
MemberID char(10) not null,
Topic varchar(50) not null,
Description varchar(250) not null,
Expiry_Date date 'yyyy-mm-dd' not null,
Start_time time 'hh:mm:ss',
Date/Time timestamp 'yyyy-mm-dd hh:mm:ss' not null,
PRIMARY KEY (MessageID),
I keep getting a syntax error for the two date feilds and time feild? i havn't got a clue what i'm doing wrong? is inserting a date feild different in mysql to SQL server?
i'd appreciate any help plzzzz, thanks for your time...