MySQL操作数据

插入数据
create table address (
id int null ,
name varchar(233) null ,
phone varchar(255) null ,
fax varchar(23) null ,
email varchar(255) null
);
describe address ;
insert into address ( id ) values( 33 );
select * from address ;

进阶插入数据
insert into set fname = '233';

default 'unix' not null ,
auto_increment ;自增主键
unique唯一的
更新数据，删除数据
update users set name = 'sdfsdf'
delete from user where uid = 3;
delete from user
show variables like '%sql_safe%'
set sql_safe_updates = 0 模式关掉了，防止误操作删除数据了

delete from tablename 删除每一行数据
truncat table tablenaem 彻底清空数据， 自增主键重新开始了 1 删除整个表，重建了整个表了

转载于:https://my.oschina.net/u/1169736/blog/526721