wpf 执行mysql命令_WPF 数据绑定数据库脚本（MySQL）

CREATE DATABASE store;

use store;

CREATE TABLE categories(category_id INT NOT NULL,category_name VARCHAR(50),PRIMARY KEY(category_id));

CREATE TABLE products(product_id INT NOT NULL,category_id INT NOT NULL,model_number VARCHAR(50),model_name VARCHAR(50),

product_image VARCHAR(50),unit_cost DECIMAL(10,2),description TEXT,FOREIGN KEY(category_id) REFERENCES categories(category_id));

USE store;

INSERT INTO categories(category_id,category_name) VALUES(1,"STKY");

INSERT INTO products(product_id,category_id,model_number,model_name,product_image,unit_cost,description)

VALUES(1,1,"Edible Tape","STKY1","This a new Test for DataBind",3.99,"The latest in personal survival geat,the

STKY1 looks like a rool of ordinary office tape,but can save your life in an emergency.Just remove the tape roll

and place in a kettle of bolling with mixed vegetables and a ham shank.");