kevin_Luan的专栏

GRANT ALL PRIVILEGES ON *.* TO kevin@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;GRANT ALL PRIVILEGES ON *.* TO kevin@'localhost' IDENTIFIED BY '123456' WITH GRANT OPTION;GRANT ALL PRIVILEGES ON

使用EXPLAIN可以看到以下SQL的执行情况EXPLAIN SELECT * FROM questionnaire WHERE user_id='wqef'Explain具体含义参见此链接：http://dev.mysql.com/doc/refman/5.1/en/using-explain.html

方式一：mysqldump -ukevin -P3306 --default-character-set=utf8 -p -h127.0.0.1 activity sign_in_user > user.sql导出的结果包含建表脚本及数据已INSERT.SQL形式。导入数据mysql>use database;mysql>source user.sql;方式二：

在Mysql命令行执行SELECT * FROM user_info_xnj_0 WHERE mobile_no LIKE '%1' INTO OUTFILE 'd:/incoming_log_current_0.sql';   在SQLyong 工具执行   LOAD DATA LOCAL INFILE 'D:/incoming_log_current_0.sql' IGNORE

package com.lss.test;import java.beans.PropertyVetoException;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import com.mchange.v2.c3p0.ComboPooledDataSource;

package com.lss.mysql.test;import javax.transaction.xa.Xid;public class MyXid implements Xid { int formatId; byte glob

Error code:1728 Cannot load from mysql.proc. The table is probably corruptedhttp://bugs.mysql.com/bug.php?id=50183原因是mysql.proc 在5.1 comment char(64) -> 5.5 comment text 导致The difference see

#计算两个时间的间隔#计算间隔天数select TIMESTAMPDIFF(day,'2014-06-01',date(now()))#计算间隔月数select TIMESTAMPDIFF(month,'2014-01-01',date(now()))#计算间隔年数select TIMESTAMPDIFF(year,'2010-01-01',date(now()))