mysql> desc nongfu.ecs_users;
+-----------------+------------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+------------------------+------+-----+---------------------+----------------+
| user_id | mediumint(8) unsigned | NO | PRI | NULL | auto_increment |
| email | varchar(60) | NO | MUL | | |
| user_name | varchar(60) | NO | UNI | | |
| password | varchar(32) | NO | | | |
| question | varchar(255) | NO | | | |
| answer | varchar(255) | NO | | | |
| sex | tinyint(1) unsigned | NO | | 0 | |
| birthday | date | NO | | 1000-01-01 | |
| user_money | decimal(10,2) | NO | | 0.00 | |
| frozen_money | decimal(10,2) | NO | | 0.00 | |
| pay_points | int(10) unsigned | NO | | 0 | |
| rank_points | int(10) unsigned | NO | | 0 | |
| address_id | mediumint(8) unsigned | NO | | 0 | |
| reg_time | int(10) unsigned | NO | | 0 | |
| last_login | int(11) unsigned | NO | | 0 | |
| last_time | datetime | NO | | 1000-01-01 00:00:00 | |
| last_ip | varchar(15) | NO | | | |
| visit_count | smallint(5) unsigned | NO | | 0 | |
| user_rank | tinyint(3) unsigned | NO | | 0 | |
| is_special | tinyint(3) unsigned | NO | | 0 | |
| ec_salt | varchar(10) | YES | | NULL | |
| salt | varchar(10) | NO | | 0 | |
| parent_id | mediumint(9) | NO | MUL | 0 | |
| flag | tinyint(3) unsigned | NO | MUL | 0 | |
| alias | varchar(60) | NO | | NULL | |
| msn | varchar(60) | NO | | NULL | |
| qq | varchar(20) | NO | | NULL | |
| office_phone | varchar(20) | NO | | NULL | |
| home_phone | varchar(20) | NO | | NULL | |
| mobile_phone | varchar(20) | NO | | NULL | |
| is_validated | tinyint(3) unsigned | NO | | 0 | |
| credit_line | decimal(10,2) unsigned | NO | | NULL | |
| passwd_question | varchar(50) | YES | | NULL | |
| passwd_answer | varchar(255) | YES | | NULL | |
+-----------------+------------------------+------+-----+---------------------+----------------+
34 rows in set
执行以下代码错误:
update nongfu.ecs_users set birthday = '1955-01-01' where birthday = '0000-00-00';
update nongfu.ecs_users set last_time = '1000-01-01 00:00:00' where last_time = '0000-00-00 00:00:00';
正确的写法:
update nongfu.ecs_users set birthday = '1955-01-01' where birthday = 0000-00-00;
update nongfu.ecs_users set last_time = '1000-01-01 00:00:00' where last_time = 0000-00-00;
转载于:https://blog.51cto.com/cmdschool/1709479