P
P
PP2015-01-21 11:06:39
MySQL
PP, 2015-01-21 11:06:39

Is it possible to create multiple tables of the same type at once in mysql?

all tables have the same structure, only the names differ

Answer the question

In order to leave comments, you need to log in

2 answer(s)
M
Max, 2015-01-21
@Kadi

Make one and clone?
CREATE TABLE new_table_name LIKE old_table_name;

M
Melkij, 2015-01-21
@melkij

Perhaps you wanted to make partitioning instead of a crutch?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question