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 that I am
importing via phpmyadmin
I guess I will just do it that way. When I am importing a file just
add the field names
that I am bringing in.
Thanks to all,
Néstor :-)
On 7/5/06, Chris <[EMAIL PROTECTED]> wrote:
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(100) NOT NULL default '',
> bid_sub_desc varchar(100) default '',
> bid_sub_amount varchar(20) NULL default '',
> bid_winner tinyint(1) NOT NULL default '0',
> bid_date TIMESTAMP,
> PRIMARY KEY (bid_id),
> UNIQUE KEY proj_prop (bid_proj_name,bid_prop_name)
> ) TYPE=MyISAM;
>
>
> and I am trying toload a file with the following data:
> ,Construction Management,RCG Consulting,,Orly-Belle,,,,
> ,Construction Management,RCG Consulting,,American Engineers,,,,
>
> I am using phpmyadmin and the date always gets enter as 00000000000000
>
> What do I need to do to force the current time stamp?
> I am using mysql version 4.0.21-standard
Don't specify the bid_date as an empty string - ie take the last ","
from the end. The empty string is being converted to '000000' because
it's an invalid date.
If you don't specify that column, it will default to 'now()'.
mysql> insert into bid(bid_proj_name) values ('test');
Query OK, 1 row affected (0.00 sec)
mysql> insert into bid(bid_proj_name, bid_date) values ('test 2', '');
Query OK, 1 row affected (0.01 sec)
mysql> select bid_id, bid_proj_name, bid_date from bid;
+--------+---------------+----------------+
| bid_id | bid_proj_name | bid_date |
+--------+---------------+----------------+
| 1 | test | 20060706110203 |
| 2 | test 2 | 00000000000000 |
+--------+---------------+----------------+
2 rows in set (0.00 sec)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
