I have a table called animals (using the example in the MySQL guide). I have a datetime column type. Here is the table:
Looks like it's called bug_master, not animals. :-)
create table bug_master ( id MEDIUMINT NOT NULL AUTO_INCREMENT, name CHAR(30) NOT NULL, date DATETIME NOT NULL, PRIMARY KEY (id) );
I want to do a simple insert into the table with the current date and time, i.e.
the system date.
I'm having some problems finding the correct sql syntax to do this. Could anyone
help with this?
Do I need a Now() function?
That's exactly right.
insert into animals <the rest of the query??>;
INSERT INTO bug_master (id,name,date) VALUES(id_val,name_val,NOW());
Thanks! Kevin
-- Paul DuBois http://www.kitebird.com/ sql, query
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
