tidb

How to drop a table, the name with ‘\t’ in tidb?

This question is originally asked by 'xyz2b' in https://ask.pingcap.com/t/how-to-drop-a-table-the-name-with-t/669

I created two tables one of which contains ‘\t’. I want to drop the table with ‘\t’. Such as ‘test\t’ and ‘test’. I want to drop ‘test\t’ table.

I have tried drop the table; but it does not work.

use command {show tables like ‘ex_secure_TM_ROLE_UPLOAD\t’} can find this table, but use command {show create table ex_secure_TM_ROLE_UPLOAD\t} can’t find this table.

I can only provide photos of the results, because it is in a production environment.

enter image description here

Solution

  • This answers was provided by 'WalterWj' in here enter image description here

    enter image description here

    You can use vim to write SQL files, source can be deleted. The above two diagrams show creating and deleting tests. The tmp.txt file is also here, you notice the comments under the changes

    drop_sql.txt