操作数据库 [文件夹]
create database db001 charset='gbk';
show databases;
show create database db001;
+
| Database | Create Database |
+
| db001 | CREATE DATABASE `db001` |
+
CREATE DATABASE `db002`
alter database db002 charset='utf8';
drop database db002;
操作数据表 [文件]
在操作表(文件)的时候 需要指定所在的库(文件夹)
select database();
use db001;
create table t1(id int,name char(4));
show tables;
show create table t1;
"""
Table: t1
Create Table: CREATE TABLE `t1` (
`id` int(11) DEFAULT NULL,
`name` char(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
"""
describe t1;
+
| Field | Type | Null | Key | Default | Extra |
+
| id | int(11) | YES | | NULL | |
| name | char(1) | YES | | NULL | |
+
alter table t1 modify name char(16);
drop table t1;
操作记录 [文件的内容]
一定要先有库, 有表, 最后才能操作记录
insert into t1 values(1,'steven');
insert into t1 values(1,'steven'),(2,'sammi');
select * from t1;
select name from t1;
update t1 set name='DSB' where id = 1;
delete from t1 where id = 1;
delete from t1 where name='sammi';
delete from t1;