Search Results
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-7-0.html
Errors were returned similar to the following: ERROR 3977 (HY000) at line 117: Only BINLOG INSERT, COMMIT and ROLLBACK statements are allowed after CREATE TABLE with START TRANSACTION statement. Errors were returned similar to the following: ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-statements.html
If you do not know ahead of time whether the SQL statement will be a SELECT or an UPDATE/INSERT, then you can use the execute(String SQL) method. This method will return true if the SQL query was a SELECT, or false if it was an UPDATE, INSERT, or ...
https://dev.mysql.com/doc/connectors/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/connectors/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/connectors/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/connectors/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 Section 5.5, “Configuring Connector/ODBC”: Create a new Worksheet. Figure 5.34 Microsoft Query Wizard: Selecting ... You can use Microsoft Word and Microsoft Excel to access information from a MySQL database using ...
https://dev.mysql.com/doc/connectors/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/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 ...