Search Results
https://dev.mysql.com/doc/refman/8.4/en/row-constructor-optimization.html
Consider the following table, which has a primary key on (c1, c2, c3): CREATE TABLE t1 ( c1 INT, c2 INT, c3 INT, c4 CHAR(100), PRIMARY KEY(c1,c2,c3) ); In this query, the WHERE clause uses all columns in the index. row *************************** ...
https://dev.mysql.com/doc/refman/8.4/en/view-check-option.html
The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not true. In a WITH CHECK OPTION clause for an updatable view, the LOCAL and CASCADED keywords ...It ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-columns-tab.html
Use the Columns subtab to display and edit all the column information for a table. You can also add a primary key by checking the PRIMARY KEY check box in the Column Details section of the table editor. If you wish to create a composite primary key ...You can also use the Columns subtab to change column properties such as name, data type, and default ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-literals.html
This section describes the acceptable formats for date and time literals. You can specify a time zone offset when inserting TIMESTAMP and DATETIME values into a table. Standard SQL and ODBC Date and Time Literals String and Numeric Literals in Date ...
https://dev.mysql.com/doc/internals/en/optimizer-and-relations.html
Here's an example: CREATE TABLE Table1 (s1 INT, s2 INT); CREATE INDEX Index1 ON Table1 (s2); CREATE INDEX Index2 ON Table1 (s1); ... SELECT * FROM Table1 WHERE s1 = 5 AND s2 = 5; When choosing a strategy to solve this query, the optimizer picks s2 = ...Otherwise, since (both conditions are indexed and have equal join type) pick a driver based on the first index that was ... An ANDed search has the form condition1 AND condition2, as in this example: WHERE column1 = 'x' AND column2 = ...
https://dev.mysql.com/doc/connectors/en/connector-python-multi.html
Example: CREATE TABLE `delimiter` (begin INT, end INT); -- I am a `DELimiTer` comment Fetching Result Sets Basic usage (mapping disabled): sql_operation = """ SET @a=1, @b='2024-02-01'; SELECT @a, LENGTH('hello'), @b; SELECT @@version; """ with ...
https://dev.mysql.com/doc/connector-python/en/connector-python-multi.html
Example: CREATE TABLE `delimiter` (begin INT, end INT); -- I am a `DELimiTer` comment Fetching Result Sets Basic usage (mapping disabled): sql_operation = """ SET @a=1, @b='2024-02-01'; SELECT @a, LENGTH('hello'), @b; SELECT @@version; """ with ...
https://dev.mysql.com/doc/refman/8.4/en/full-text-adding-collation.html
The instructions here add a collation for a simple character set, which as discussed in Section 12.14, “Adding a Collation to a Character Set”, can be created using a configuration file that describes the character set properties. For a complex ... Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-config-example.html
You may also specify these parameters on the command line when invoking the executables. You may also use a separate [mysql_cluster] section in the cluster my.cnf file for settings to be read and used by all executables: # cluster-specific settings ... To support NDB Cluster, you should update my.cnf as shown in the following ...
https://dev.mysql.com/doc/internals/en/mismatch-of-focus-of-test-and-code-sequence.html
CREATE TABLE t1 ( id INT NOT NULL AUTO_INCREMENT, my_column VARCHAR(30), name LONGTEXT, PRIMARY KEY (id)); INSERT INTO t1(my_column,name) VALUES('2','two'); INSERT INTO t1(my_column,name) VALUES('1','one'); INSERT INTO t1(my_column,name) ...