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;