获取MYSQL数据库中所有表的表名称（为了使数据库小写变为大写）【MYSQL】

SQL语句：

select table_name

from information_schema.tables

where table_schema='CSDN'

and table_type='base table';

当你的数据库名称是BFIP、则修正上述标红的字体CSDN为BFIP

使用EXCEEL进行更改

步骤①

rename table	EVENT_PM_ORDER_STATUS	to	EVENT_PM_ORDER_STATUSgggggggg	;
rename table	FINANCING_PRODUCT	to	FINANCING_PRODUCTgggggggg	;
rename table	INSTITUTION_UNIT	to	INSTITUTION_UNITgggggggg	;
rename table	PM_CUST_ORDER_BILL	to	PM_CUST_ORDER_BILLgggggggg	;
rename table	PM_CUST_SHOPPING_CART	to	PM_CUST_SHOPPING_CARTgggggggg	;
rename table	PM_DETAIL_ZIP_DOWNLOAD_LOG	to	PM_DETAIL_ZIP_DOWNLOAD_LOGgggggggg	;
rename table	PM_DETAIL_ZIP_PUBLISH_LOG	to	PM_DETAIL_ZIP_PUBLISH_LOGgggggggg	;
rename table	PM_INST_SALE_PROD_EXCLUDE	to	PM_INST_SALE_PROD_EXCLUDEgggggggg	;
rename table	PM_LOGISTICS_INST	to	PM_LOGISTICS_INSTgggggggg	;
rename table	PM_POST_ADDR	to	PM_POST_ADDRgggggggg	;
rename table	PM_SALE_COMM	to	PM_SALE_COMMgggggggg	;
rename table	PM_SALE_COMM_ORDERS	to	PM_SALE_COMM_ORDERSgggggggg	;
rename table	PM_SELLER_CUST_ORDERS	to	PM_SELLER_CUST_ORDERSgggggggg	;
rename table	PM_SELLER_CUST_ORDERS_DETAIL	to	PM_SELLER_CUST_ORDERS_DETAILgggggggg	;
rename table	PM_SUPPLIER_SELLER_AGREEMENT	to	PM_SUPPLIER_SELLER_AGREEMENTgggggggg	;
rename table	PM_SUPP_INVOICE	to	PM_SUPP_INVOICEgggggggg	;
rename table	PM_SUPP_INVOICE_DETAIL	to	PM_SUPP_INVOICE_DETAILgggggggg	;
rename table	PM_SUPP_ORDERS	to	PM_SUPP_ORDERSgggggggg	;
rename table	PM_SUPP_ORDERS_DETAIL	to	PM_SUPP_ORDERS_DETAILgggggggg	;
rename table	PRECIOUS_METALS_PRODUCT	to	PRECIOUS_METALS_PRODUCTgggggggg	;
rename table	PRODUCT_CATEGORY	to	PRODUCT_CATEGORYgggggggg	;
rename table	SUPPLIER_SELLER_AGREEMENT	to	SUPPLIER_SELLER_AGREEMENTgggggggg	;
rename table	agrd_period_roll_issu_rule	to	agrd_period_roll_issu_rulegggggggg	;
rename table	app_access_log	to	app_access_loggggggggg	;
rename table	bcm_rev_trans_confirm_details	to	bcm_rev_trans_confirm_detailsgggggggg	;
rename table	bcm_share_confirm_details	to	bcm_share_confirm_detailsgggggggg	;
rename table	bcm_supp_prod_bonus	to	bcm_supp_prod_bonusgggggggg	;
rename table	bcm_trans_confirm_details	to	bcm_trans_confirm_detailsgggggggg	;
rename table	bfip_customer_sharehold_detail	to	bfip_customer_sharehold_detailgggggggg	;
rename table	bfip_customer_sharehold_total	to	bfip_customer_sharehold_totalgggggggg	;
rename table	bfip_customer_sharehold_total_history	to	bfip_customer_sharehold_total_historygggggggg	;
rename table	bfip_interface	to	bfip_interfacegggggggg	;
rename table	bfip_interface_controller	to	bfip_interface_controllergggggggg	;
rename table	bfip_interface_strategy	to	bfip_interface_strategygggggggg	;
rename table	bfip_ip_infodb	to	bfip_ip_infodbgggggggg	;
rename table	bfip_opt_customreports	to	bfip_opt_customreportsgggggggg	;
rename table	bfip_opt_customreports_inst_access	to	bfip_opt_customreports_inst_accessgggggggg	;
rename table	bfip_opt_customreports_param	to	bfip_opt_customreports_paramgggggggg	;
rename table	bfip_pos_checking_clearing	to	bfip_pos_checking_clearinggggggggg	;
rename table	bfip_positive_trans	to	bfip_positive_transgggggggg	;
rename table	bfip_rev_checking_clearing	to	bfip_rev_checking_clearinggggggggg	;
rename table	bfip_reverse_sharehold_detail	to	bfip_reverse_sharehold_detailgggggggg	;
rename table	bfip_reverse_trans	to	bfip_reverse_transgggggggg	;
rename table	bfip_sequence	to	bfip_sequencegggggggg	;
rename table	bfip_transaction_type	to	bfip_transaction_typegggggggg	;
rename table	cdrcb_rev_trans_confirm_details	to	cdrcb_rev_trans_confirm_detailsgggggggg	;
rename table	cdrcb_share_confirm_details	to	cdrcb_share_confirm_detailsgggggggg	;

