kingbase创建存储过程

Question

以下是mysql的创建存储过程的语句，如何将此语句修改成kingbase语句呀？

DROP PROCEDURE IF EXISTS schema_change;$$
CREATE PROCEDURE schema_change() BEGIN


CREATE TABLE IF NOT EXISTS `bis_record_upload_list` (
  `pkid` int(11) NOT NULL AUTO_INCREMENT,
  `hash_code` varchar(255) DEFAULT NULL COMMENT '检验码',
  `path` varchar(255) DEFAULT NULL COMMENT '路径',
  PRIMARY KEY (`pkid`),
  UNIQUE KEY `hash_code` (`hash_code`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;




IF NOT EXISTS (SELECT * FROM information_schema.columns WHERE table_schema = DATABASE()  AND table_name = 'bis_record_upload_list' AND column_name = 'hash_code') THEN
    alter table bis_record_upload_list add `hash_code` varchar(255) DEFAULT NULL COMMENT '检验码';
END IF;



END;$$
CALL schema_change();$$
DROP PROCEDURE IF EXISTS schema_change;$$

Answer 1

你们公司现在都用kingbase了嘛，感觉遇到你提问这个相关的好多次了