Copy tables structure automatically and change tables name mysq

Closed
zizouinfo
Posts
137
Registration date
Wednesday November 16, 2011
Status
Member
Last seen
August 1, 2017
- Aug 1, 2017 at 03:09 AM
i have a database with many tables, i need to copy these tables structures and add another title. for example i have the tables:
table_data
table_log
table_bans
i want to copy these tables automatically as follow:
table_data_city
table_log_city
table_bans_city