可以正确创建数据表的源码如下，分享给大家

Question

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)

Answer 1

也太low了， laravel只需要使用面向对象，写代码就可建表生成数据。不需要像你这样写原生sql建表语句。