Search Results
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-lastrowid.html
Syntax: id = cursor.lastrowid This read-only property returns the value generated for an AUTO_INCREMENT column by the previous INSERT or UPDATE statement or None when there is no such value available. For example, if you perform an INSERT into a ...
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-net/en/connector-net-programming-stored-proc.html
A stored procedure is a set of SQL statements that is stored in the server. Clients make a single call to the stored procedure, passing parameters that can influence the procedure logic and query conditions, rather than issuing individual hardcoded ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-sql-command.html
This is because ExecuteNonQuery is only used for inserting, updating and deleting data. When a connection has been established with the MySQL database, the next step enables you to perform database operations. This task can be achieved through the ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-errors.html
#DELETED# Records Reported by Access Access reports records as #DELETED# when inserting or updating records in linked tables. If the inserted or updated records are shown as #DELETED# in Access, then: If you are using Access 2000, get and install ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-wordexcel.html
For example, to insert information from a table in the World test database into an Excel spreadsheet, using the DSN samples shown in Chapter 5, Configuring Connector/ODBC: Create a new Worksheet. Figure 6.23 Microsoft Query Wizard: Selecting A ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-integrityerror.html
For example, a duplicate key was inserted or a foreign key constraint would fail. The following example shows a duplicate key error raised as IntegrityError: cursor.execute("CREATE TABLE t1 (id int, PRIMARY KEY (id))") try: cursor.execute("INSERT ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-lastrowid.html
Syntax: id = cursor.lastrowid This read-only property returns the value generated for an AUTO_INCREMENT column by the previous INSERT or UPDATE statement or None when there is no such value available. For example, if you perform an INSERT into a ...
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/internals/en/full-text-search.html
Every time that insert/update/delete occurs for any row in the table, these global weight factors change for all rows in the table. It would take too long to replace the weights for all keys in the fulltext index, for every single ... MySQL uses ...