Search Results
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-1.html
It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or more). InnoDB: For tables created with an index on a column that was too wide for the redundant row ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-60.html
Figure 1.41 Cascading SELECT Table Templates Define templates of tables with commonly used columns, to be used to create new tables in a live connection or in an EER model. In the SQL Editor, choose Create Table Like, or in Modeling, use the right ...Figure 1.36 Comparing the SQL Editor interface for Workbench 5.2 and 6.0 Table Data Search You can select schemas, tables, or both to perform client-side searches for user specified strings and ...
https://dev.mysql.com/doc/refman/8.4/en/insert-on-duplicate.html
In general, you should try to avoid using an ON DUPLICATE KEY UPDATE clause on tables with multiple unique indexes. It is possible to use IGNORE with ON DUPLICATE KEY UPDATE in an INSERT statement, but this may not behave as you expect when ... If ...
https://dev.mysql.com/doc/refman/8.4/en/cast-functions.html
Other Uses for Cast Operations The cast functions are useful for creating a column with a specific type in a CREATE TABLE ... SELECT statement: mysql> CREATE TABLE new_table SELECT CAST('2000-01-01' AS DATE) AS c1; mysql> SHOW CREATE TABLE ... Table ...A common use for BINARY is to force a character string comparison to be done byte by byte using numeric byte values rather than character by ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-programming-vb.html
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 rs.addNew, rs.delete, and rs.update. rs.Open "SELECT * FROM my_ado" rs!Name = "update" rs!txt = ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-json-import-command.html
To create and import to a table, you must also specify a column name as a further parameter, in which case the utility creates a relational table with the specified table name and imports the data to the specified column. To import the file to a ...
https://dev.mysql.com/doc/ndbapi/en/overview-operations.html
Create a scan operation (NdbScanOperation) on this table myOperation= myTransaction->getNdbScanOperation(myTable); // 3. We have created a very simple benchmark to check the performance of each of these. Unique key accesses are similar to primary ...
https://dev.mysql.com/doc/refman/8.4/en/connection-access.html
The server performs identity and credentials checking using columns in the user table, accepting the connection only if these conditions are satisfied: The client host name and user name match the Host and User columns in some user table row. When ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-statistics.html
The table is persistent so that column statistics need not be created each time the server starts. This histogram type is created when the number of distinct values in the column is less than or equal to the number of buckets specified in the ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-errors.html
On Windows x64 editions, use the ODBC administration tool located at %SystemRoot%\SysWOW64\odbcad32.exe, this will correctly locate the installed Connector/ODBC drivers and enable you to create a Connector/ODBC DSN. "Transactions are not enabled" ...