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
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
danielanewman
229
22k
Easily Structure & Communicate Ideas using Wireframe
afnizarnur
194
16k
Automating Front-end Workflow
addyosmani
1370
200k
Raft: Consensus for Rubyists
vanstee
140
7.1k
I Don’t Have Time: Getting Over the Fear to Launch Your Podcast
jcasabona
33
2.4k
Optimising Largest Contentful Paint
csswizardry
37
3.4k
Bootstrapping a Software Product
garrettdimon
PRO
307
110k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
mongodb
48
9.7k
The Straight Up "How To Draw Better" Workshop
denniskardys
236
140k
Embracing the Ebb and Flow
colly
87
4.8k
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
panda_program
113
20k
Keith and Marios Guide to Fast Websites
keithpitt
411
22k
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