ANTICHAT — форум по информационной безопасности, OSINT и технологиям

BACKUP LOG dbname WITH NO_LOG
BACKUP LOG dbname WITH TRUNCATE_ONLY

mysql> select * from t1;
+------+-------+
| id   | name  |
+------+-------+
|    1 | John  |
|    2 | Mary  |
|    3 | Suzen |
|    4 | James |
|    5 | Carry |
+------+-------+
5 rows in set (0.01 sec)

mysql> select * from t2;
+------+------------+
| id   | address    |
+------+------------+
|    1 | Washington |
|    2 | New York   |
|    3 | Washington |
|    4 | Oklahoma   |
|    5 | Texas      |
+------+------------+
5 rows in set (0.01 sec)

mysql> insert into t3 select t1.id, t1.name, t2.address from t1 left join t2 using (id);
Query OK, 5 rows affected (0.00 sec)
Records: 5  Duplicates: 0  Warnings: 0

mysql> select * from t3;
+------+-------+------------+
| id   | name  | address    |
+------+-------+------------+
|    1 | John  | Washington |
|    2 | Mary  | New York   |
|    3 | Suzen | Washington |
|    4 | James | Oklahoma   |
|    5 | Carry | Texas      |
+------+-------+------------+
5 rows in set (0.00 sec)