Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Unanswered: converting SQL code from MS Access to MySQL code

    How do i convert SQL code from MS Access to MySQL code

  2. #2
    Join Date
    Oct 2003
    Location
    Denver, Colorado
    Posts
    137

    Re: converting SQL code from MS Access to MySQL code

    I don't know of an automatic way of doing it. You will definitely have to change the table join syntax. i.e. None of this:
    Code:
    SELECT * FROM table1 INNER JOIN (table2 INNER JOIN table3 ON table2.id = table3.parentid) ON table1.id = table2.parentid;
    This would be rewritten as:
    Code:
    SELECT * FROM table1
    INNER JOIN table2 ON table1.id = table2.parentid
    INNER JOIN table3 ON table2.id = table3.parentid;

Posting Permissions

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