MySQL数据库基本语句

**建了一个叫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 = '女';