yes, it automatically inserts the time.
>From the manual:
6.2.2.2 The DATETIME, DATE, and TIMESTAMP Types: (
http://www.mysql.com/doc/en/DATETIME.html )
"The TIMESTAMP column type provides a type that you can use to automatically
mark INSERT or UPDATE operations with the current date and time. If
I've tried to find a way to generate a list of consecutive numbers with a
SELECT statement.
I would like something like "Select ..." that would result the numbers
between 1 and 20 on separate rows.
So far, the only solution I have found is to have a table with consecutive
numbers from 1 to 1000,
