sql

登录
CREATE DATABASE S1
use DATABASE S1


__________________________________
保存文件:--->d:mysql.sql
CREATE TABLE s1.book
(
id VARCHAR(30),
name VARCHAR(30),
price NUMERIC(6,2),
PRIMARY KEY(id)
);
INSERT INTO book VALUES(10001,'English',30);
INSERT INTO book VALUES(10002,'Chinese',40);
INSERT INTO book VALUES(10003,"Java",60);
___________________________________
. d:mysql.sql
SELECT *FROM book;

版权声明：本文为博主原创文章，未经博主允许不得转载。