linux - mysql variable problem

Question

About the reference of variables in the mysql5.5 database.

1. There is a database called test_num_base, which has a test table.

I want to get test data through variables.

select * from test_num_base.test;

Use variables:

set @A=test_num_base;
But when accessing again, use: select * from @A.test;
Error report: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@A' at line 1

If you use the splicing method to set:

set @B=concat('test_num_base.' 'test');
Access: select * from @B;
Still reporting an error.
Please explain how to correct it, thank you very much!
About the use of database variables.

Answer 1

Only parameters can reference variables. Table names, views and data dictionaries cannot use variables directly. They can only be used through dynamic sql splicing