Find solution

How to convert Oracle script to MySQL script?

Check our answers to ‘How to convert Oracle script to MySQL script?’ - we found 34 replies and comments relevant to this matter. The best answers are submitted by users of Stack Overflow, Google Answers and Ask.Metafilter.Com.

Best solution

  • Convert oracle script to mysql script

    Need help on this I am migrating the database from oracle to mysql. I am running the below query in oracle it works fine but in mysql getting INSERT INTO xyz(rid, pid) SELECT rid, pid FROM ( (SELECT distinct rd,(SELECT p.pid FROM abc p WHERE p.permission='jury') AS pid FROM xyz WHERE pid IN (SELECT p.pid FROM abc p WHERE p.permission in ('jury')))); Getting the below error Every derived table must have its own alias [SQL State=42000, DB Errorcode=1248]

    Answer:

    I'm not a MySQL user, but googling the error shows that it's expecting the inline view to have an alias...

    Mark as irrelevant Undo

Other solutions