mysql基础语句01:
1.显示数据库命令:show databases;(注意加分号)
2.创建数据库:create database mydb2;
3.删除数据库:drop database mydb2;
4.显示数据库的定义信息:show create database mydb3;
5.用数据库:use mydb3;
6.创建表:create table tb_user (id int,user varchar(50));
7.显示表:show tables;
8.插入数据:insert into tb_user value (1,‘zhangsan’);
9.查询表:select * from tb_user;
10.更新数据库:update tb_user set id=1 where id=2;
11.删除表数据:delete from tb_user where id=2;