You can also use the MySQL Workbench GUI to export the results of a query. LINES TERMINATED BY '\n' 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
#Saving as a .sql on mac how to
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. You can specify how fields and lines are terminated by using the FIELDS TERMINATED and LINES TERMINATED clauses. CSV file called customers.csv in the /tmp directory. To retrieve all the contents of a spreadsheet, you can use the following SQL query in the Execute SQL statements action. This approach is faster and increases the performance of the flow. This selects all columns from the Customers table and puts them into a. A more efficient way to retrieve specific values from spreadsheets is to treat Excel files as databases and execute SQL queries on them.
You specify the name/location of the file as well as other options, such as field terminators, line terminators, etc.
0 kommentar(er)
