创建一个数据库
create database op;
删除一个数据库
drop database op;
创建一个数据表
表结构:
- id 自增长 主键 唯一
- title 不为空
- author 不为空
- join_date 日期
create table runoob(
runoob_id INT AUTO_INCREMENT NOT NULL,
runoob_title varchar(100) NOT NULL,
runoob_author varchar(32) NOT NULL,
join_date DATE,
PRIMARY KEY(runoob_id)
);
增加一条数据:
INSERT INTO runoob(runoob_title,runoob_author,join_date)
values ('hehe','wotereman',NOW());
删除一条数据:
delete from runoob where runoob_id = 1;
修改一条数据:
UPDATE runoob
SET runoob_title = "google.hk"
where runoob_id = 4;
查询一条数据:
SELECT runoob_id,runoob_title,runoob_author,join_date FROM runoob;
查询一条数据(简化写法):
SELECT * FROM runoob;