Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/sql-crud-functions.html
execute(); Figure 6.1 Table.insert() Syntax Diagram Table.select() The Table.select() method works like a SELECT statement in SQL. Notice that Table.select() and collection.find() use different methods for sorting results: Table.select() uses the ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-sql-result-sets.html
var res = mySession.sql('SELECT name, age FROM users').execute(); var row; while (row = res.fetchOne()) { print('Name: ' + row['name'] + '\n'); print(' Age: ' + row.age + '\n'); } SqlResult differs from results returned by CRUD operations in the way ... When you execute an SQL operation on a Session using the sql() method, an SqlResult is ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/sql-crud-functions.html
myTable.insert(['id', 'name']).values(1, 'Imani').values(2, 'Adam').execute() Figure 6.1 Table.insert() Syntax Diagram Table.select() The Table.select() method works like a SELECT statement in SQL. Notice that Table.select() and collection.find() ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-sql-result-sets.html
res = mySession.sql('SELECT name, age FROM users').execute() row = res.fetch_one() while row: print('Name: %s\n' % row[0]) print(' Age: %s\n' % row.age) row = res.fetch_one() SqlResult differs from results returned by CRUD operations in the way how ... When you execute an SQL operation on a Session using the sql() method, an SqlResult is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-report-table.html
From MySQL version 8.0.32 onwards, the heatwave_advisor_report table, is deprecated and replaced with the heatwave_autopilot_report table in the sys schema. When MySQL runs Advisor, it sends detailed output to the heatwave_advisor_report table in ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-airportdb-quickstart.html
For example: mysql-sql> EXPLAIN SELECT booking.price, count(*) FROM booking WHERE booking.price > 500 GROUP BY booking.price ORDER BY booking.price LIMIT 10\G *************************** 1. The MySQL HeatWave airportdb Quickstart shows how to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load.html
mysql> SELECT log FROM sys.heatwave_autopilot_report WHERE type="error"; When Auto Parallel Load finishes running, query the heatwave_autopilot_report table to check for warnings. mysql> SELECT log FROM sys.heatwave_autopilot_report WHERE ... You ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-result-par-redact.html
The pre-authenticated request (PAR) URL is hidden in the log file for security reasons. The following example exports the query results as a CSV file to the object storge location represented as a PAR URL. It also displays the latest query results ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-json.html
SELECT * FROM example INTO OUTFILE WITH PARAMETERS '{"file":[{ "uri":"oci://bucket_1@tenancy1/data_files_1/"}], "dialect": {"has_header": true, "format": "csv"} }'; Example for PAR URL The following example uses a PAR URL to export query results.
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-non-json.html
SELECT sum(l_quantity) from lineitem INTO OUTFILE URI 'oci://bucket1@tenancy1/data_files_1/'; The following example uses default delimiters, and exports the query results to a CSV file. SELECT sum(l_quantity) from lineitem INTO OUTFILE URL ... This ...