三个sql文件，后缀改为sql导入navicat

最新推荐文章于 2024-05-21 21:08:02 发布

zhangsan3333

最新推荐文章于 2024-05-21 21:08:02 发布

阅读量970

点赞数

文章标签： sql 数据库 database

aaa

本文链接：https://blog.csdn.net/djydjy3333/article/details/121950820

版权

数据库名为progate
在这里插入图片描述

3个表为以下，items,sales_records,users
items.sql

/*
 Navicat Premium Data Transfer

 Source Server         : MySQL57
 Source Server Type    : MySQL
 Source Server Version : 50735
 Source Host           : localhost:3306
 Source Schema         : progate

 Target Server Type    : MySQL
 Target Server Version : 50735
 File Encoding         : 65001

 Date: 15/12/2021 14:53:43
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for items
-- ----------------------------
DROP TABLE IF EXISTS `items`;
CREATE TABLE `items`  (
  `id` int(13) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `gender` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `price` decimal(10, 2) NULL DEFAULT NULL,
  `cost` decimal(10, 2) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of items
-- ----------------------------
INSERT INTO `items` VALUES (1, 'スカート', '1', 4000.00, 800.00);
INSERT INTO `items` VALUES (2, 'デニムパンツ', '0', 6500.00, 2900.00);
INSERT INTO `items` VALUES (3, 'デニムパンツ', '1', 6000.00, 2600.00);
INSERT INTO `items` VALUES (4, 'キャップ', '2', 1500.00, 300.00);
INSERT INTO `items` VALUES (5, 'ブラウス', '1', 8000.00, 2000.00);
INSERT INTO `items` VALUES (6, '靴下', '2', 1000.00, 250.00);
INSERT INTO `items` VALUES (7, 'カットソー', '1', 3400.00, 200.00);
INSERT INTO `items` VALUES (8, 'ショートパンツ', '1', 3200.00, 1100.00);
INSERT INTO `items` VALUES (9, 'ショートパンツ', '0', 2200.00, 900.00);
INSERT INTO `items` VALUES (10, '紺Tシャツ', '2', 2000.00, 900.00);
INSERT INTO `items` VALUES (11, '白Tシャツ', '2', 2000.00, 800.00);
INSERT INTO `items` VALUES (12, '黒Tシャツ', '2', 2300.00, 800.00);
INSERT INTO `items` VALUES (13, 'グレーTシャツ', '2', 2300.00, 1000.00);
INSERT INTO `items` VALUES (14, '青スニーカー', '2', 3000.00, 1400.00);
INSERT INTO `items` VALUES (15, '赤スニーカー', '2', 4200.00, 1600.00);
INSERT INTO `items` VALUES (16, '白スニーカー', '2', 4000.00, 1600.00);
INSERT INTO `items` VALUES (17, 'ランニングシューズ', '0', 7500.00, 2800.00);
INSERT INTO `items` VALUES (18, 'サンダル', '2', 1800.00, 500.00);
INSERT INTO `items` VALUES (19, '黒スキニー', '0', 3800.00, 1400.00);
INSERT INTO `items` VALUES (20, '黒スキニー', '1', 4000.00, 1600.00);
INSERT INTO `items` VALUES (21, '白スキニー', '0', 3200.00, 1300.00);
INSERT INTO `items` VALUES (22, '白スキニー', '1', 3200.00, 1300.00);
INSERT INTO `items` VALUES (23, 'レザージャケット', '1', 32000.00, 9800.00);
INSERT INTO `items` VALUES (24, '白ポロシャツ', '2', 3000.00, 1200.00);
INSERT INTO `items` VALUES (25, '黒ポロシャツ', '2', 3700.00, 1600.00);
INSERT INTO `items` VALUES (26, '紺パーカー', '2', 3800.00, 1100.00);
INSERT INTO `items` VALUES (27, '黒パーカー', '2', 3800.00, 1200.00);
INSERT INTO `items` VALUES (28, 'グレーパーカー', '2', 4200.00, 1300.00);
INSERT INTO `items` VALUES (29, 'マフラー', '2', 1800.00, 500.00);
INSERT INTO `items` VALUES (30, '赤コート', '1', 27000.00, 7500.00);

SET FOREIGN_KEY_CHECKS = 1;

sales_records.sql

/*
 Navicat Premium Data Transfer

 Source Server         : MySQL57
 Source Server Type    : MySQL
 Source Server Version : 50735
 Source Host           : localhost:3306
 Source Schema         : progate

 Target Server Type    : MySQL
 Target Server Version : 50735
 File Encoding         : 65001

 Date: 15/12/2021 14:53:58
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sales_records
-- ----------------------------
DROP TABLE IF EXISTS `sales_records`;
CREATE TABLE `sales_records`  (
  `id` int(11) NOT NULL,
  `user_id` int(11) NULL DEFAULT NULL,
  `item_id` int(11) NULL DEFAULT NULL,
  `purchased_at` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sales_records
-- ----------------------------
INSERT INTO `sales_records` VALUES (1, 204, 28, '2017-07-01');
INSERT INTO `sales_records` VALUES (2, 99, 8, '2017-07-01');
INSERT INTO `sales_records` VALUES (3, 97, 17, '2017-07-01');
INSERT INTO `sales_records` VALUES (4, 223, 22, '2017-07-01');
INSERT INTO `sales_records` VALUES (5, 130, 19, '2017-07-01');
INSERT INTO `sales_records` VALUES (6, 259, 12, '2017-07-01');
INSERT INTO `sales_records` VALUES (7, 266, 15, '2017-07-01');
INSERT INTO `sales_records` VALUES (8, 91, 29, '2017-07-01');
INSERT INTO `sales_records` VALUES (9, 166, 9, '2017-07-01');
INSERT INTO `sales_records` VALUES (10, 271, 9, '2017-07-01');
INSERT INTO `sales_records` VALUES (11, 159, 3, '2017-07-01');
INSERT INTO `sales_records` VALUES (12, 120, 17, '2017-07-01');
INSERT INTO `sales_records` VALUES (13, 143, 17, '2017-07-01');
INSERT INTO `sales_records` VALUES (14, 162, 15, '2017-07-01');
INSERT INTO `sales_records` VALUES (15, 206, 24, '2017-07-01');
INSERT INTO `sales_records` VALUES (16, 186, 15, '2017-07-01');
INSERT INTO `sales_records` VALUES (17, 38, 3, '2017-07-02');
INSERT INTO `sales_records` VALUES (18, 213, 15, '2017-07-02');
INSERT INTO `sales_records` VALUES (19, 302, 30, '2017-07-02');
INSERT INTO `sales_records` VALUES (20, 259, 3, '2017-07-02');
INSERT INTO `sales_records` VALUES (21, 56, 23, '2017-07-02');
INSERT INTO `sales_records` VALUES (22, 94, 17, '2017-07-02');
INSERT INTO `sales_records` VALUES (23, 64, 4, '2017-07-02');
INSERT INTO `sales_records` VALUES (24, 176, 8, '2017-07-02');
INSERT INTO `sales_records` VALUES (25, 206, 4, '2017-07-02');
INSERT INTO `sales_records` VALUES (26, 250, 23, '2017-07-02');
INSERT INTO `sales_records` VALUES (27, 28, 15, '2017-07-02');
INSERT INTO `sales_records` VALUES (28, 198, 15, '2017-07-02');
INSERT INTO `sales_records` VALUES (29, 124, 12, '2017-07-02');
INSERT INTO `sales_records` VALUES (30, 176, 10, '2017-07-03');
INSERT INTO `sales_records` VALUES (31, 94, 25, '2017-07-03');
INSERT INTO `sales_records` VALUES (32, 308, 30, '2017-07-03');
INSERT INTO `sales_records` VALUES (33, 133, 11, '2017-07-03');
INSERT INTO `sales_records` VALUES (34, 124, 3, '2017-07-03');
INSERT INTO `sales_records` VALUES (35, 239, 16, '2017-07-03');
INSERT INTO `sales_records` VALUES (36, 259, 10, '2017-07-03');
INSERT INTO `sales_records` VALUES (37, 244, 17, '2017-07-03');
INSERT INTO `sales_records` VALUES (38, 115, 12, '2017-07-03');
INSERT INTO `sales_records` VALUES (39, 124, 23, '2017-07-03');
INSERT INTO `sales_records` VALUES (40, 125, 29, '2017-07-03');
INSERT INTO `sales_records` VALUES (41, 165, 28, '2017-07-03');
INSERT INTO `sales_records` VALUES (42, 210, 25, '2017-07-04');
INSERT INTO `sales_records` VALUES (43, 217, 26, '2017-07-04');
INSERT INTO `sales_records` VALUES (44, 139, 15, '2017-07-04');
INSERT INTO `sales_records` VALUES (45, 176, 24, '2017-07-04');
INSERT INTO `sales_records` VALUES (46, 271, 11, '2017-07-04');
INSERT INTO `sales_records` VALUES (47, 244, 6, '2017-07-04');
INSERT INTO `sales_records` VALUES (48, 61, 19, '2017-07-04');
INSERT INTO `sales_records` VALUES (49, 130, 25, '2017-07-04');
INSERT INTO `sales_records` VALUES (50, 295, 8, '2017-07-04');
INSERT INTO `sales_records` VALUES (51, 43, 24, '2017-07-04');
INSERT INTO `sales_records` VALUES (52, 312, 3, '2017-07-04');
INSERT INTO `sales_records` VALUES (53, 160, 24, '2017-07-04');
INSERT INTO `sales_records` VALUES (54, 152, 11, '2017-07-04');
INSERT INTO `sales_records` VALUES (55, 232, 10, '2017-07-04');
INSERT INTO `sales_records` VALUES (56, 296, 26, '2017-07-05');
INSERT INTO `sales_records` VALUES (57, 298, 1, '2017-07-05');
INSERT INTO `sales_records` VALUES (58, 37, 28, '2017-07-05');
INSERT INTO `sales_records` VALUES (59, 133, 15, '2017-07-05');
INSERT INTO `sales_records` VALUES (60, 109, 2, '2017-07-05');
INSERT INTO `sales_records` VALUES (61, 78, 7, '2017-07-05');
INSERT INTO `sales_records` VALUES (62, 38, 1, '2017-07-05');
INSERT INTO `sales_records` VALUES (63, 89, 7, '2017-07-05');
INSERT INTO `sales_records` VALUES (64, 321, 7, '2017-07-05');
INSERT INTO `sales_records` VALUES (65, 37, 26, '2017-07-05');
INSERT INTO `sales_records` VALUES (66, 325, 6, '2017-07-05');
INSERT INTO `sales_records` VALUES (67, 20, 26, '2017-07-06');
INSERT INTO `sales_records` VALUES (68, 311, 15, '2017-07-06');
INSERT INTO `sales_records` VALUES (69, 154, 23, '2017-07-06');
INSERT INTO `sales_records` VALUES (70, 208, 5, '2017-07-06');
INSERT INTO `sales_records` VALUES (71, 110, 26, '2017-07-06');
INSERT INTO `sales_records` VALUES (72, 281, 24, '2017-07-06');
INSERT INTO `sales_records` VALUES (73, 10, 28, '2017-07-06');
INSERT INTO `sales_records` VALUES (74, 183, 3, '2017-07-06');
INSERT INTO `sales_records` VALUES (75, 235, 16, '2017-07-06');
INSERT INTO `sales_records` VALUES (76, 184, 1, '2017-07-06');
INSERT INTO `sales_records` VALUES (77, 44, 24, '2017-07-06');
INSERT INTO `sales_records` VALUES (78, 193, 16, '2017-07-06');
INSERT INTO `sales_records` VALUES (79, 147, 25, '2017-07-06');
INSERT INTO `sales_records` VALUES (80, 323, 14, '2017-07-06');
INSERT INTO `sales_records` VALUES (81, 267, 23, '2017-07-06');
INSERT INTO `sales_records` VALUES (82, 31, 27, '2017-07-07');
INSERT INTO `sales_records` VALUES (83, 18, 7, '2017-07-07');
INSERT INTO `sales_records` VALUES (84, 246, 17, '2017-07-07');
INSERT INTO `sales_records` VALUES (85, 106, 14, '2017-07-07');
INSERT INTO `sales_records` VALUES (86, 115, 17, '2017-07-07');
INSERT INTO `sales_records` VALUES (87, 162, 16, '2017-07-08');
INSERT INTO `sales_records` VALUES (88, 121, 20, '2017-07-08');
INSERT INTO `sales_records` VALUES (89, 189, 7, '2017-07-08');
INSERT INTO `sales_records` VALUES (90, 43, 18, '2017-07-08');
INSERT INTO `sales_records` VALUES (91, 259, 19, '2017-07-08');
INSERT INTO `sales_records` VALUES (92, 103, 10, '2017-07-08');
INSERT INTO `sales_records` VALUES (93, 40, 18, '2017-07-08');
INSERT INTO `sales_records` VALUES (94, 40, 18, '2017-07-08');
INSERT INTO `sales_records` VALUES (95, 100, 26, '2017-07-08');
INSERT INTO `sales_records` VALUES (96, 92, 6, '2017-07-08');
INSERT INTO `sales_records` VALUES (97, 309, 28, '2017-07-08');
INSERT INTO `sales_records` VALUES (98, 316, 7, '2017-07-08');
INSERT INTO `sales_records` VALUES (99, 59, 23, '2017-07-08');
INSERT INTO `sales_records` VALUES (100, 40, 3, '2017-07-08');

SET FOREIGN_KEY_CHECKS = 1;

users.sql

/*
 Navicat Premium Data Transfer

 Source Server         : MySQL57
 Source Server Type    : MySQL
 Source Server Version : 50735
 Source Host           : localhost:3306
 Source Schema         : progate

 Target Server Type    : MySQL
 Target Server Version : 50735
 File Encoding         : 65001

 Date: 15/12/2021 14:54:06
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `gender` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `age` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (1, 'Giana', '1', 17);
INSERT INTO `users` VALUES (2, 'Diann', '1', 22);
INSERT INTO `users` VALUES (3, 'Antonella', '1', 22);
INSERT INTO `users` VALUES (4, 'Jodi', '0', 29);
INSERT INTO `users` VALUES (5, 'Fredra', '1', 54);
INSERT INTO `users` VALUES (6, 'Katheryn', '1', 25);
INSERT INTO `users` VALUES (7, 'Billie', '0', 21);
INSERT INTO `users` VALUES (8, 'Fawn', '1', 59);
INSERT INTO `users` VALUES (9, 'Caroline', '1', 47);
INSERT INTO `users` VALUES (10, 'Nichol', '1', 26);
INSERT INTO `users` VALUES (11, 'Else', '1', 25);
INSERT INTO `users` VALUES (12, 'Leigh', '1', 20);
INSERT INTO `users` VALUES (13, 'Virgie', '0', 63);
INSERT INTO `users` VALUES (14, 'Lorilee', '1', 39);
INSERT INTO `users` VALUES (15, 'Dorolisa', '1', 22);
INSERT INTO `users` VALUES (16, 'Olly', '0', 36);
INSERT INTO `users` VALUES (17, 'Marcelle', '1', 16);
INSERT INTO `users` VALUES (18, 'Lisetta', '1', 27);
INSERT INTO `users` VALUES (19, 'Donall', '0', 28);
INSERT INTO `users` VALUES (20, 'Eveline', '1', 41);
INSERT INTO `users` VALUES (21, 'Ailbert', '0', 25);
INSERT INTO `users` VALUES (22, 'Gannon', '0', 28);
INSERT INTO `users` VALUES (23, 'Lyn', '0', 18);
INSERT INTO `users` VALUES (24, 'Granger', '0', 25);
INSERT INTO `users` VALUES (25, 'Karleen', '1', 37);
INSERT INTO `users` VALUES (26, 'Heddie', '1', 24);
INSERT INTO `users` VALUES (27, 'Appolonia', '1', 37);
INSERT INTO `users` VALUES (28, 'Grazia', '1', 40);
INSERT INTO `users` VALUES (29, 'Herrick', '0', 21);
INSERT INTO `users` VALUES (30, 'Madelin', '1', 31);
INSERT INTO `users` VALUES (31, 'Marjory', '1', 47);
INSERT INTO `users` VALUES (32, 'Ronnie', '1', 29);
INSERT INTO `users` VALUES (33, 'Fabiano', '0', 31);
INSERT INTO `users` VALUES (34, 'Howey', '0', 35);
INSERT INTO `users` VALUES (35, 'Jordanna', '1', 25);
INSERT INTO `users` VALUES (36, 'Harlin', '0', 62);
INSERT INTO `users` VALUES (37, 'Lay', '0', 44);
INSERT INTO `users` VALUES (38, 'Carina', '1', 27);
INSERT INTO `users` VALUES (39, 'Maisey', '1', 21);
INSERT INTO `users` VALUES (40, 'Armand', '0', 19);
INSERT INTO `users` VALUES (41, 'Chadd', '0', 24);
INSERT INTO `users` VALUES (42, 'Toby', '1', 16);
INSERT INTO `users` VALUES (43, 'Burch', '0', 33);
INSERT INTO `users` VALUES (44, 'Tobye', '1', 19);
INSERT INTO `users` VALUES (45, 'Wilbert', '0', 24);
INSERT INTO `users` VALUES (46, 'Leif', '0', 35);
INSERT INTO `users` VALUES (47, 'Khalil', '0', 29);
INSERT INTO `users` VALUES (48, 'Giffie', '0', 23);
INSERT INTO `users` VALUES (49, 'Bryana', '1', 20);
INSERT INTO `users` VALUES (50, 'Leon', '0', 27);
INSERT INTO `users` VALUES (51, 'Trenton', '0', 24);
INSERT INTO `users` VALUES (52, 'Gretal', '1', 17);
INSERT INTO `users` VALUES (53, 'Peirce', '0', 16);
INSERT INTO `users` VALUES (54, 'Weidar', '0', 55);
INSERT INTO `users` VALUES (55, 'Martha', '1', 18);
INSERT INTO `users` VALUES (56, 'Marlene', '1', 30);
INSERT INTO `users` VALUES (57, 'Lianne', '1', 23);
INSERT INTO `users` VALUES (58, 'Norbert', '0', 25);
INSERT INTO `users` VALUES (59, 'Gilbertina', '1', 26);
INSERT INTO `users` VALUES (60, 'Jobye', '1', 22);
INSERT INTO `users` VALUES (61, 'Xenos', '0', 18);
INSERT INTO `users` VALUES (62, 'Homerus', '0', 28);
INSERT INTO `users` VALUES (63, 'Hobie', '0', 24);
INSERT INTO `users` VALUES (64, 'Ariella', '1', 23);
INSERT INTO `users` VALUES (65, 'Urban', '0', 19);
INSERT INTO `users` VALUES (66, 'Adrienne', '1', 55);
INSERT INTO `users` VALUES (67, 'Tedi', '1', 22);
INSERT INTO `users` VALUES (68, 'Jenna', '1', 47);
INSERT INTO `users` VALUES (69, 'Dorthy', '1', 25);
INSERT INTO `users` VALUES (70, 'Delilah', '1', 33);
INSERT INTO `users` VALUES (71, 'Daryl', '0', 24);
INSERT INTO `users` VALUES (72, 'Poul', '0', 19);
INSERT INTO `users` VALUES (73, 'Adrianna', '1', 23);
INSERT INTO `users` VALUES (74, 'Dagny', '0', 19);
INSERT INTO `users` VALUES (75, 'Adria', '1', 22);
INSERT INTO `users` VALUES (76, 'Liz', '1', 16);
INSERT INTO `users` VALUES (77, 'Savina', '1', 39);
INSERT INTO `users` VALUES (78, 'Liliane', '1', 18);
INSERT INTO `users` VALUES (79, 'Pinchas', '0', 58);
INSERT INTO `users` VALUES (80, 'Jerrilyn', '1', 29);
INSERT INTO `users` VALUES (81, 'Libbi', '1', 25);
INSERT INTO `users` VALUES (82, 'Esmaria', '1', 30);
INSERT INTO `users` VALUES (83, 'Chester', '0', 52);
INSERT INTO `users` VALUES (84, 'Frederica', '1', 34);
INSERT INTO `users` VALUES (85, 'Josefa', '1', 46);
INSERT INTO `users` VALUES (86, 'Elise', '1', 24);
INSERT INTO `users` VALUES (87, 'Ban', '0', 37);
INSERT INTO `users` VALUES (88, 'Randee', '1', 60);
INSERT INTO `users` VALUES (89, 'Carlyn', '1', 22);
INSERT INTO `users` VALUES (90, 'Julissa', '1', 23);
INSERT INTO `users` VALUES (91, 'Lindon', '0', 19);
INSERT INTO `users` VALUES (92, 'Brena', '1', 57);
INSERT INTO `users` VALUES (93, 'Mio', '1', 22);
INSERT INTO `users` VALUES (94, 'Kerianne', '1', 27);
INSERT INTO `users` VALUES (95, 'Humbert', '0', 16);
INSERT INTO `users` VALUES (96, 'Karee', '1', 24);
INSERT INTO `users` VALUES (97, 'Karlie', '1', 15);
INSERT INTO `users` VALUES (98, 'Anthia', '1', 28);
INSERT INTO `users` VALUES (99, 'Isaac', '0', 25);
INSERT INTO `users` VALUES (100, 'Darleen', '1', 24);

SET FOREIGN_KEY_CHECKS = 1;

zhangsan3333

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
三个sql文件，后缀改为sql导入navicat

items.sql/* Navicat Premium Data Transfer Source Server : MySQL57 Source Server Type : MySQL Source Server Version : 50735 Source Host : localhost:3306 Source Schema : progate Target Server Type : MySQL Target Ser
复制链接

扫一扫