delete column from table mysql code example
Example 1: how remove column in mysql
ALTER TABLE "table_name" DROP "column_name";
Example 2: mysql drop column
ALTER TABLE `claims_user_settings` DROP COLUMN `super_user`;
Example 3: how delete a column in mysql
ALTER TABLE table_name
DROP COLUMN column_name;
Example 4: alasql delete column
var data = [{a:1,b:10},{a:2,b:20}];
var res = alasql('SELECT * REMOVE COLUMN b FROM ?',[data]);
// returns [{a:!},{a:2}]