課程
/后端開發
/PHP
/手把手教你實現電商網站后臺開發
66個錯誤怎么破
2017-12-04
源自：手把手教你實現電商網站后臺開發 1-2
正在回答
CREATE DATABASE IF NOT EXISTS`shop`;
USE`shop`;
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`(
`id` tinyint unsigned auto_increment key,
`username` varchar(20) not null unique,
`password` char(32) not null,
`email` varchar(50) not null
);
DROP TABLE IF EXISTS `cate`;
CREATE TABLE `cate`(
`id` smallint unsigned auto_increment key,
`cName` varchar(50) unique
DROP TABLE IF EXISTS `pro`;
CREATE TABLE `pro`(
? ? ?`id` int unsigned auto_increment key,
? ? ?`pName` varchar(50) not null unique,
? ? ?`pSn` varchar(50) not null,
? ? ?`pNum` int unsigned default 1,
? ? ?`mPrice` decimal(10,2) not null,
? ? ?`iPrice` decimal(10,2) not null,
? ? ?`pDesc` text,
? ? ?`pImg` varchar(50) not null,
? ? ?`pubTime` int unsigned not null,
? ? ?`isShow` tinyint(1) default 1,
? ? ?`isHot` tinyint(1) default 0,
? ? ?`cId` smallint unsigned not null
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`(
`id` int unsigned auto_increment key,
`password`char(32) not null,
`sex`enum("男","女","保密")not null default "保密",
`face` varchar(50) not null,
`regTime`int unsigned not null
DROP TABLE IF EXISTS `album`;
CREATE TABLE `album`(
`pid` int unsigned not null,
`albumPath` varchar(50) not null
)
mengniu 提問者
CREATE DATABASE IF NOT EXISTS`shopImooc`;
USE`shopImooc`;
DROP TABLE IF EXISTS `imooc_admin`;
CREATE TABLE `imooc_admin`(
DROP TABLE IF EXISTS `imooc_cate`;
CREATE TABLE `imooc_cate`(
DROP TABLE IF EXISTS `imooc_pro`;
CREATE TABLE `imooc_pro`(
DROP TABLE IF EXISTS `imooc_user`;
CREATE TABLE `imooc_user`(
)charset='utf8';
DROP TABLE IF EXISTS `imooc_album`;
CREATE TABLE `imooc_album`(
舉報
手把手教你用PHP搭建電子商務平臺，由淺入深教你搭建電商系統
Copyright ? 2025 imooc.com All Rights Reserved | 京ICP備12003892號-11 京公網安備11010802030151號
購課補貼聯系客服咨詢優惠詳情
慕課網APP您的移動學習伙伴
掃描二維碼關注慕課網微信公眾號
2017-12-05
CREATE DATABASE IF NOT EXISTS`shop`;
USE`shop`;
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`(
`id` tinyint unsigned auto_increment key,
`username` varchar(20) not null unique,
`password` char(32) not null,
`email` varchar(50) not null
);
DROP TABLE IF EXISTS `cate`;
CREATE TABLE `cate`(
`id` smallint unsigned auto_increment key,
`cName` varchar(50) unique
);
DROP TABLE IF EXISTS `pro`;
CREATE TABLE `pro`(
? ? ?`id` int unsigned auto_increment key,
? ? ?`pName` varchar(50) not null unique,
? ? ?`pSn` varchar(50) not null,
? ? ?`pNum` int unsigned default 1,
? ? ?`mPrice` decimal(10,2) not null,
? ? ?`iPrice` decimal(10,2) not null,
? ? ?`pDesc` text,
? ? ?`pImg` varchar(50) not null,
? ? ?`pubTime` int unsigned not null,
? ? ?`isShow` tinyint(1) default 1,
? ? ?`isHot` tinyint(1) default 0,
? ? ?`cId` smallint unsigned not null
);
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`(
`id` int unsigned auto_increment key,
`username` varchar(20) not null unique,
`password`char(32) not null,
`sex`enum("男","女","保密")not null default "保密",
`face` varchar(50) not null,
`regTime`int unsigned not null
);
DROP TABLE IF EXISTS `album`;
CREATE TABLE `album`(
`id` int unsigned auto_increment key,
`pid` int unsigned not null,
`albumPath` varchar(50) not null
)
2018-03-18
CREATE DATABASE IF NOT EXISTS`shopImooc`;
USE`shopImooc`;
DROP TABLE IF EXISTS `imooc_admin`;
CREATE TABLE `imooc_admin`(
`id` tinyint unsigned auto_increment key,
`username` varchar(20) not null unique,
`password` char(32) not null,
`email` varchar(50) not null
);
DROP TABLE IF EXISTS `imooc_cate`;
CREATE TABLE `imooc_cate`(
`id` smallint unsigned auto_increment key,
`cName` varchar(50) unique
);
DROP TABLE IF EXISTS `imooc_pro`;
CREATE TABLE `imooc_pro`(
? ? ?`id` int unsigned auto_increment key,
? ? ?`pName` varchar(50) not null unique,
? ? ?`pSn` varchar(50) not null,
? ? ?`pNum` int unsigned default 1,
? ? ?`mPrice` decimal(10,2) not null,
? ? ?`iPrice` decimal(10,2) not null,
? ? ?`pDesc` text,
? ? ?`pImg` varchar(50) not null,
? ? ?`pubTime` int unsigned not null,
? ? ?`isShow` tinyint(1) default 1,
? ? ?`isHot` tinyint(1) default 0,
? ? ?`cId` smallint unsigned not null
);
DROP TABLE IF EXISTS `imooc_user`;
CREATE TABLE `imooc_user`(
`id` int unsigned auto_increment key,
`username` varchar(20) not null unique,
`password`char(32) not null,
`sex`enum("男","女","保密")not null default "保密",
`face` varchar(50) not null,
`regTime`int unsigned not null
)charset='utf8';
DROP TABLE IF EXISTS `imooc_album`;
CREATE TABLE `imooc_album`(
`id` int unsigned auto_increment key,
`pid` int unsigned not null,
`albumPath` varchar(50) not null
)