MySQL (8.0.32)drop table tab1 ;create table tab1( col1 bigint, col2 bigint default -1, col3 varchar(100), col4 varchar(100) default 'A', col5 datetime, col6 datetime default now()); select ordinal_position , column_name , data_type , chara…

MySQL (8.0.32) drop procedure ddl2json;delimiter //create procedure ddl2json( in p_schema_name varchar(4000), in p_table_name varchar(4000))begin declare v_comments varchar(4000); declare v_partition_type varchar(4000); declare v_partition…