BEGIN
DECLARE v_table_name varchar(200);
DECLARE v_column_name varchar(50);
DECLARE v_comments varchar(200);
DECLARE v_column_type VARCHAR(50);
declare stop int default 0; declare cur CURSOR for(
#SELECT ttc.table_name, ttc.column_name, ttc.comments from aa_t_table_comments ttc
SELECT ttc.table_name, ttc.column_name, ttc.comments ,infs.column_type from aa_t_table_comments ttc
LEFT JOIN (SELECT * FROM information_schema.columns where TABLE_SCHEMA ='plat_dbv1_1') as infs
on ( ttc.TABLE_NAME = infs.TABLE_NAME and ttc.COLUMN_NAME = infs.column_name) ); #set @temp_type = v_column_type;
#set @temp_column = v_comments; OPEN cur;
FETCH cur into v_table_name, v_column_name ,v_comments,v_column_type; WHILE stop <> 1 DO
/*
UPDATE information_schema.columns isc
SET isc.COLUMN_COMMENT = v_comments
WHERE isc.TABLE_NAME = v_table_name AND isc.COLUMN_NAME = v_column_name AND isc.TABLE_SCHEMA = 'plat_dbv1_1';
*/
alter table v_table_name modify column v_column_name v_column_type comment v_comments FETCH cur into v_table_name, v_column_name ,v_comments ; END WHILE; CLOSE cur;ENDalter table v_table_name modify column v_column_name v_column_type comment v_comments这么一句拼接怎么写
alter table ',v_table_name,' modify column ',v_column_name,' ', v_column_type ,' comment ',v_comments);
prepare stml from @asql;
execute stml;