rdc2008的专栏

字符串转64位整数：drop function hex_to_bigint(text);CREATE FUNCTIONhex_to_bigint(in_hex TEXT)RETURNS BIGINTIMMUTABLE STRICT LANGUAGE sql AS$body$ SELECT CAST(CAST(('x' || CAST($1 AS text)) AS bit(64)) AS BIGINT);$body$;

MYSql在表（table_name）的指定位置（exist_field_name之后）添加字段（字段名，类型(长度)： new_field_name，type_name(length)）：alter table table_name add new_field_name type_name(length) after