PDO是一個數(shù)據(jù)庫抽象層,通過它可以連接oracle,mysql等數(shù)據(jù)庫,不會PDO可以直接用mysqli的方法連接數(shù)據(jù)庫
2017-07-23
INSERT shop_product VALUES(NULL,'APPLEWATCH','998','1','apple','熱銷');
INSERT shop_product VALUES(NULL,'APPLEWATCH2','998','1','apple','new prod
uct');
修改數(shù)據(jù)庫編碼:ALTER DATABASE aha2 CHARACTER SET=utf8;
INSERT shop_product VALUES(NULL,'APPLEWATCH2','998','1','apple','new prod
uct');
修改數(shù)據(jù)庫編碼: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