摘要:
Windows-Preferences-Java-Complicer-Errors/Warnings Deprecated and restricted API Forbidden references(access rules)>>>>>Warning就可以编译通过了 阅读全文
摘要:
-- Function structure for add_months-- DROP FUNCTION IF EXISTS `add_months`;DELIMITER ;;CREATE DEFINER=`root`@`%` FUNCTION `add_months`(in_string VARC 阅读全文
摘要:
#use information_schema;#select concat('drop table ',table_name,';') from tables where TABLE_SCHEMA = 'nxpt';拼接删除SQL #select concat('TRUNCATE table ', 阅读全文
摘要:
mysql:如何将百万级别的数据从oracle转移到mysql中 http://blog.csdn.net/hwhua1986/article/details/53257427 oracle到mysql的迁移步骤及各种注意事项 http://www.2cto.com/database/201305/ 阅读全文
摘要:
oracle 查每张表有多少条记录 SELECT table_name,num_rows FROM user_tables order by num_rows desc; 阅读全文
摘要:
mysql 查看数据库中所有表的记录数 use information_schema; select table_name,table_rows from tables where TABLE_SCHEMA = 'testdb' order by table_rows desc; 阅读全文