https://dev.mysql.com/csv-storage-engine.html
The CSV storage engine is always compiled into the MySQL server. When you store data into the table, the storage engine saves it into the data file in comma-separated values format. The CSV storage engine stores data in text files using ...
https://dev.mysql.com/data-size.html
For example, use the smaller integer types if possible to get smaller tables. MEDIUMINT is often a better choice than INT because a MEDIUMINT column uses 25% less space. You can hint that you want to have fixed length rows even if you have VARCHAR ... Design your tables to minimize their space on the ...
https://dev.mysql.com/datetime.html
In particular, any fractional part in a value inserted into a DATETIME or TIMESTAMP column is stored rather than discarded. The fractional part should always be separated from the rest of the time by a decimal point; no other fractional seconds ...
https://dev.mysql.com/drop-tablespace.html
The UNDO keyword, introduced in MySQL 8.0.14, must be specified to drop an undo tablespace. Similar to the system tablespace, truncating or dropping tables stored in a general tablespace creates free space internally in the general tablespace .ibd ... DROP [UNDO] TABLESPACE tablespace_name [ENGINE [=] engine_name] This statement drops a tablespace that was previously created using CREATE ...
https://dev.mysql.com/example-auto-increment.html
For example: INSERT INTO animals (id,name) VALUES(0,'groundhog'); If the column is declared NOT NULL, it is also possible to assign NULL to the column to generate sequence numbers. For example: INSERT INTO animals (id,name) VALUES(NULL,'squirrel'); ...You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is ...
https://dev.mysql.com/example-storage-engine.html
mysql> CREATE TABLE test (i INT) ENGINE = EXAMPLE; Query OK, 0 rows affected (0.78 sec) mysql> INSERT INTO test VALUES(1),(2),(3); ERROR 1031 (HY000): Table storage engine for 'test' doesn't » have this option mysql> SELECT * FROM test; Empty set ... The EXAMPLE storage engine is a stub engine that does ...
https://dev.mysql.com/examples.html
Here are examples of how to solve some common problems with MySQL. Some of the examples use the table shop to hold the price of each article (item number) for certain traders (dealers). Supposing that each trader has a single fixed price per ...
https://dev.mysql.com/extensions-to-ansi.html
The KEY_BLOCK_SIZE clause in the following comment is executed only by servers from MySQL 5.1.10 or higher: CREATE TABLE t1(a INT, KEY (a)) /*!50110 KEY_BLOCK_SIZE=1024 */; The following descriptions list MySQL extensions, organized by category. If ... MySQL Server supports some extensions that you probably will not find in other SQL ...
https://dev.mysql.com/fulltext-boolean.html
The full-text engine splits the phrase into words and performs a search in the FULLTEXT index for the words. '+apple macintosh' Find rows that contain the word “apple”, but rank rows higher if they also contain “macintosh”. '+apple ... MySQL ...
https://dev.mysql.com/fulltext-natural-language.html
Note The term “document” may be used interchangeably with the term “row”, and both terms refer to the indexed part of the row. The full-text engine splits the phrase into words and performs a search in the FULLTEXT index for the words. If ...
