MySQL
创建一个数据库,创建三张表,并插入数据
表goods(商品表):
MySQL在较新的版本里,int后面是不需要加()定义长度的
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
`goodsid` int NOT NULL AUTO_INCREMENT,
`goodsname` varchar(50) NOT NULL,
`goodsnote` varchar(255) DEFAULT NULL,
`goodsprice` decimal(10,2) NOT NULL,
`goodsamount` int NOT NULL,
`goodsimg` varchar(255) DEFAULT NULL,
PRIMARY KEY (`goodsid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;
INSERT INTO `goods` VALUES ('1', '商品1', '商品1的介绍', '45.60', '30', 'img/1.jpg');
INSERT INTO `goods` VALUES ('2', '商品2', '商品2的介绍', '89.60', '60', 'img/2.png');
INSERT INTO `goods` VALUES ('3', '商品3', '商品3的介绍', '79.50', '90', 'img/3.png');
INSERT INTO `goods` VALUES ('4', '商品4', '商品4的介绍', '66.70', '100', 'img/4.jpg');
INSERT INTO `goods` VALUES ('5', '商品5', '商品5的介绍', '79.80', '50', 'img/5.png');
INSERT INTO `goods` VALUES ('6', '商品6', '商品6的介绍', '88.50', '90', 'img/6.jpg');
表userinfo(用户表):
DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo` (
`userid` varchar(50) NOT NULL,
`password` varchar(16) NOT NULL,
`username` varchar(30) NOT NULL,
PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO `userinfo` VALUES ('lisi', '123456', '李四');
INSERT INTO `userinfo` VALUES ('zhangsan', '123456', '张三');
表cars(购物车表):
DROP TABLE IF EXISTS `cars`;
CREATE TABLE `cars` (
`carid` int NOT NULL AUTO_INCREMENT,
`userid` varchar(50) DEFAULT NULL,
`goodsid` int DEFAULT NULL,
`goodsamount` int NOT NULL,
PRIMARY KEY (`carid`),
KEY `userinfofk` (`userid`),
KEY `goodsfk` (`goodsid`),
CONSTRAINT `goodsfk` FOREIGN KEY (`goodsid`) REFERENCES `goods` (`goodsid`