常用mysql

/** 查看自己用户下的连接 */
SHOW FULL PROCESSLIST
/** 查看自己用户下的连接 前100条*/
SHOW FULL processlist

select CONCAT('/** ',COLUMN_COMMENT,' */ \r\nprivate String ' , column_name ,';\r\n') from `COLUMNS` 

where TABLE_NAME='TW_SPREAD_APP'


SELECT CONCAT('<result property="',COLUMN_Name,'" column="' , column_name ,'"/>') FROM `COLUMNS` 
WHERE TABLE_NAME='task'


/* 查看表记录 数据大小 */
SELECT table_name, table_rows, AVG_ROW_LENGTH, data_length,
       MAX_DATA_LENGTH,index_length, data_free
  FROM information_schema.tables t 
 WHERE t.table_schema='stockanalyze' 
 ORDER BY data_length DESC


/** 备份表数据 */
CREATE TABLE dic_province_bak AS SELECT * FROM dic_province;


SELECT * FROM task WHERE is_finish='true' AND take_date>'2014-08-21 00:00:00';

SELECT * FROM task WHERE is_finish='false' AND take_date>'2014-08-21 00:00:00';

CONCAT('%',#{params.remark,jdbcType=VARCHAR},'%')

CURDATE()