发表于： 2016-07-03 09:14:32
0 2455
CREATE DATABASE day03;
USE day03;
CREATE TABLE student(
id INT PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(20),
gender VARCHAR(2),
age INT
)
INSERT INTO student VALUES(1,'张三','男',20);
INSERT INTO student VALUES(2,'李四','男',30);
INSERT INTO student VALUES(3,'王五','男',40);
INSERT INTO student VALUES(4,'冯六','男',50);
UPDATE student SET gender='女',age=20 WHERE id=2;
SELECT * FROM student;
使用sqlyog建立了一个较为简单的数据库。明天做junit单元测试。
返回列表
评论