toxic

摘要： 清空表的所有数据【低效方式：一条一条的删除】DELETE FROM table_name;【推荐方式:效率高】TRUNCATE table_name;正则表达式SELECT name FROM t1 WHERE email REGEXP "@163[.,].com$";提取随机行SELECT * FROM t1 ORDER BY RAND() LIMIT 3;【使用rand()函数会使程序的效率降低】显示表结构SHOW CREATE TABLE table_name;利用GROUP BY 的 WITH ROLLUP（不可于ORDER BY 同时使用）SELECT city_ 阅读全文

摘要： 一、MYSQL表复制【复制表结构】CREATE TABLE t2 LIKE t1【复制表内容】INSERT INTO t2 SELECT * FROM t1二、索引【查看索引】SELECT INDEX FROM table_name;【创建索引】CREATE INDEX index_name ON table_name(column);CREATE UNIQUE INDEX index_name ON table_name(column);ALTER TABLE table_name ADD INDEX index_name(column);ALTER TABLE table_name ADD 阅读全文

摘要： include ROOTPATH.'/excel/PHPExcel.php'; include ROOTPATH.'/excel/PHPExcel/Writer/Excel2007.php'; include ROOTPATH.'/excel/phpExcel/IOFactory.php'; $status = $this -> input -> get('userstatus'); $nickname = $this -> input -> get('nickname'); $d... 阅读全文