this is the normal code for DELETE one data in one clmn DELETE FROM t.name WHERE clmn="data"; but what is the code for DELETE clmn? come on guys answer me!

Question

COLUMN DELETE!

Answer 1

ALTER TABLE table
DROP COLUMN clmn

This deletes the collum “clmn“ from the table “table“

Answer 2

ALTER TABLE t.name DROP COLUMN clmn;

Answer 3

It's done with Alter Table command. Syntax is :

Alter Table <Table Name>
Drop < Column Name >