2016年1月27日
Mysql程序
摘要： drop table if exists comp_ap; create table comp_ap as select ProjectName, ModelCode, 'AP_ACMClosed' Component, AP_ACMTotal as Total, AP_ACMClosed as C 阅读全文
posted @ 2016-01-27 19:56 wujixing909 阅读(282) 评论(0) 推荐(0)
Mysql 行转列
摘要： 1. 创建表:create table tb(ID int,username varchar(20),CN_SCORE float,MATH_SCORE float,EN_SCORE float);2. 插入数据:INSERT INTO tb values(1,'lisi',87,65,75);IN... 阅读全文
posted @ 2016-01-27 12:24 wujixing909 阅读(517) 评论(0) 推荐(0)