Search Results
https://dev.mysql.com/doc/refman/9.7/en/audit-log-file-formats.html
For example, the following statement generates one Query event, two TableRead events, and a TableInsert events: INSERT INTO t3 SELECT t1.* FROM t1 JOIN t2; Each TableXXX event contains <TABLE> and <DB> elements to identify the table to which the ...
https://dev.mysql.com/doc/refman/9.7/en/mysqlbinlog.html
Rows are grouped into events smaller than this size if possible. It outputs the three INSERT statements following USE test, but not the three INSERT statements following USE db2. mysqlbinlog --database=db2 does not output the first two INSERT ...
https://dev.mysql.com/doc/x-devapi-userguide/en/devapi-users-working-with-relational-tables.html
The following code sample shows how to use the add() and select() methods of the X DevAPI SQL CRUD functions, which are similar to running INSERT and SELECT statements on a table with an SQL client. The X DevAPI SQL CRUD functions allow you to work ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-programming-vb.html
This section contains simple examples of the use of Connector/ODBC with ADO, DAO and RDO. 5.6.7.1.1 ADO: rs.addNew, rs.delete, and rs.update The following ADO (ActiveX Data Objects) example creates a table my_ado and demonstrates the use of ...
https://dev.mysql.com/doc/refman/9.7/en/create-table.html
When you insert a value of NULL (recommended) or 0 into an indexed AUTO_INCREMENT column, the column is set to the next sequence value. INSERT_METHOD If you want to insert data into a MERGE table, you must specify with INSERT_METHOD the table into ...For a unique index, an error occurs regardless of SQL mode because reducing the index length might enable insertion of nonunique entries that do not meet the specified uniqueness ...
https://dev.mysql.com/doc/refman/9.7/en/internal-locking.html
That is, you can insert rows into a MyISAM table at the same time other clients are reading from it. The MyISAM storage engine supports concurrent inserts to reduce contention between readers and writers for a given table: If a MyISAM table has no ... This section discusses internal locking; that is, locking performed within the MySQL server itself to manage contention for table contents by multiple ...
https://dev.mysql.com/doc/refman/9.7/en/optimizing-innodb-bulk-data-loading.html
When importing data into InnoDB, turn off autocommit mode, because it performs a log flush to disk for every insert. Use the multiple-row INSERT syntax to reduce communication overhead between the client and the server if you need to insert many ...
https://dev.mysql.com/doc/refman/9.7/en/example-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
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.
https://dev.mysql.com/doc/refman/9.7/en/data-type-defaults.html
When not using strict mode, only the third statement produces an error; the implicit default is inserted for the first two statements, but the third fails because DEFAULT(i) cannot produce a value: INSERT INTO t VALUES(); INSERT INTO t ...For ...