V
V
Vladimir Golub2018-05-07 13:09:08
MySQL
Vladimir Golub, 2018-05-07 13:09:08

What is the analogue of schemas in MySQL?

I am migrating to MySQL from PostgreSQL.
The base is divided into schemes.
I make a request Instead of a schema, a database is created, how to get around this? If different schemas contain tables with the same names ?
CREATE SCHEME test

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
Rsa97, 2018-05-07
@RazerVG

And actually in terms of MySQL:

CREATE SCHEMA is a synonym for CREATE DATABASE.

Relationships between tables of different databases are created as `dbname`.`columnname`, it is only necessary that the tables be on the same engine and the columns have the same types.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question