Search Results
https://dev.mysql.com/doc/refman/8.4/en/view-updatability.html
(Even if a view is updatable, it might not be possible to insert into it, as described elsewhere in this section.) The updatability of views may be affected by the value of the updatable_views_with_limit system variable. For a multiple-table ...That ... Some views are updatable and references to them can be used to specify tables to be updated in data change ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-insert-id.html
Use this function after you have performed an INSERT statement into a table that contains an AUTO_INCREMENT field, or have used INSERT or UPDATE to set a column value with LAST_INSERT_ID(expr). The return value of mysql_insert_id() is always zero ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
Changing the server SQL mode after creating and inserting data into partitioned tables can cause major changes in the behavior of such tables, and could lead to loss or corruption of data. STRICT_TRANS_TABLES If a value could not be inserted as ...
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/c-api/8.4/en/getting-unique-id.html
If you insert a record into a table that contains an AUTO_INCREMENT column, you can obtain the value stored into that column by calling the mysql_insert_id() function. When inserting multiple values, the last automatically incremented value is ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-functionality-last-insert-id.html
Obtaining the value of column that uses AUTO_INCREMENT after an INSERT statement can be achieved in a number of different ways. To obtain the value immediately after an INSERT, use a SELECT query with the LAST_INSERT_ID() function. For example, ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-functionality-last-insert-id.html
Obtaining the value of column that uses AUTO_INCREMENT after an INSERT statement can be achieved in a number of different ways. To obtain the value immediately after an INSERT, use a SELECT query with the LAST_INSERT_ID() function. For example, ...
https://dev.mysql.com/doc/refman/8.4/en/loading-tables.html
Suppose that Diane gets a new hamster named “Puffball.” You could add a new record using an INSERT statement like this: mysql> INSERT INTO pet VALUES ('Puffball','Diane','hamster','f','1999-03-30',NULL); String and date values are specified as ...When you want to add new records one at a time, the INSERT statement is ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-last-insert-id.html
The second example shows how you can retrieve the same value using a standard SELECT LAST_INSERT_ID() query. The final example shows how updatable result sets can retrieve the AUTO_INCREMENT value when using the insertRow() method.