MySQL 基础篇
数据准备:
CREATE TABLE products ( prod_id CHAR(10) NOT NULL , vend_id CHAR(10) NOT NULL , prod_name CHAR(255) NOT NULL , prod_price DECIMAL(8,2) NOT NULL , prod_desc VARCHAR(1000) NULL ); INSERT INTO products(prod_id, vend_id
MySQL 基础篇
数据准备:
CREATE TABLE products ( prod_id CHAR(10) NOT NULL , vend_id CHAR(10) NOT NULL , prod_name CHAR(255) NOT NULL , prod_price DECIMAL(8,2) NOT NULL , prod_desc VARCHAR(1000) NULL ); INSERT INTO products(prod_id, vend_id