我现在要插入一个2010--03--11,但在mysql里存储的类型的varcahr类型,
mysql> insert into project values(2,'自然语言理解','是计算机理解人类语言,主要是
中文',2010-03-11);
这样出入的话得不到自己想要的结果
‘2010-03-11’加里引号的话,插入就不正确,你有处理的方式吗
mysql> insert into project values(2,'自然语言理解','是计算机理解人类语言,主要是
中文',2010-03-11);
这样出入的话得不到自己想要的结果
‘2010-03-11’加里引号的话,插入就不正确,你有处理的方式吗
+-------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| id | int(4) | NO | PRI | NULL | |
| name | varchar(100) | YES | | NULL | |
+-------+--------------+------+-----+---------+-------+
2 rows in set (0.06 sec)mysql> select * from testproc1;
+----+------+
| id | name |
+----+------+
| 1 | 1 |
+----+------+
1 row in set (0.00 sec)mysql> insert into testproc1 values (2,2010-11-11);
Query OK, 1 row affected (0.02 sec)mysql> select * from testproc1;
+----+------+
| id | name |
+----+------+
| 1 | 1 |
| 2 | 1988 |
+----+------+
2 rows in set (0.00 sec)mysql> insert into testproc1 values (2,'2010-11-11');
ERROR 1062 (23000): Duplicate entry '2' for key 1
mysql> insert into testproc1 values (3,'2010-11-11');
Query OK, 1 row affected (0.00 sec)mysql> select * from testproc1;
+----+------------+
| id | name |
+----+------------+
| 1 | 1 |
| 2 | 1988 |
| 3 | 2010-11-11 |
+----+------------+
3 rows in set (0.00 sec)