I m trying to run a query in HeidiSQL. If I run only one SELECT statement, everything works fine. If I want to run multiple SELECT statements 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!