Modify MySQL script to filter data using 2 tables
Budget: $10 – $30 AUD
Using MySQL Workbench, I have a query that is way too big to export to 1 CSV file. (400+mb)
So I would like to either find an option that will allow me to export successfully without getting timeout/memory issues.
Or better still I have 2 additional tables of data that we can filter by to reduce the final size.
- In stock items list
- Required item list
I'm hoping this brings the query size down enough to be able to export to a CSV file.
Let me know your experience and or ideas
So I would like to either find an option that will allow me to export successfully without getting timeout/memory issues.
Or better still I have 2 additional tables of data that we can filter by to reduce the final size.
- In stock items list
- Required item list
I'm hoping this brings the query size down enough to be able to export to a CSV file.
Let me know your experience and or ideas