![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
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 · 153 阅读 · 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 · 915 阅读 · 0 评论 -
Fetch Random N Amount Data
SELECT columns FROM table ORDER BY rand() LIMIT N2010-04-15 17:17:25 · 89 阅读 · 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 · 83 阅读 · 0 评论 -
Unix Timpstamp
1. 普通时间字段 --> Unix-TimestampSELECT UNIX_TIMESTAMP(NOW()); 2. Unix-Timestamp --> 普通时间字段SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(NOW()));原创 2010-01-26 23:48:36 · 112 阅读 · 0 评论 -
STAT. Fields appear times
统计字段出现次数1.SELECT SUM(IF(LOCATE(keyword, t.field) > 0, 1, 0)) AS `AppearTimes`FROM tWHERE CONDITION 2.SELECT SUM(CASE t.field WHEN keyword THEN 1 ELSE 0 END) AS `AppearTimes`...原创 2010-01-28 21:34:28 · 84 阅读 · 0 评论 -
Update tables Engine to InnoDB
将指定数据库 dbname 中 所有表 Engine 改为 InnonDB 类型DELIMITER //DROP PROCEDURE IF EXISTS transferTableEngine//CREATE PROCEDURE transferTableEngine (IN dbName VARCHAR(100))READS SQL DATABEGINDECLARE is...2010-02-22 17:38:10 · 156 阅读 · 0 评论 -
Show Current Row Number
显示当前记录所在的查询结果集中的RowNumberSELECT @rowNum:=@rowNum+1 AS `rowNum`, t.*FROM (SELECT @rowNum:=0) AS `r`, t原创 2010-02-26 14:56:59 · 60 阅读 · 0 评论