At 8:37 -0600 3/15/03, KKolle@stripped wrote:
>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.
>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());