Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    Chicago
    Posts
    54

    Unanswered: No schema in MySQL?

    I just started to learn mySQL. It looks like MS Access. You create tables in a database. No schema.
    How should I group my tables?
    Thanks.

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: No schema in MySQL?

    Originally posted by jin007
    I just started to learn mySQL. It looks like MS Access. You create tables in a database. No schema.
    How should I group my tables?
    Thanks.
    Tables are grouped in database.
    You can create more databases using "CREATE DATABASE" clause.

  3. #3
    Join Date
    Jan 2004
    Location
    Chicago
    Posts
    54
    Thanks.
    But how do I access tables in more than 1 databases in one session?
    For example, in a java program I need to query tables in 2 databases.

    In Oracle or db2 I can do

    SELECT * FROM SCHEMA1.TABLEA join SCHEMA2.TABLEB

    How to implement something like this in mySQL?

    Thanks.

  4. #4
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482
    Originally posted by jin007
    Thanks.
    But how do I access tables in more than 1 databases in one session?
    For example, in a java program I need to query tables in 2 databases.

    In Oracle or db2 I can do

    SELECT * FROM SCHEMA1.TABLEA join SCHEMA2.TABLEB

    How to implement something like this in mySQL?

    Thanks.
    Yes it is possible (see GRANT clause) but keep in mind MySQL is not Oracle and your example above is not good design of database (in MySQL).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •