计算机2204

/*
Navicat MySQL Data Transfer

Source Server : 8
Source Server Version : 80032
Source Host : localhost:3306
Source Database : shixun

Target Server Type : MYSQL
Target Server Version : 80032
File Encoding : 65001

Date: 2023-06-26 17:13:41
*/

SET FOREIGN_KEY_CHECKS=0;

– Table structure for t_goods

DROP TABLE IF EXISTS t_goods;
CREATE TABLE t_goods (
id int NOT NULL AUTO_INCREMENT,
name varchar(128) DEFAULT NULL,
price varchar(60) DEFAULT NULL,
number int DEFAULT NULL,
desc text,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

– Records of t_goods

INSERT INTO t_goods VALUES (‘1’, ‘嘿嘿123’, ‘吉林’, ‘10’, ‘您好’);
INSERT INTO t_goods VALUES (‘15’, ‘旺财’, ‘9999’, ‘12’, ‘可爱滴小狗’);
INSERT INTO t_goods VALUES (‘26’, ‘小明’, ‘吉林长春’, ‘1’, ‘哈哈’);
INSERT INTO t_goods VALUES (‘27’, ‘李雷’, ‘吉林’, ‘1’, ‘哈哈’);
INSERT INTO t_goods VALUES (‘28’, ‘哈’, ‘吉林’, ‘12’, ‘’);