摘要：
WallTime Limit: 1000MSMemory Limit: 10000KTotal Submissions: 21867Accepted: 7174DescriptionOnce upon a time there was a greedy King who ordered his chief Architect to build a wall around the King's castle. The King was so greedy, that he would not listen to his Architect's proposals to build 阅读全文
随笔档案-2012年5月17日
回收站中被标记删除的表不可以DML和DDL操作
2012-05-17 10:53 by java环境变量, 236 阅读, 收藏,
摘要：
表被DROP掉后存放到了回收站中，有一些局限性，回收站中被标记删除的表不可以DML和DDL操作。1.模拟表被不含有PURGE关键字的DROP语句删除1)确认回收站功能已经开启SQL> show parameter recyclebinNAME TYPE VALUE------------------------------------ ----------- ----------------------recyclebin string onSQL> show recyclebin;2)新建测试表模拟删除create table t1(sid int not null primar 阅读全文
perl支持mysql
2012-05-17 10:51 by java环境变量, 216 阅读, 收藏,
摘要：
默认情况，安装好perl以后不支持mysql，运行perl脚本时提示：Available drivers: CSV, DBM, ExampleP, File, Gofer, ODBC, Oracle, Proxy, SQLite,Sponge.解决办法：--如果是在windows中安装activer perl则ppm install "DBD::mysql"--下载源码安装http://search.cpan.org/~capttofu/DBD-mysql-4.020/lib/DBD/mysql.pm 阅读全文
浙公网安备 33010602011771号