mysql 学习随笔

CREATE DATABASE person;
#创建数据库
use person;
#使用 数据库
CREATE TABLE persons(
ID int,
lastname VARCHAR(50),
firstname VARCHAR(50),
ad VARCHAR(255),
city VARCHAR(255),
PRIMARY KEY (ID));
#新建表 persons
INSERT into persons VALUES(1,'yi','li','海淀区','北京');
INSERT into persons VALUES(2,'er','li','昌平区','北京');
INSERT into persons VALUES(3,'san','li','朝阳区','北京');
INSERT into persons VALUES(4,'si','li','大兴区','北京');
INSERT into persons VALUES(5,'wu','li','房山区','北京');
INSERT into persons VALUES(6,'liu','li','密云区','北京');
#插入数据
INSERT into persons VALUES(6,'qi','li','通州区','北京');
#主键约束，id相同插入失败
INSERT INTO persons
VALUES
    (
        7,
        'qi',
        'li',
        '通州区',
        '北京'
    );
#插入数据
DESC persons;
#显示数据表结构
SELECT * FROM persons;
#显示数据表中数据。
UPDATE persons SET firstname='wang' WHERE ID=4;
UPDATE persons SET firstname='hao' WHERE ID=5;
#更新第4行数据
INSERT into persons (ID,ad,city) VALUES(0,'怀柔区','北京');
#增加指定字段数据
SELECT lastname, firstname FROM persons;
#查询姓名两列
SELECT ID,lastname,firstname FROM persons WHERE firstname='li';
#查询姓li的数据行
SELECT ad FROM persons;
SELECT city FROM persons;
#查询列字段
SELECT DISTINCT city FROM persons;
#查询不重复的列值