mysql - Dropping database table -

while importing production data development database, went off , have 2 database tables similar, differing 1 contains db name table prefix.

in case, have database rmstg, , 2 tables

main_stratkeys rmstg.main_stratkeys 

how can drop latter table?

drop table rmstg.main_stratkeys drops first table, not latter.

drop table rmstg.rmstg.main_stratkeys returns sql syntax error inner .rmstg. declaration.

try using backquotes:

drop table `rmstg.main_stratkeys`; 

or

drop table rmstg.`rmstg.main_stratkeys`;