How do I read XML data in MySQL workbench? What will be the stored procedure to insert XML data as a parameter into the table?
If I need to select 100,000 non-adjacent rows in MySQL based on an indexed field, and do inserts to other tables based on the data, what is the least expensive way to do that?