Home

Published

- 1 min read

Mysql query add column with default string value

add default mysql sql string
img of Mysql query add column with default string value

The solution for this is noted below

Mysql query add column with default string value

Solution

   ALTER TABLE `table_name` ADD COLUMN `new_column_name` VARCHAR(255)  DEFAULT "DEFUALT_VALUE" AFTER `COLUMN_NAME`;

Try other methods by searching on the site. That is if this doesn’t work