Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Sign up for free
Menu
Search
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Pricing
Search
Sign in
Sign up for free
MySQL – ohMyGOD
Search
Michal Wiglasz
November 28, 2013
310
1
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
MySQL – ohMyGOD
Krátký talk v rámci listopadováho PyVa v Koločavě.
Michal Wiglasz
November 28, 2013
Transcript
24 slides
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
More Decks by Michal Wiglasz
See All by Michal Wiglasz
Prudce inteligentní talk o umělé inteligenci
kacer
0
150
Projekt SFC
kacer
0
180
Featured
See All Featured
Why Mistakes Are the Best Teachers: Turning Failure into a Pathway for Growth
auna
0
370
A Soul's Torment
seathinner
9
3.9k
Heart Work Chapter 1 - Part 1
lfama
PRO
11
37k
SEO in 2025: How to Prepare for the Future of Search
ipullrank
3
3.9k
Public Speaking Without Barfing On Your Shoes - THAT 2023
reverentgeek
1
670
Side Projects
sachag
456
43k
Fireside Chat
paigeccino
43
4.1k
Game over? The fight for quality and originality in the time of robots
wayneb77
1
340
Kristin Tynski - Automating Marketing Tasks With AI
techseoconnect
PRO
0
600
Automating Front-end Workflow
addyosmani
1370
210k
Understanding Cognitive Biases in Performance Measurement
bluesmoon
32
3.1k
Reflections from 52 weeks, 52 projects
jeffersonlam
356
22k