You are here: start » mysql » snippets

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
mysql:snippets [2017-06-03 11:05] – [Character Sets] adminmysql:snippets [2023-10-26 20:04] (current) – external edit 127.0.0.1
Line 3: Line 3:
   * Change to UTF-8 (use utf8mb4 to include latest emoticons)   * Change to UTF-8 (use utf8mb4 to include latest emoticons)
     * ''ALTER TABLE xx CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;''     * ''ALTER TABLE xx CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;''
 +=== Table manipulation ===
   * Duplicate rows   * Duplicate rows
     * ''CREATE TEMPORARY TABLE tmp SELECT * FROM table WHERE column = X;''     * ''CREATE TEMPORARY TABLE tmp SELECT * FROM table WHERE column = X;''