Results 1 to 2 of 2

Thread: My SQL ODBC

  1. #1
    Join Date
    Sep 2003
    Posts
    3

    Question Unanswered: My SQL ODBC

    Hi people...

    Does anybody know about MySql System Tables???

    I am a ORACLE user and I know about ALL_TABLES in oracle... this table has all information about the tables in the system... I think it is created to show as a index...

    However I use this table and some others to update my database...

    Now, i am trying to use my software in MYSQL, its is ok, but I cant update my tables without this ALL_TALBES / ALL_CLOUMNS / ALL_CONTRAINTS --- myu application use this tables...

    Does anyone kown how can I find this? Is this from ODBC??? I am using ODBC conection in W2k

    Seeya

  2. #2
    Join Date
    Sep 2003
    Posts
    69
    Code:
    use mysql;
    show tables;
    output:

    columns_priv
    db
    func
    guestbook
    host
    tables_priv
    user

    What you should try is describing the tables and selecting * from them to see if they have what you need

Posting Permissions

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