rdc2008的专栏

字符串转64位整数： drop function hex_to_bigint(text); CREATE FUNCTION hex_to_bigint(in_hex TEXT) RETURNS BIGINT IMMUTABLE 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