2012年4月1日
MySQL 数据类型
摘要： 1：整形View Code AdoHelper ado = AdoHelper.CreateHelper(DbProvideType.MySql); ado.ExecuteNonQuery(conn, CommandType.Text, "CREATE TABLE Test (id TINYINT, idu TINYINT UNSIGNED, i INT UNSIGNED)"); IDataParameter[] param1 = new IDataParameter[]{ ado.GetPara... 阅读全文
posted @ 2012-04-01 16:08 李占卫 阅读(325) 评论(0) 推荐(0)
MySQL TIPS
摘要： 1：Message: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.Solution：SETSQL_SAFE_UPDATES= 0;2：远程登录GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '110110' WITH GRANT OPTION; 阅读全文
posted @ 2012-04-01 11:15 李占卫 阅读(164) 评论(0) 推荐(0)