MySQL的字符型数据类型:
1.varchar(目前不打算考虑长度问题)
//分解学习MySql数据类型:
//字符型:
//建表
CREATE TABLE dataType_varchar(
NAME VARCHAR(255)
);
//插入数据
INSERT INTO dataType_varchar(NAME) VALUES('demo');//目前不用考虑字段长短问题
INSERT INTO dataType_varchar(NAME) VALUES('jack');
INSERT INTO dataType_varchar(NAME) VALUES('tom');
INSERT INTO dataType_varchar(NAME) VALUES('li');
INSERT INTO dataType_varchar(NAME) VALUES('yi');
//查
SELECT * FROM dataType_varchar;
SELECT * FROM dataType_varchar dv WHERE dv.name LIKE '%d%';
SELECT * FROM dataType_varchar dv WHERE dv.name LIKE 'd%';
SELECT * FROM dataType_varchar dv WHERE dv.name NOT LIKE '%f%';
SELECT * FROM dataType_varchar dv WHERE dv.name = 'demo';
SELECT * FROM dataType_varchar dv WHERE dv.name != 'demo';
SELECT * FROM dataType_varchar dv WHERE dv.name IN('demo');
SELECT * FROM dataType_varchar dv WHERE dv.name NOT IN('emo');
SELECT * FROM dataType_varchar dv WHERE dv.name IN('demo');
SELECT * FROM dataType_varchar dv WHERE dv.name NOT IN('emo');
SELECT * FROM dataType_varchar dv WHERE dv.name LIKE '_emo';
SELECT * FROM dataType_varchar dv WHERE dv.name LIKE '_e__';//_ e _ _;
SELECT dv.* FROM dataType_varchar dv WHERE dv.name LIKE '[ly]i';//不好用....
//改
UPDATE datatype_varchar dv SET dv.name='love' WHERE dv.name LIKE 'tom';
//删
DELETE FROM datatype_varchar WHERE NAME LIKE '%demo%';