Mysql Table

March 21, 2009

How do I make my MySQL table automatically make a timestamp when new data is added?

mysql
Carbonbased Lifeform asked:


I am trying to create a MySQL table with three columns. Two colummns are for data and a third the time at which the data is inserted. When I create the table, how do I write out the command to tell MySQL to create a timestamp column?

Filed under Programming & Design by administrator

Permalink Print 3 Comments

September 19, 2008

How do you determine the number of rows in a mySQL table with PHP?

mysql
~*Stephanie S asked:


I want to determine the number of rows in a mySQL table and store it in a variable. Could someone please help me with the syntax?

Filed under Programming & Design by administrator

Permalink Print 1 Comment