I m trying to run a query in HeidiSQL 11.0.0.5919. If I run only one of two SELECT statements, everything works fine. If I want to run both SELECT statements as one I keep getting SQL error 1064
Any ideas what to change to the code?
SELECT id, date, customer_id INTO OUTFILE 'orders.txt' CHARACTER SET utf8 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM orders;
SELECT order_id, line_number, quantity, discount, price INTO OUTFILE 'order_line_items.txt' CHARACTER SET utf8 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM order_line_items;
Thanks!