SELECT CONCAT( 'ALTER TABLE ', table_name, ' RENAME TO yc_', substring(table_name, 5), ';' ) sqlsFROM information_schema.tables Where table_name LIKE 'lm_%';
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
收藏
