mysql常用命令

login:mysql -uroot -padmindcj

logout:quit ;

logout:exit;

显示版本：status;

创建数据库：create database DBname;

查看数据库：show databases;

选择数据库：use DBname;

删除数据库：drop database DBname;

创建表：create table test(deptno int,dname varchar(20),loc varchar(40));

删除表：drop table test;

插入数据：insert into tablename(field1,field2,field3,fieldn) values(values11,values21,values31,valuesn1)((values12,values22,values32,valuesn2)(values1mvalues2m,values3m,valuesnm)

insert into tb_name1(field1,field2,field3,fieldn)  select (field1,field2,field3,fieldn) from tb_name2 where condition

更新数据：update tablename set  field1=value1 where condition

删除数据：delete from tablename where condition