Search Results
https://dev.mysql.com/doc/refman/8.4/en/timestamp-initialization.html
For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, the auto-update value, or both: An auto-initialized column is set to the current timestamp for inserted rows that specify no value for the ...
https://dev.mysql.com/doc/refman/8.4/en/triggers.html
Some uses for triggers are to perform checks of values to be inserted into a table or to perform calculations on values involved in an update. A trigger is defined to activate when a statement inserts, updates, or deletes rows in the associated ...
https://dev.mysql.com/doc/refman/8.4/en/using-date.html
This makes MySQL very convenient for Web applications where you obtain year, month, and day in three different fields and you want to store exactly what the user inserted (without date validation). You should use this format in UPDATE expressions ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-navigator.html
However, this item inserts the SQL code directly into the SQL Query panel, where it can be edited further as required. Double-clicking a table, view, or column name in the schema explorer inserts the name into the SQL Query area. FROM ... The ...
https://dev.mysql.com/doc/workbench/en/wb-tables-physical-schemata.html
Copy Insert to Clipboard: Copies INSERT statements based on the model's inserts. Nothing is copied to the clipboard if the table has no inserts defined. Copy Insert Template to Clipboard: Copies a generic INSERT statement that is based on the model.
https://dev.mysql.com/doc/connectors/en/connector-net-programming-trace-source.html
mysql Information: 1 : 1: Connection Opened: connection string = 'server=localhost;User Id=root;database=world;port=3306 ;password=******;logging=True' mysql Information: 3 : 1: Query Opened: SHOW VARIABLES mysql Information: 4 : 1: Resultset ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb-ado.html
The following ADO (ActiveX Data Objects) example creates a table my_ado and demonstrates the use of rs.addNew, rs.delete, and rs.update. rs.Open "SELECT * FROM my_ado" rs!Name = "update" rs!txt = "updated-second-time" rs.Update rs.Close 'rs delete ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb-rdo.html
The following RDO (Remote Data Objects) example creates a table my_rdo and demonstrates the use of rs.addNew and rs.update. SQL = "select * from my_rdo" Set rs = cn.OpenResultset(SQL, rdOpenStatic, rdConcurRowVer, rdExecDirect) Do Until rs.EOF For ...
https://dev.mysql.com/doc/internals/en/event-data-for-specific-event-types.html
It is necessary for statements such as INSERT INTO t VALUES(1) that don't specify the database and rely on the default database previously selected by USE. SELECT fails after inserting 1000 rows into a MyISAM table (for example, with a duplicate-key ... The following sections provide details about what appears in the fixed and variable parts of the event data for each event ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-single.html
Backup failed to insert file header (check configuration) 1346 MySQL error. Backup failed to insert table list (check configuration) 1347 MySQL error. Insert in hash table failed when getting table information from Ndb 4502 MySQL error. This ...