MySQL常用命令介绍

1.show databases;   输出所有数据库

2.use test;(你选择的数据库);

3.show tables;

     

4.show tables in mysql;

5.select database();            

6.create table stuinfo(

id int,

name varchar(20));

7.desc stuinfo;

8.INSERT INTO stuinfo(id,NAME) VALUES(1,"john")
   SELECT * FROM stuinfo;

9.UPDATE stuinfo SET NAME="yyzhang" WHERE id=1

10.DELETE FROM stuinfo WHERE id=1;