mysql数据库控制台

简单命令

show databases;     use mysql(选择数据库)  create database wzq; drop database wzq;show tables;

表格的增删查改

show databases;

create database wzq;

use wzq;

create table table1(id int auto_increment,usename varchar(45),password varchar(45),primary key(id));

desc table1;(显示)

drop table table1;

show table tables;

insert into table1(usename,password) values("wzq","wzq");

insert into table1(usename,password) values("wzq1","wzq2");

select *from table1;

update table1       set usename="123",password="2345"  where id=1;

delete from table1 where id=1;

select *from table1;

select *from table1 limit x1,x2;(从x1开始查，查询x2条数据)

order by desc(反向排序)