mysql搭建一个简单的数据库

最新推荐文章于 2024-06-09 17:16:02 发布

think_you_WL

最新推荐文章于 2024-06-09 17:16:02 发布

阅读量872

点赞数 2

文章标签： mysql utf-8 数据库

本文链接：https://blog.csdn.net/think_you_WL/article/details/78844104

版权

SET NAMES UTF8;
DROP DATABASE IF EXISTS dangdang;
CREATE DATABASE dangdang CHARSET=UTF8;
USE dangdang;
CREATE TABLE book(
bid INT PRIMARY KEY AUTO_INCREMENT,
bname VARCHAR (32),
price FLOAT (10,2),
pic VARCHAR (32)
);
INSERT INTO book VALUES
(NULL,’C编程指南’,’35.5’,’img/1.jpg’),
(NULL,’C++从入门到精通’,’35.5’,’img/2.jpg’),
(NULL,’javascript从入门到放弃’,’35.5’,’img/3.jpg’),
(NULL,’java权威指南’,’35.5’,’img/4.jpg’),
(NULL,’ActionScript入门’,’35.5’,’img/5.jpg’),
(NULL,’Android开发指南’,’35.5’,’img/6.jpg’),
(NULL,’编程指南一二三’,’35.5’,’img/7.jpg’),
(NULL,’设计模式’,’35.5’,’img/8.jpg’),
(NULL,’开发模式’,’35.5’,’img/9.jpg’),
(NULL,’运营模式’,’35.5’,’img/10.jpg’),
(NULL,’JS程序设计’,’35.5’,’img/11.jpg’),
(NULL,’C++程序设计’,’35.5’,’img/12.jpg’),
(NULL,’IOS开发指南’,’35.5’,’img/13.jpg’),
(NULL,’java和javascript’,’35.5’,’img/14.jpg’);