2009/5/28 Grega Leskovsek <mavricek@xxxxxxxxx>: > 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 <joao@xxxxxxxxxxxxxxxxxxx>: >> 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
