休息休息夏的博客

1.去重，Like查询 # 去除重复的值DISTINCT # 查询age不重复的值(某列) SELECT DISTINCT age FROM teacher; # 查询age不重复的值(某行) SELECT DISTINCT id,name,age,scode,mScore FROM teacher; # Like SELECT * FROM teacher WHERE `name` LIKE 'weidong' # like 带 % # 查询teacher表中name字段值以w开头的name值 # %

CREATE TABLE teacher( id INT, name VARCHAR (20), age INT, code INT, score INT ); INSERT INTO teacher VALUES(1,'李四',25,001,59); INSERT INTO teacher VALUES(2,'王五',25,002,60); INSERT INTO teacher VALUES(3,'六',25,003,70); INSERT INTO teacher VALUES(4,'七',25,00

插入，数据库约束，设置列值自动增长 1.插入数据 语法1 #INSERT INTO 表名（列名1，列名2）VALUES（值1，值2）； INSERT INTO person (id,name) VALUES(1,'李四') 语法2：不指定列名 但是要按照数据库表中的顺序，进行书写 INSERT INTO person VALUES(NULL ,'李四') 2.数据库约束 #表的约束：维护数据完整性，给列唯一的标识 #创建表时候设置主键约束 CREATE TABLE student( id IN

1.数据库基本使用 1.创建数据库并指定编码 CREATE DATABASE test2 CHARACTER SET 'GBK' SHOW DATABASES; 2.查看数据库语句 SHOW CREATE DATABASE test2 3.修改数据库的编码 ALTER DATABASE test2 CHARACTER set 'aaa' 4.删除数据库 CREATE DATABASE test3 CHARACTER #DROP DATABASE test3; 5.切换数据库 USE test2;