2009/5/28 Grega Leskovsek <mavri...@gmail.com>: > I GOT THIS ERROR when  I tried first sample with when timestamp; > > > ERROR 1064 (42000): You have an error in your SQL syntax; check the > manual thatcorresponds to your MySQL server version for the right > syntax to use near 'id(iddiary) )' at line 1 > > > 2009/5/28 João Cândido de Souza Neto <j...@consultorweb.cnt.br>: >> If you need date and hour the best way is: >> >> CREATE TABLE diary ( >>  iddiary int auto_increment not null, >>  imepriimek varchar(50), >>  when timestamp, >>  action varchar(30), >>  onfile varchar(100) >>  unique id(iddiary) >> ); > > Please advice. Thanks in advance, Grega
There is a coma missing between the lines for the last column and the unique key. Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php