mysql date&datetime类型更新问题
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
页:
[1]