Can we have two table with the same name in MySQL?

Question

You can have tables of the same name only if they are in separate databases, and you use the database name as a qualifier. 2 мая 2017 г.

Can 2 tables have the same name SQL?

You simply can't. You must prefix your table or find a different name.

Can two tables have same column name?

You can't. You must alias each name on your own.

Can 2 tables have same index name?

Index names are specific to each table. You cannot have two indexes of the same name in one table, but you can have many indexes of the same name, one for every table.

Can we have two fields with same name?

You can't add two columns with the same name to a single table.

Expert · Answer