Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-tutorial-cursorbuffered.html
The following example script gives a long-overdue 15% raise effective tomorrow to all employees who joined in the year 2000 and are still with the company. (A buffered cursor fetches and buffers the rows of a result set after executing a query; see ...
https://dev.mysql.com/doc/connector-python/en/connector-python-tutorial-cursorbuffered.html
The following example script gives a long-overdue 15% raise effective tomorrow to all employees who joined in the year 2000 and are still with the company. (A buffered cursor fetches and buffers the rows of a result set after executing a query; see ...
https://dev.mysql.com/doc/x-devapi-userguide/en/dynamic-sql.html
A quoting function exists to escape SQL names and identifiers. Session.quoteName() escapes the identifier given in accordance to the settings of the current connection. Note The quoting function must not be used to escape values. Use the value ...
https://dev.mysql.com/doc/internals/en/guided-tour-flow.html
The flow works like this: First, the client routines get an SQL statement from a user, allowing edit, performing initial checks, and so on. Then, via the vio routines, the somewhat-massaged statement goes off to the server. Next, the sql routines ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-cursor-transaction.html
Inserting or updating data is also done using the handler structure known as a cursor. When you use a transactional storage engine such as InnoDB (the default in MySQL 5.5 and higher), you must commit the data after a sequence of INSERT, DELETE, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-transaction.html
Inserting or updating data is also done using the handler structure known as a cursor. When you use a transactional storage engine such as InnoDB (the default in MySQL 5.5 and higher), you must commit the data after a sequence of INSERT, DELETE, ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql-prepare.html
Before proceeding, you will need the following: Follow the installation guide for installing iODBC on your system. Access to a running PostgreSQL instance with privileges to the database you want to migrate, otherwise known as the "source ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-general-information.html
ODBC (Open Database Connectivity) provides a way for client programs to access a wide range of databases or data sources. ODBC is a standardized API that enables connections to SQL database servers. It was developed according to the specifications ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-general-information.html
ODBC (Open Database Connectivity) provides a way for client programs to access a wide range of databases or data sources. ODBC is a standardized API that enables connections to SQL database servers. It was developed according to the specifications ...
https://dev.mysql.com/doc/internals/en/getting-index-information.html
It is preferable for storage engines that support indexing to read the index information provided during a CREATE TABLE operation and store it for future use. The reasoning behind this is that the index information is most readily available during ...