MariaDB Executing foreign key setup table truncate
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE [ TABLE NAME ];
SET FOREIGN_KEY_CHECKS = 1;
'!!...MySQL&MariaDB' 카테고리의 다른 글
| [MariaDB] Sample - ALTER VIEW (0) | 2022.12.23 |
|---|---|
| [MariaDB] Sample - CREATE VIEW (0) | 2022.12.23 |
| [MySQL] CASE WHEN SAMPLE CODE (0) | 2022.09.17 |
| [MySQL]show Table comment information (0) | 2022.09.17 |
| [MySQL]MySQL ERROR 1118 (42000): Row size too large (0) | 2022.09.13 |