Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
MySQL – ohMyGOD
Search
Michal Wiglasz
November 28, 2013
1
270
MySQL – ohMyGOD
Krátký talk v rámci listopadováho PyVa v Koločavě.
Michal Wiglasz
November 28, 2013
Tweet
Share
More Decks by Michal Wiglasz
See All by Michal Wiglasz
Prudce inteligentní talk o umělé inteligenci
kacer
0
140
Projekt SFC
kacer
0
170
Featured
See All Featured
Practical Orchestrator
shlominoach
190
11k
A better future with KSS
kneath
239
17k
Art, The Web, and Tiny UX
lynnandtonic
303
21k
Testing 201, or: Great Expectations
jmmastey
45
7.7k
Fantastic passwords and where to find them - at NoRuKo
philnash
52
3.4k
A Modern Web Designer's Workflow
chriscoyier
697
190k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
morganepeng
132
19k
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
kevinliebholz
34
6.1k
How GitHub (no longer) Works
holman
315
140k
Why You Should Never Use an ORM
jnunemaker
PRO
59
9.6k
Typedesign – Prime Four
hannesfritz
42
2.8k
Six Lessons from altMBA
skipperchong
28
4k
Transcript
Michal Wiglasz @kacer
Kotva první Regulární výrazy
Regulární výrazy SELECT * FROM articles WHERE title LIKE "%mysql
5.0%"; SELECT * FROM articles WHERE title REGEX "mysql 5\.0";
Regulární výrazy SELECT * FROM articles WHERE title LIKE "%mysql
5.0%"; OK, 150 results. SELECT * FROM articles WHERE title REGEX "mysql 5\.0"; OK, 0 results.
Regulární výrazy REGEX + multibyte = case-sensitive Vždy. Nahlášeno v
roce 2007. Oprava = poznámka v dokumentaci.
None
Regulární výrazy (asi) jediné řešení SELECT * FROM articles WHERE
title REGEX "[mM][yY][sS][qQ][lL] 5\.0";
Kotva druhá ALTER TABLE
ALTER TABLE ALTER TABLE huge_table ADD INDEX some_column (some_column);
ALTER TABLE Copying to tmp table
None
ALTER TABLE řešení InnoDB plugin Proč mít jednu implementaci, když
můžeme mít dvě.
ALTER TABLE ALTER TABLE huge_table ADD FOREIGN KEY (some_column) REFERENCES
small_table(id);
ALTER TABLE Copying to tmp table
ALTER TABLE ALTER TABLE huge_table DROP FOREIGN KEY some_key; ALTER
TABLE huge_table DROP some_column;
ALTER TABLE Copying to tmp table Copying to tmp table
Kotva třetí utf8
utf8 INSERT INTO comments (text) VALUES ("Mám rád ❄ a
rád stavím "); ☃ Warning. SELECT * FROM comments; "Mám rád "
None
utf8 řešení utf8mb4 Proč mít jednu implementaci, když můžeme mít
dvě.
utf8mb4 • Sehnat • Zkompilovat • ALTER TABLE • OPTIMIZE
TABLE • REPAIR TABLE • Pak to snad bude fungovat...
utf8mb4 INSERT INTO comments (text) VALUES ("MySQL je "); Warning.
SELECT * FROM comments; "Mysql je ????"
utf8mb4 USE NAMES utf8mb4;
Michal Wiglasz @kacer