ch13.sql

来自「jsp 应用开发技术光盘 是《jsp应用开发技术》这本书的源代码」· SQL 代码 · 共 51 行

##############################################
## 第13章需要的建库文件                     ##
##                                          ##
## 可在登陆MySQL后使用source命令导入数据库  ##
##############################################

CREATE DATABASE jsp_test;
CREATE DATABASE sql_test;

USE sql_test;

CREATE TABLE student (
    stu_id CHAR(20),
    name CHAR(30) NOT NULL, 
    address VARCHAR(200),
    age INT,
    CONSTRAINT PRIMARY KEY (stu_id) 
);
CREATE TABLE test_table (
    clumn1 CHAR(10),
    clumn2 CHAR(20)
);

SHOW TABLES;

DROP TABLE test_table;

DESCRIBE student;
ALTER TABLE student ADD birthdate DATE;
DESCRIBE student;


ALTER TABLE student DROP age;
DESCRIBE student;


INSERT INTO student(stu_id, name, address, birthdate) VALUES('10', '张三', '北京','1980/01/01');
INSERT INTO student(stu_id, name, address, birthdate) VALUES('11', '李四', '湖南','1980/08/19');
SELECT * FROM student;

DELETE FROM student WHERE stu_id = '10';
SELECT * FROM student;

UPDATE student SET address = '北京' WHERE stu_id = '11';
SELECT * FROM student WHERE stu_id = '11';

SELECT stu_id, name, address FROM student WHERE stu_id = '11';

SELECT * FROM student WHERE stu_id = '11';