Re: automatic timestamp

2006-07-06 Thread Nestor
Scott, I do not think that is how it works under revision 4.0.21. Thanks, Néstor :-) On 7/5/06, Scott Haneda [EMAIL PROTECTED] wrote: People, I have the following table: DROP TABLE IF EXISTS bid; CREATE TABLE bid ( bid_id int(11) NOT NULL auto_increment, bid_proj_name varchar(100)

Re: automatic timestamp

2006-07-06 Thread Nestor
Chris, my situation is that I am reading a file using phpmyadmin and whne I do not add the extra , then I get an invalid number of records, so I have to have the extra , When I do an insert without the last comma, it does set the correct day. I do not know that it will work if I add the fields

automatic timestamp

2006-07-05 Thread Nestor
People, I have the following table: DROP TABLE IF EXISTS bid; CREATE TABLE bid ( bid_id int(11) NOT NULL auto_increment, bid_proj_name varchar(100) NOT NULL default '', bid_prop_name varchar(100) NOT NULL default '', bid_amount varchar(20) NULL default '', bid_sub_name varchar(100) NOT NULL

Re: automatic timestamp

2006-07-05 Thread Scott Haneda
People, I have the following table: DROP TABLE IF EXISTS bid; CREATE TABLE bid ( bid_id int(11) NOT NULL auto_increment, bid_proj_name varchar(100) NOT NULL default '', bid_prop_name varchar(100) NOT NULL default '', bid_amount varchar(20) NULL default '', bid_sub_name

Re: automatic timestamp

2006-07-05 Thread Chris
Nestor wrote: People, I have the following table: DROP TABLE IF EXISTS bid; CREATE TABLE bid ( bid_id int(11) NOT NULL auto_increment, bid_proj_name varchar(100) NOT NULL default '', bid_prop_name varchar(100) NOT NULL default '', bid_amount varchar(20) NULL default '', bid_sub_name