java访问数据库的sql

weixin_33775582

于 2014-11-18 16:17:00 发布

阅读量50

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 java

原文链接：http://www.cnblogs.com/ketang/p/4106075.html

本文档展示了如何使用SQL语句创建名为STOREDB的数据库，并在此数据库中创建CUSTOMERS和ORDERS两个表，同时插入了一些示例数据。

drop database if exists STOREDB;
create database STOREDB;
use STOREDB;

create table CUSTOMERS (
ID bigint not null auto_increment primary key,
NAME varchar(16) not null,
AGE INT,
ADDRESS varchar(255)
);

create table ORDERS (
ID bigint not null auto_increment primary key,
ORDER_NUMBER varchar(16) not null,
PRICE FLOAT,
CUSTOMER_ID bigint,
foreign key(CUSTOMER_ID) references CUSTOMERS(ID)
);

insert into CUSTOMERS(ID,NAME,AGE,ADDRESS) values(1, '小张',23, '北京');
insert into CUSTOMERS(ID,NAME,AGE,ADDRESS) values(2,'小红',29, '天津');
insert into CUSTOMERS(ID,NAME,AGE,ADDRESS) values(3,'小丁',33, '山东');

insert into ORDERS(ID,ORDER_NUMBER,PRICE,CUSTOMER_ID) values(1, '小张_001',100.12, 1);
insert into ORDERS(ID,ORDER_NUMBER,PRICE,CUSTOMER_ID) values(2, '小张_002',200.32, 1);
insert into ORDERS(ID,ORDER_NUMBER,PRICE,CUSTOMER_ID) values(3, '小红_001',88.44, 2);

转载于:https://www.cnblogs.com/ketang/p/4106075.html