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
