You can also use the MySQL Workbench GUI to export the results of a query. LINES TERMINATED BY ' ' Using the MySQL Workbench GUI SELECT o.OrderId, o.CustomerID, o.EmployeeID, o.OrderDate, o.RequiredDate, o.ShippedDate, o.ShipVia, o.Freight, o.ShipName, o.ShipAddress, o.ShipCity, o.ShipRegion, o.ShipPostalCode, o.ShipCountry, od.OrderID, od.ProductId, od.UnitPrice, od.Quantity, od.DiscountįROM `Orders` o LEFT JOIN `Order Details` od ON od.OrderID = o.OrderID SELECT 'OrderId','CustomerID','EmployeeID','OrderDate','RequiredDate','ShippedDate','ShipVia','Freight','ShipName','ShipAddress','ShipCity','ShipRegion','ShipPostalCode','ShipCountry','OrderID','ProductId','UnitPrice','Quantity','Discount' In this example, we add column headers to the. Here’s an example of another (slightly more complex) query. CSV file contains headers on the first line), you can hardcode them in another SELECT statement, prepended to the rest of the query by a UNION ALL operator. To include the column names (so that the.

CSV file won’t have headers on the first line. CSV file with the results of the query, but not with the column names. Here’s the query again, this time using some of those extra clauses: SELECT * FROM Customers You can also specify the characters to enclose each value by using the ENCLOSED BY clause.Īnd you can use the FIELDS ESCAPED BY clause to control how to write special characters. Additional Resources There are many SQL examples in the Database Documentation on OTN Discuss this how-to in the OTN SQL Developer Forum. The sql file will open into a SQL Worksheet. Select the new file exportDept.sql from your file directory. You can specify how fields and lines are terminated by using the FIELDS TERMINATED and LINES TERMINATED clauses. To review the file created, go to the main menu and select View-> Files to open the Files Navigator tab. CSV file called customers.csv in the /tmp directory. This selects all columns from the Customers table and puts them into a. You specify the name/location of the file as well as other options, such as field terminators, line terminators, etc.

Save txt file as sql on mac