sinat_40779170的博客

SELECTIF( t.TABLE_COMMENT = '' OR t.TABLE_COMMENT = NULL, t.table_name, t.TABLE_COMMENT ) 表注释,t.table_name 表或视图,(@rowNO := @rowNo+1) AS 序号,c.COLUMN_NAME 列名,c.COLUMN_COMMENT 列注释,c.COLUMN_TYPE 数据类...

转自：https://blog.youkuaiyun.com/qq_37267706/article/details/79679262 CREATE PROCEDURE `order_attachment_procedure`()BEGIN -- 声明变量 declare done INT DEFAULT 0; declare edone INT DEFAULT 0; -- 接受游标查询结果...

UPDATE airplane_city SET city_first_word=ELT(INTERVAL(CONV(HEX(LEFT(CONVERT(`flyint_city_des` USING gbk),1)),16,10),0xB0A1,0xB0C5,0xB2C1,0xB4EE,0xB6EA,0xB7A2,0xB8C1,0xB9FE,0xBBF7,0xBFA6,0xC0AC,0xC2E...