Search Results
https://dev.mysql.com/doc/refman/8.4/en/precision-math-expressions.html
In strict SQL mode, for INSERT into a column with an exact data type (DECIMAL or integer), a number is inserted with its exact value if it is within the column range. Inserts into numeric columns are affected by the SQL mode, which is controlled by ...When retrieved, the value should be the same as what was ... With precision ...
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
For example: INSERT INTO animals (id,name) VALUES(0,'groundhog'); If the column is declared NOT NULL, it is also possible to assign NULL to the column to generate sequence numbers. For example: INSERT INTO animals (id,name) VALUES(NULL,'squirrel'); ...You can retrieve the most recent automatically generated AUTO_INCREMENT value with the LAST_INSERT_ID() SQL function or the mysql_insert_id() C API ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-net-vb.html
The following sample creates a table my_vb_net and demonstrates the use in VB.
https://dev.mysql.com/doc/refman/8.4/en/archive-storage-engine.html
ARCHIVE does not support inserting a value into an AUTO_INCREMENT column less than the current maximum column value. There are several types of insertions that are used: An INSERT statement just pushes rows into a compression buffer, and that buffer ...The ARCHIVE engine supports INSERT, REPLACE, and SELECT, but not DELETE or ... The ARCHIVE storage engine produces ...
https://dev.mysql.com/doc/refman/8.4/en/lock-tables.html
This occurs because t2 is inserted into within the trigger, so the READ request is converted to a WRITE request. The LOCAL modifier enables nonconflicting INSERT statements (concurrent inserts) by other sessions to execute while the lock is held.
https://dev.mysql.com/doc/refman/8.4/en/invisible-columns.html
For the third INSERT statement, the VALUES() list must provide the same number of values as the number of named columns; the same is true when you use VALUES ROW() rather than VALUES(). For statements that insert or ignore new rows, or that replace ...An invisible column is normally hidden to queries, but can be accessed if explicitly ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-schema.html
The NDB injector is responsible for capturing all the data events within the cluster, and ensures that all events which change, insert, or delete data are recorded in the ndb_binlog_index table. Splitting replication streams into two (or more) ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-an-anomaly-detection-model.html
mysql> CREATE DATABASE anomaly_data; mysql> USE anomaly_data; Create the table to insert the sample data into. mysql> CREATE TABLE credit_card_train ( transaction_id INT AUTO_INCREMENT PRIMARY KEY, home_address VARCHAR(100), purchase_location ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-prepare-an-anomaly-detection-model.html
mysql> CREATE DATABASE anomaly_data; mysql> USE anomaly_data; Create the table to insert the sample data into. mysql> CREATE TABLE credit_card_train ( transaction_id INT AUTO_INCREMENT PRIMARY KEY, home_address VARCHAR(100), purchase_location ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-sql-result-sets.html
An SqlResult combines a result set produced by, for example, INSERT, and a data set, produced by, for example, SELECT in one. An SqlResult instance exports methods for accessing data and to retrieving the last inserted ID or number of affected rows.