mysql操作
创建数据库后更改数据库编码(右击数据库名字)
CREATE DATABASE ex;
USE ex;
CREATE TABLE xs_shop(
x_id INT AUTO_INCREMENT PRIMARY KEY,
x_bh VARCHAR(50) NOT NULL,
x_date DATE,
x_number INT NOT NULL,
x_jg DECIMAL(10,2) NOT NULL,
x_zong DECIMAL(10,2) NOT NULL,
x_yg VARCHAR(20) NOT NULL
);
INSERT INTO xs_shop VALUES
(NULL,'xs1001','2013-12-2',124,134.5,16678,'张三'),
(NULL,'xs1002','2013-12-2',50,80,4000,'李四'),
(