Create a mysql dynamic table

To create a mysql dynamic table, first check whether the table exists. Use the SQL statement :?? 1. SHOW? TABLES? LIKE? % Tb_bp_d_case % ;?? 2. select 'table _ name' from 'information _ scheme'. 'tables' where 'table _ scheme' dbname? And 'table _ name' tablename ?;

To create a mysql dynamic table, first check whether the table exists. Use the SQL statement :? ? 1. SHOW? TABLES? LIKE? '% Tb_bp_d_case % ';?? 2. select 'table _ name' from 'information _ scheme'. 'tables' where 'table _ scheme' = 'dbname '? And 'table _ name' = 'tablename '?;

Create a mysql dynamic table

To create a mysql dynamic table, you must first check whether the table exists.

Use SQL statements:

?

?

1. SHOW? TABLES? LIKE? '% Tb_bp_d_case % ';??
2. select 'table _ name' from 'information _ scheme'. 'tables' where 'table _ scheme' = 'dbname '? And 'table _ name' = 'tablename '?;
3. If the table does not exist, create the table. Can I use it directly? Create? Table? If? Not? Exists? Tablename? To create such a command, you do not need to first check whether the table exists.
4. create a table from the template table: create table if not exists like old_table_name? (This is currently used)

Split data according to the partition table.

?

?