摘要： select cast(`a`.`status` AS SIGNED INTEGER) AS `status`,`a`.`TAGNAME` AS `TAGNAME` from (select truncate(`v_mes_snapshots`.`numbervalue`,0) AS `status 阅读全文

摘要： 修改表的编码格式sql alter table tablename character set utf8 修改表中某个字段的编码格式sql alter table tablename modify fieldname varchar(50) character set utf8 阅读全文