[SQL] Query dump-military_db-202503101740 start
[ERR] 1046 - No database selected
[ERR] -- MySQL dump 10.13 Distrib 8.0.19, for Win64 (x86_64)
--
-- Host: localhost Database: military_db
-- ------------------------------------------------------
-- Server version 8.0.41
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `scene`
--
DROP TABLE IF EXISTS `scene`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `scene` (
`scene_id` bigint NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL ,
`new_scene_json` JSON NOT NULL,
`create_by` BIGINT NOT NULL COMMENT '创建者id',
`create_at` datetime NOT NULL COMMENT '创建时间',
PRIMARY KEY (`scene_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `scene`
--
LOCK TABLES `scene` WRITE;
/*!40000 ALTER TABLE `scene` DISABLE KEYS */;
INSERT INTO `scene` VALUES (1,'新场景','{\"newJB\":[{\"id\":\"3c023efc-265c-4dc2-b7cd-f8b459889dca\",\"name\":\"火力分队指挥车\",\"Image\":\"/config/junbiaoData/hlfdzhc.png\",\"position\":[119.25188573552256,24.83690806251623]},{\"id\":\"ea3a2b50-d44c-4ae6-acad-da2cdd06d82d\",\"name\":\"步兵分队指挥车\",\"Image\":\"/config/junbiaoData/bbfdzhc.png\",\"position\":[119.30493372312226,23.899242786713604]},{\"id\":\"baf0e5b2-9e45-4ba4-af92-99309df7758b\",\"name\":\"防空分队指挥车\",\"Image\":\"/config/junbiaoData/fkfdzhc.png\",\"position\":[118.59054815996707,23.975229164659254]}],\"newLine\":[[\"3c023efc-265c-4dc2-b7cd-f8b459889dca\",\"ea3a2b50-d44c-4ae6-acad-da2cdd06d82d\",1],[\"3c023efc-265c-4dc2-b7cd-f8b459889dca\",\"baf0e5b2-9e45-4ba4-af92-99309df7758b\",3]]}',1,NOW());
/*!40000 ALTER TABLE `scene` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `command_info`
--
DROP TABLE IF EXISTS `command_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `command_info` (
`command_id` bigint NOT NULL AUTO_INCREMENT,
`type` tinyint NOT NULL ,
`form_id` bigint NOT NULL,
`to_user_id` bigint NOT NULL,
`text_value` text,
`file_path` varchar(500) DEFAULT NULL,
`upload_time` datetime NOT NULL,
PRIMARY KEY (`command_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `command_info`
--
LOCK TABLES `command_info` WRITE;
/*!40000 ALTER TABLE `command_info` DISABLE KEYS */;
INSERT INTO `command_info` VALUES (1,1,1,2,'电磁压制成功率 ≥95% 物理摧毁率 ≥90%（天线阵列、供电模块需完全失效） 附带损伤半径 ≤200米（避免波及民用通信设施）',NULL,'2025-01-01 05:10:10'),(2,3,1,2,NULL,'C:\\Users\\wang\\Desktop\\data\\82935f72-4bdb-429d-b2fa-fbef95d2bebe_sql.txt','2025-01-01 05:10:10');
/*!40000 ALTER TABLE `command_info` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_intel`
--
DROP TABLE IF EXISTS `group_intel`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `group_intel` (
`group_id` bigint
[SQL] Finished with error
分析一下错误原因
最新发布
本文介绍如何检查并重设MySQL的max_allowed_packet大小，以应对因数据包过大导致的脚本运行错误，提供相关命令和实例。
扫一扫
3868
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
