/SQL/Drop column from table if exist on live server mysql

Drop column from table if exist on live server mysql

-- column_exists:

DROP FUNCTION IF EXISTS column_exists;

DELIMITER $$
CREATE FUNCTION column_exists(
  tname VARCHAR(64),
  cname VARCHAR(64)
)
  RETURNS BOOLEAN
  READS SQL DATA
  BEGIN
    RETURN 0 < (SELECT COUNT(*)
                FROM `INFORMATION_SCHEMA`.`COLUMNS`
                WHERE `TABLE_SCHEMA` = SCHEMA()
                      AND `TABLE_NAME` = tname
                      AND `COLUMN_NAME` = cname);
  END $$
DELIMITER ;

-- drop_column_if_exists:

DROP PROCEDURE IF EXISTS drop_column_if_exists;

DELIMITER $$
CREATE PROCEDURE drop_column_if_exists(
  tname VARCHAR(64),
  cname VARCHAR(64)
)
  BEGIN
    IF column_exists(tname, cname)
    THEN
      SET @drop_column_if_exists = CONCAT('ALTER TABLE `', tname, '` DROP COLUMN `', cname, '`');
      PREPARE drop_query FROM @drop_column_if_exists;
      EXECUTE drop_query;
    END IF;
  END $$
DELIMITER ;

Source: stackoverflow.com

Similar codes

0 vote351 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
0 vote381 views1 answer
Supprimer les valeur d'une table mysql
SQL
8 votes399 views4 answers
Postgresql server restart
SQL
1 vote364 views1 answer
Declare table variable
SQL
0 vote421 views1 answer
Drop view in mysql
SQL
1 vote353 views4 answers
Mysqldump 1 table only
SQL
4 votes363 views2 answers
Mysql alter table set column unique
SQL
0 vote377 views1 answer
Sql show table name in result
SQL
0 vote397 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
19 votes378 views3 answers
How to change column type psql
SQL