Schema in MySQL

Chriz81 · #1 (**permalink**) 06-30-07, 11:10

Hi,

is there a possibilty in a MySQL Database to use Schemas? I can't find anything like this.

Example: select * from schema.table;

Chris

r937 · #2 (**permalink**) 06-30-07, 11:23

yes, they're called databases

example: select * from dbname.tablename

Chriz81 · #3 (**permalink**) 06-30-07, 11:54

Thx! But for instance in the DB2 I have a database and additional a schema.

That's not possible in MySQL, right?

dbmab · #4 (**permalink**) 06-30-07, 12:30

In mysql, a schema and a database are names for the same thing. Starting in mysql 5.0.2 you can use either syntax -

Code:

CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
    [create_specification [create_specification] ...]

Chriz81 · #5 (**permalink**) 07-03-07, 15:50

thanks,
Chris