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
260
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
A better future with KSS
kneath
238
17k
KATA
mclloyd
30
14k
Into the Great Unknown - MozCon
thekraken
40
1.9k
What's in a price? How to price your products and services
michaelherold
246
12k
Large-scale JavaScript Application Architecture
addyosmani
512
110k
Mobile First: as difficult as doing things right
swwweet
223
9.7k
Reflections from 52 weeks, 52 projects
jeffersonlam
351
21k
Documentation Writing (for coders)
carmenintech
72
4.9k
Agile that works and the tools we love
rasmusluckow
329
21k
The Success of Rails: Ensuring Growth for the Next 100 Years
eileencodes
45
7.5k
Product Roadmaps are Hard
iamctodd
PRO
54
11k
Typedesign – Prime Four
hannesfritz
42
2.7k
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