Search Results
https://dev.mysql.com/doc/refman/8.4/en/multiple-tables.html
The pet table keeps track of which pets you have. If you want to record other information about them, such as events in their lives like visits to the vet or when litters are born, you need another table. What should this table look like? It needs ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-ftdump.html
Example: Suppose that the test database contains a table named mytexttable that has the following definition: CREATE TABLE mytexttable ( id INT NOT NULL, txt TEXT NOT NULL, PRIMARY KEY (id), FULLTEXT (txt) ) ENGINE=MyISAM; The index on id is index 0 ...It reads the MyISAM index file directly, so it must be run on the server host where the table is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-dictionary-columns.html
The table provides NDB dictionary information about columns of NDB tables.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-foreign-keys.html
The foreign_keys table provides information about foreign keys on NDB tables.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-privilege-synchronization.html
Privilege synchronization is the mechanism used by NDB Cluster for sharing and synchronizing users, roles, and privileges between SQL nodes. A statement granting the NDB_STORED_USER privilege, such as GRANT NDB_STORED_USER ON *.* TO ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-indexes-create.html
The final parameter indicates whether the field should require the NOT NULL constraint. If the value is false, the field can contain NULL values. Indexes are used to find documents with specific field values quickly. Without an index, MySQL must ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-documents-index.html
The final parameter indicates whether the field should require the NOT NULL constraint. If the value is false, the field can contain NULL values. Indexes are used to find documents with specific field values quickly. Without an index, MySQL must ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-accounts-table.html
This is NULL for an internal thread, or for a user session that failed to authenticate. This is NULL for an internal thread, or for a user session that failed to authenticate. The accounts table contains a row for each account that has connected to ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-atom-molecule-events.html
For example, a row fetch might result in rows like this: Row# EVENT_NAME TIMER_START TIMER_END ---- ---------- ----------- --------- 1 wait/io/file/myisam/dfile 10001 10002 2 wait/io/table/sql/handler 10000 NULL The row fetch causes a file read. In ... For a table I/O event, there are usually two rows in events_waits_current, not ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-stages-current-table.html
END_EVENT_ID This column is set to NULL when the event starts and updated to the thread current event number when the event ends. If an event is produced from an instrument that has TIMED = NO, timing information is not collected, and TIMER_START, ...The table stores one row per thread showing the current status of the thread's most recent monitored stage event, so there is no system variable for configuring the table ...