Mysql 数据库学习 简单的增删改查

直接上代码：

注释比较详细 就不一一说明

补充：关于数据库默认值问题

默认值创建后是不会直接显示

需要对数据库进行增加才有机会触发

比如代码中的 _qianMing 默认值 Test

当你执行下面这个代码 才会默认显示

INSERT INTO teacher (_name,_age) VALUES('Yellow',12);

#删除表
DROP TABLE IF EXISTS teacher

#创建表
CREATE TABLE teacher(
	_id INT PRIMARY key auto_increment ,
	_name VARCHAR(10) NOT NULL DEFAULT 'TTTT' ,
  _age INT NOT NULL ,
  _qianMing VARCHAR(250) DEFAULT 'Test'
);

#表 Teacher 修改列 _qianMing 默认值
alter table teacher alter _qianMing set DEFAULT 'xxxxx';

#插入语句
INSERT INTO teacher (_name,_age) VALUES('Yellow',12);
INSERT INTO teacher (_name,_age,_qianMing) VALUES('blue',13,'HelloWorld');
INSERT INTO teacher (_name,_age,_qianMing) VALUES('red',14,'HelloWorld');
INSERT INTO teacher (_name,_age,_qianMing) VALUES('green',15,'HelloWorld');
INSERT INTO teacher (_name,_age,_qianMing) VALUES('black',16,'HelloWorld');


#删除语句
DELETE FROM teacher WHERE _name = 'blue'

#查询
SELECT _id,_name FROM teacher

#增加
UPDATE teacher SET _age=20 WHERE _name = 'green'