mysqlmysql设置
创建mysql下的表格：
create table member(
mid varchar(50) primary key,
password varchar(32) not null ,
name varchar(30) not null ,
address varchar(200) not null ,
telephone varchar(100) not null ,
zipcode varchar(6) not null ,
lastdate timestamp default now()
);
insert into member(mid,password,name,address,telephone,zipcode) values ('admin','222','admin','home','0101111','100191');
出现的表格如下：
mysql> select * from member;
+-------+----------+-------+---------+-----------+---------+---------------------+
| mid | password | name | address | telephone | zipcode | lastdate |
+-------+----------+-------+---------+-----------+---------+---------------------+
| admin | 222 | admin | home | 0101111 | 100191 | 2015-07-23 00:53:06 |
+-------+----------+-------+---------+-----------+---------+---------------------+
我不想设置的时间格式为“2015-07-23 00:53:06”，需要的结果是“ 2015-07-23”，
请问，我的格式该怎么设置和修改？