数据库表合并场景实践测试SQL

/* Navicat Premium Data Transfer Source Server : 本地 Source Server Type : MySQL Source Server Version : 50705 (5.7.5-m15) Source Host : localhost:3306 Source Schema : test Target Server Type : MySQL Target Server Version : 50705 (5.7.5-m15) File Encoding : 65001 Date: 15/01/2024 22:43:14 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for a2 -- ---------------------------- DROP TABLE IF EXISTS `a2`; CREATE TABLE `a2` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id', `a_id` int(11) DEFAULT NULL COMMENT 'a表id', `info` varchar(255) COLLATE utf8mb4_croatian_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_croatian_ci; -- ---------------------------- -- Records of a2 -- ---------------------------- BEGIN; INSERT INTO `a2` (`id`, `a_id`, `info`) VALUES (1, 1, 'a1表id为1,a2表id为1记录'); INSERT INTO `a2` (`id`, `a_id`, `info`) VALUES (2, 1, 'a1表id为1,a2表id为2记录'); COMMIT; SET FOREIGN_KEY_CHECKS = 1;