DDL : RENAME, TRUNCATE and DROP | SQL Commands | MySQL DDL Commands

Опубликовано: 01 Апрель 2026
на канале: Leela Soft

176

#leelasoft
DAY: 09-04-2023:
Rename: TABLE
Rename TABLE
ALTER TABLE

Syntax: Rename TABLE
RENAME TABLE
old_tbl_name TO new_tbl_name
[, old_tbl_name2 TO new_tbl_name2] ...

Syntax:
ALTER TABLE old_table RENAME new_table;

Truncate: DDL
Syntax:
TRUNCATE TABLE tbl_name;

Delete:DML
DELETE FROM tbl_name;
DELETE FROM tbl_name WHERE cond;

DROP :
DATABASE
TABLE

Syntax:
DROP {DATABASE | SCHEMA} [IF EXISTS] db_name;

Syntax:
DROP TABLE [IF EXISTS]
tbl_name [, tbl_name] ...

drop table if exists t;
drop table t;