Mysql
keulraesik
这个作者很懒,什么都没留下…
展开
-
Copy Table
复制表结构及数据 CREATE TABLE destTable AS SELECT * FROM srcTable; 仅仅复制表结构 (若原表中有自增字段, 会忽略) CREATE TABLE destTable AS SELECT * FROM srcTable WHERE 1=2; 复制表结构 (完全复制 仅表名不同) CREATE TABLE destTab...原创 2009-12-09 20:52:30 · 145 阅读 · 0 评论 -
Mysql Remark
1. jdbc url jdbc:mysql://IP:3306/dbName?useUnicode=true&characterEncoding=GBK 2. user privileges 更改用户权限后记得 flush privileges; 3. 导入数据表 大小写 在 my.ini 中添加 如下配置 # Identifier Case Sens...2009-08-09 13:04:40 · 899 阅读 · 0 评论 -
Fetch Random N Amount Data
SELECT columns FROM table ORDER BY rand() LIMIT N2010-04-15 17:17:25 · 86 阅读 · 0 评论 -
Replace NULL To Expect Value
SELECT COALESCE(FIELD, expectValue) FROM t Equals SELECT CASE FIELD WHEN IS NULL THEN expectValue ELSE FIELD END FROM t2010-04-15 17:31:38 · 79 阅读 · 0 评论 -
Unix Timpstamp
1. 普通时间字段 --> Unix-Timestamp SELECT UNIX_TIMESTAMP(NOW()); 2. Unix-Timestamp --> 普通时间字段 SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(NOW()));原创 2010-01-26 23:48:36 · 107 阅读 · 0 评论 -
STAT. Fields appear times
统计字段出现次数 1. SELECT SUM(IF(LOCATE(keyword, t.field) > 0, 1, 0)) AS `AppearTimes` FROM t WHERE CONDITION 2. SELECT SUM(CASE t.field WHEN keyword THEN 1 ELSE 0 END) AS `AppearTimes` ...原创 2010-01-28 21:34:28 · 80 阅读 · 0 评论 -
Update tables Engine to InnoDB
将指定数据库 dbname 中 所有表 Engine 改为 InnonDB 类型 DELIMITER // DROP PROCEDURE IF EXISTS transferTableEngine// CREATE PROCEDURE transferTableEngine (IN dbName VARCHAR(100)) READS SQL DATA BEGIN DECLARE is...2010-02-22 17:38:10 · 153 阅读 · 0 评论 -
Show Current Row Number
显示当前记录所在的查询结果集中的RowNumber SELECT @rowNum:=@rowNum+1 AS `rowNum`, t.* FROM (SELECT @rowNum:=0) AS `r`, t原创 2010-02-26 14:56:59 · 55 阅读 · 0 评论