php - MySQL Drop Multiple Columns -
i'm trying drop multiple columns, having trouble. syntax below works when alter table , add multiple values in brackets () doesn't work drop column. using wrong syntax?
$table3 = " alter table $table3_name drop column ( user_firstname, user_lastname, user_address, user_address2, user_city, user_state, user_zip, user_phone ); ";
alter table `tablename` drop `column1`, drop `column2`, drop `column3`;
Comments
Post a Comment