Treffer: MySQL 5: informatioṉschema and Strict Mode.

Title:
MySQL 5: informatioṉschema and Strict Mode.
Authors:
Kruckenberg, Mike, Pipes, Jay
Source:
Linux Magazine. Jun2006, Vol. 8 Issue 6, p38-43. 5p. 8 Diagrams, 3 Charts.
Subject Terms:
SQL, Information retrieval, Databases, Metadatabases, Database industry, Computer software, Computer industry, Technology, Information organization
Database:
Supplemental Index

Weitere Informationen

The article discusses the new features of the software MySQL 5. The new features are the new metadata database and new SQL options. The new innovations in MySQL 5 allows the retrieval of information about the database through a virtual information storage filled with metadata called information0331schema. The MySQL options controls the processing of queries. It can be activated on a per-session basis or globally. Its behavior is different for a transactional and non-transactional table. In non-transactional tables, errors appears only if the changed in the first row is the one that causes the error and the STRICT0331ALL0331TABLES or STRICT0331TRANS0331TABLES is enabled.