create schema if not exists DD; use DD;
|
DROP TABLE IF EXISTS D1; DROP TABLE IF EXISTS D2;
|
CREATE TABLE D1 (`ID` int(11) PRIMARY KEY AUTO_INCREMENT,
|
`INFO` longtext DEFAULT NULL) ENGINE=InnoDB;
|
CREATE TABLE D2 (`ID` int(11) PRIMARY KEY AUTO_INCREMENT,
|
`SECTION` int(11) NOT NULL) ENGINE=InnoDB;
|
|
insert into D1 (`INFO`) values ('x');
|
insert into D1 (`INFO`) values ('x');
|
insert into D2 (`SECTION`) values (1);
|
insert into D2 (`SECTION`) select 2 as `SECTION` from D1;
|
insert into D2 (`SECTION`) values (1);
|
MariaDB [DD]> select * from D2;
|
+----+---------+
|
| ID | SECTION |
|
+----+---------+
|
| 1 | 1 |
|
| 2 | 2 |
|
| 3 | 2 |
|
| 5 | 1 |
|
+----+---------+
|
4 rows in set (0.000 sec)
|