· 7 years ago · Nov 15, 2018, 02:20 PM
1CREATE FUNCTION `createColumn`(tabla varchar(50))
2RETURNS TINYINT(1)
3BEGIN
4IF NOT EXISTS( SELECT count(*)
5 FROM `INFORMATION_SCHEMA.COLUMNS`
6 WHERE `INFORMATION_SCHEMA.COLUMNS`.`table_name` = `action`
7 AND `INFORMATION_SCHEMA.COLUMNS`.`table_schema` = `testdb_dev`
8 AND `INFORMATION_SCHEMA.COLUMNS`.`column_name` = `company_id`) THEN
9
10 ALTER TABLE `action` ADD `company_id` int(11) NOT NULL;
11
12RETURN 1;
13END IF;
14END