2.------------------------------------------------------------------------------------------
这个是行转列,用于你后台的查询统计的
mysql查询表所有列名,并用逗号分隔
SELECT GROUP_CONCAT(COLUMN_NAME SEPARATOR ",") FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = 'db_name' AND TABLE_NAME = 'table_name'
3.设计到字段是金钱的,数据类型可以设置为decimal(11,2)
4.$this->TBase->Prefix('users');