Answers for "add column to existing table mysql allow null"

SQL
2

set column to not null mysql

ALTER TABLE Person MODIFY P_Id INT(11) NOT NULL;
Posted by: Guest on April-16-2020
0

add column if not exists mysql

SELECT count(*) INTO @EXIST
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'mydatabase'
  AND COLUMN_NAME = 'mycolumn'
  AND TABLE_NAME = 'mytable' LIMIT 1;

SET @query = IF (@exist <= 0, 'ALTER TABLE mydatabase.`mytable`  ADD COLUMN `mycolumn` MEDIUMTEXT NULL',
    'select ' COLUMN EXISTS' status');
PREPARE stmt FROM @query;
EXECUTE stmt;
Posted by: Guest on August-23-2021

Code answers related to "add column to existing table mysql allow null"

Code answers related to "SQL"

Browse Popular Code Answers by Language