in mysql, add the column after the other column if exists

Question

how can it?

I found it for check column exists

(
SELECT 1 FROM Information_schema.columns
WHERE table_schema = 'db' 
AND table_name = 'table' 
AND column_name = 'the other column'
)

and add the column after the other column

ALTER TABLE 'table' ADD 'the column' VARCHAR(14) DEFAULT NULL AFTER 'the other column'

Also, use backticks around table and column names, not single quotes. https://stackoverflow.com/questions/11321491/when-to-use-single-quotes-double-quotes-and-backticks — Barmar, Aug 28 '18 at 16:18
I will run this code to each database had a different structure, but I want to add the column only if had a specific column Barmer: that was just an example. — ParkDyel, Aug 29 '18 at 03:32

score 2 · Accepted Answer · answered Aug 28 '18 at 16:37

2

give the name of the db in which the table exists:-

ALTER TABLE db.table ADD the_column VARCHAR(14) DEFAULT NULL AFTER the_other_column

It worked for me try this and let me know where it is failing

answered Aug 28 '18 at 16:37

vinay chhabra

I will run this code to each database had a different structure, but I want to add the column only if had a specific column. – ParkDyel Aug 29 '18 at 03:31

1 Answers1