Actually, AUTO_INCREMENT is the correct syntax for MySQL. I think the problem is NOT NULL should come first: iddiary INT NOT NULL AUTO_INCREMENT. 2009/5/28 João Cândido de Souza Neto <joao@xxxxxxxxxxxxxxxxxxx>: > It´s not auto_increment, it´s auto increment. > > -- > João Cândido de Souza Neto > SIENS SOLUÇÕES EM GESTÃO DE NEGÓCIOS > Fone: (0XX41) 3033-3636 - JS > www.siens.com.br > > "Grega Leskovsek" <mavricek@xxxxxxxxx> escreveu na mensagem > news:1df2d4810905280748uec4f425kaf14b6410caa4e4@xxxxxxxxxxxxxxxxx > 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 >> >> if you need only date you can use: >> >> CREATE TABLE diary ( >> iddiary int auto_increment not null, >> imepriimek varchar(50), >> when date, >> action varchar(30), >> onfile varchar(100) >> unique id(iddiary) >> ); >> >> To get formated date you should use: >> >> select date_format(when, "%T%W%e%c%y") from diary; >> >> To put data in this field you can use: >> >> insert into diary (when) values (str_to_date("10:55:14Thursday28509", >> "%T%W%e%c%y")); >> >> >> >> -- >> João Cândido de Souza Neto >> SIENS SOLUÇÕES EM GESTÃO DE NEGÓCIOS >> Fone: (0XX41) 3033-3636 - JS >> www.siens.com.br >> >> "Grega Leskovsek" <mavricek@xxxxxxxxx> escreveu na mensagem >> news:1df2d4810905280643y62a0f092p91fa2c57558d86d7@xxxxxxxxxxxxxxxxx >>> CREATE TABLE diary(iddiary int auto_increment not null, imepriimek >>> varchar(50), when date("%T%W%e%c%y"), action varchar(30), onfile >>> varchar(100) unique id(iddiary)); >>> >>> I tried the above and it didn't work. What must I do to create a table >>> with full time and date. If I should use timestamp how do I convert >>> thee timestamp in php back to "normal" time? (I also tried the mysql >>> command: >>> when timestamp >>> and >>> when date >>> in the above first mysql clause but it didnt work >>> ) >>> >>> Please help me. Thanks in advance, >>> -- >>> When the sun rises I receive and when it sets I forgive -> >>> http://users.skavt.net/~gleskovs/ >>> All the Love, Grega Leskov'sek >> >> >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> > > > > -- > When the sun rises I receive and when it sets I forgive -> > http://users.skavt.net/~gleskovs/ > All the Love, Grega Leskov'sek > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
