**建了一个叫library的表**
CREATE TABLE `Library table`图书表
(
Title INT,
Title VARCHAR(wireless),#NOT NULL非空约束
sex CHAR(1),#`DEFAULT`(col_name)默约束
number VARCHAR(10),
birthday datetime
)DEFAULT CHARSET=utf8;
**查询语句**
SELECT*FROM
`MyCompany`
WHERE
`Edate `
BETWEEN 2011
AND 2013;
DELETE FROM `MyCompany` WHERE `Eid`=4;
**查找表中name里有“燕字的女生”**
SELECT
*
FROM
`MyCompany`
WHERE
`Ename` LIKE '%燕%'
OR sex = '女';
