INSERT shop_product VALUES(NULL,'APPLEWATCH','998','1','apple','热销');
INSERT shop_product VALUES(NULL,'APPLEWATCH2','998','1','apple','new prod
uct');
修改数据库编码:ALTER DATABASE aha2 CHARACTER SET=utf8;
INSERT shop_product VALUES(NULL,'APPLEWATCH2','998','1','apple','new prod
uct');
修改数据库编码:ALTER DATABASE aha2 CHARACTER SET=utf8;
2017-07-23
CREATE TABLE shop_product2(
id SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(50) NOT NULL,
price float(8,2) DEFAULT 0.00 NOT NULL,
storage SMALLINT UNSIGNED DEFAULT 0,
brand VARCHAR(20),
status VARCHAR(20));
id SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(50) NOT NULL,
price float(8,2) DEFAULT 0.00 NOT NULL,
storage SMALLINT UNSIGNED DEFAULT 0,
brand VARCHAR(20),
status VARCHAR(20));
2017-07-23
CREATE TABLE shop_cart(
id SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
producted bigint(20) UNSIGNED DEFAULT 0,
userid bigint(20) UNSIGNED DEFAULT 0,
num int(10) UNSIGNED DEFAULT 1,
price FLOAT(8,2) DEFAULT 0.00,
);
id SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
producted bigint(20) UNSIGNED DEFAULT 0,
userid bigint(20) UNSIGNED DEFAULT 0,
num int(10) UNSIGNED DEFAULT 1,
price FLOAT(8,2) DEFAULT 0.00,
);
2017-07-23