sql.sql
上传用户:zhc3n3
上传日期:2022-07-30
资源大小:2750k
文件大小:2k
- create database addressBookDB;
- use addressBookDB;
- create table product(
- productid int identity primary key,
- productname varchar(50) not null,
- productprice money,
- productimage varchar(50),
- productauthor varchar(50) not null,--作者
- productpublishing varchar(50) not null, --出版社
- productintroduction varchar(500) not null--简介
- );
- create table users(
- userid int identity primary key,
- username varchar(50) not null,
- userpassword varchar(50) not null
- );
- insert into product values('JavaScript',50.21,'imagesb_image_5_1.jpg','BlueGentleman,','中国出版社','JavaScript是一门解释型语言')
- insert into product values('21天精通Javaweb',60.21,'imagesb_image_5_2.jpg','BlueGentleman,','长沙出版社','JavaWeb是越来越受欢迎')
- insert into product values('30天精通Java',50.21,'imagesb_image_5_3.jpg','BlueGentleman,','北京大学出版社','Java项目让你有成就感')
- insert into product values('JavaEE基础',50.21,'imagesb_image_5_4.jpg','BlueGentleman,','湖南大学出版社','企业级开发的基础')
- insert into product values('JavaScript与web',70.21,'imagesb_image_5_5.jpg','BlueGentleman,','湖南大学出版社','js与web 的运用')
- insert into product values('21天精通C语言',70.21,'imagesb_image_2_1.bmp','BlueGentleman,','湖南大学出版社','C是一门博大的语言')
- insert into product values('C语言常见错误',40.21,'imagesb_image_2_2.bmp','BlueGentleman,','师范大学出版社','错误不可怕,怕的是不敢面对')
- insert into product values('C语言宝典',90.21,'imagesb_image_2_4.bmp','BlueGentleman,','清华大学出版社','功夫需要去练,我们的宝典助你早日练成')
- insert into product values('C语言程序设计',60.21,'imagesb_image_2_5.bmp','BlueGentleman,','上海大学出版社','C语言经典程序设计')
- insert into product values('C语言实用教程',70.21,'imagesb_image_2_6.bmp','BlueGentleman,','湖南大学出版社','C语言的实用教程让你掌握C语言')
- select * from product
- select * from users
- select*from users where username='asas'