mysql基础

update user set id=1 where username=zhangsan;
alter database mysql character set utf8;
alter table user drop id;
alter table user modify username varchar(60);
alter table user change id username varchar(60);   //modify修改数据类型，change修改列名和数据类型
alter table user add stenedu varchar(60);
rename table user to stdeu;
inster into user value('1','张三');
inster into user(id) value(6);
delete from user;
delete from user where username=zhangsan;
drop database mysql;
drop table user;
select * from user;
select id from user;
select zhangsan.* from user;
seletc * from user where username=zhangsan;
select * from user where username=zhangsan order by id desc;
select * from user where username=zhangsan order by id asc;   //asc升序,desc降序
create table stedu(
    id int
    username varchar(60)
    primary key,id int || primary key(id)
)
alter table stedu drop primary key(id)
create database stedu character set utf8;
show databases;
show tables;
show create database stedu;
show create table stedu;     //查看创建的库和表的属性
create user zhangsan;
grant all privileges on *.* to "zhangsan"@"%" identified by 'fame@community!';
grant all privileges on *.* to "zhangsan"@"localhost" identified by 'fame@community!';
flush privileges;
create index id on stedu;      //创建索引
drop index id on stedu;    //删除索引