步骤②

	rename table	EVENT_PM_ORDER_STATUSgggggggg	to	EVENT_PM_ORDER_STATUS;
	rename table	FINANCING_PRODUCTgggggggg	to	FINANCING_PRODUCT;
	rename table	INSTITUTION_UNITgggggggg	to	INSTITUTION_UNIT;
	rename table	PM_CUST_ORDER_BILLgggggggg	to	PM_CUST_ORDER_BILL;
	rename table	PM_CUST_SHOPPING_CARTgggggggg	to	PM_CUST_SHOPPING_CART;
	rename table	PM_DETAIL_ZIP_DOWNLOAD_LOGgggggggg	to	PM_DETAIL_ZIP_DOWNLOAD_LOG;
	rename table	PM_DETAIL_ZIP_PUBLISH_LOGgggggggg	to	PM_DETAIL_ZIP_PUBLISH_LOG;
	rename table	PM_INST_SALE_PROD_EXCLUDEgggggggg	to	PM_INST_SALE_PROD_EXCLUDE;
	rename table	PM_LOGISTICS_INSTgggggggg	to	PM_LOGISTICS_INST;
	rename table	PM_POST_ADDRgggggggg	to	PM_POST_ADDR;
	rename table	PM_SALE_COMMgggggggg	to	PM_SALE_COMM;
	rename table	PM_SALE_COMM_ORDERSgggggggg	to	PM_SALE_COMM_ORDERS;
	rename table	PM_SELLER_CUST_ORDERSgggggggg	to	PM_SELLER_CUST_ORDERS;
	rename table	PM_SELLER_CUST_ORDERS_DETAILgggggggg	to	PM_SELLER_CUST_ORDERS_DETAIL;
	rename table	PM_SUPPLIER_SELLER_AGREEMENTgggggggg	to	PM_SUPPLIER_SELLER_AGREEMENT;
	rename table	PM_SUPP_INVOICEgggggggg	to	PM_SUPP_INVOICE;
	rename table	PM_SUPP_INVOICE_DETAILgggggggg	to	PM_SUPP_INVOICE_DETAIL;
	rename table	PM_SUPP_ORDERSgggggggg	to	PM_SUPP_ORDERS;
	rename table	PM_SUPP_ORDERS_DETAILgggggggg	to	PM_SUPP_ORDERS_DETAIL;
	rename table	PRECIOUS_METALS_PRODUCTgggggggg	to	PRECIOUS_METALS_PRODUCT;
	rename table	PRODUCT_CATEGORYgggggggg	to	PRODUCT_CATEGORY;
	rename table	SUPPLIER_SELLER_AGREEMENTgggggggg	to	SUPPLIER_SELLER_AGREEMENT;
	rename table	agrd_period_roll_issu_rulegggggggg	to	AGRD_PERIOD_ROLL_ISSU_RULE;
	rename table	app_access_loggggggggg	to	APP_ACCESS_LOG;
	rename table	bcm_rev_trans_confirm_detailsgggggggg	to	BCM_REV_TRANS_CONFIRM_DETAILS;
	rename table	bcm_share_confirm_detailsgggggggg	to	BCM_SHARE_CONFIRM_DETAILS;
	rename table	bcm_supp_prod_bonusgggggggg	to	BCM_SUPP_PROD_BONUS;
	rename table	bcm_trans_confirm_detailsgggggggg	to	BCM_TRANS_CONFIRM_DETAILS;
	rename table	bfip_customer_sharehold_detailgggggggg	to	BFIP_CUSTOMER_SHAREHOLD_DETAIL;
	rename table	bfip_customer_sharehold_totalgggggggg	to	BFIP_CUSTOMER_SHAREHOLD_TOTAL;
	rename table	bfip_customer_sharehold_total_historygggggggg	to	BFIP_CUSTOMER_SHAREHOLD_TOTAL_HISTORY;