Applications.ge

ALTER TABLE

Adds column

personal_id

after

api_method

column in

requests

table

ALTER TABLE requests
ADD COLUMN personal_id VARCHAR(15) AFTER api_method;

If we run the same

alter

statement one more time, we will get the following error with code

Error Code: 1060. Duplicate column name 'personal_id'

If we want to delete a column from a table, we use the following command

ALTER TABLE `requests` 
DROP COLUMN `status_id`;

by Valeri Tandilashvili

MySQL

alter

Pro tip: use ```triple backticks around text``` to write in code fences