创建数据库:
mysql> create database abc;
连接数据库:
mysql> use abc;
创建表:
mysql> create table biao1 (id int,name char(10));
插入数据:
mysql> insert into biao1 (id,name) values (1,'z3');
mysql> insert into biao1 (id,name) values (2,'l4');
查看数据:
mysql> select * from biao1;
修改数据:
mysql> update biao1 set name='lll' where id=2;
删除数据:
mysql> delete from biao1 where id=2;
删除表:
mysql> drop table biao1;
删除数据库:
mysql> drop database abc;
显示mysql信息:
mysql> status;
退出mysql:
mysql> exit;
查看数据库名:
mysql> show databases;
查看表名:
mysql> show tables;