Silus
-
Posts
4 -
Joined
-
Last visited
Never
Posts posted by Silus
-
-
Probably so as it stopped working for no apparent reason.
BTW can you give an example of a column list and why is it preferrable?
Thanks -
I figured it out.
I had to
[b]alter table stats add timestamp timestamp;[/b]
then when I added data from a script I put null into the timestamp field
[b]echo "insert into stats values ( $input4 , $input5 , $input6 , $input13 , $input14 , $input15 , $input16,null );"
[/b]
the $input#'s are just some script variables I added to the table. -
I'm really new to mysql, but I would like to add a timestamp to a row when it is added automatically.
Thanks.
Automatic timestamp
in MySQL Help
Posted
Anyways, I swapped to the column list where I list the column names then the data that goes in em
insert into stats (cola,colb) values($input3,$input4);
It made it much easier to see what was exactly causing the error.
Thanks for the help