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 fiel

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 varc

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 varchar

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_nam

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