diff options
| author | Owen Jacobson <owen@grimoire.ca> | 2017-02-08 20:04:48 -0500 |
|---|---|---|
| committer | Owen Jacobson <owen@grimoire.ca> | 2017-02-08 20:04:48 -0500 |
| commit | c45f1188f7aa915d0812bb7536e8097bb9637cbc (patch) | |
| tree | bf8b1f53e904146df6b0b310ee2475b98d7a3910 | |
| parent | 815b6dd52f8ec04f4762a3a04fdc6899857a8d8e (diff) | |
Fixed dead sql_mode link (thanks, Will Sheppard!)
| -rw-r--r-- | wiki/mysql/choose-something-else.md | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/wiki/mysql/choose-something-else.md b/wiki/mysql/choose-something-else.md index b3b2c4d..62afe85 100644 --- a/wiki/mysql/choose-something-else.md +++ b/wiki/mysql/choose-something-else.md @@ -62,7 +62,7 @@ familiar with other SQL implementations). remotely like Perl). * Conversion behaviour depends on a per-connection configuration value (`sql_mode`) that has [a large constellation of possible - states](http://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.html), making + states](https://dev.mysql.com/doc/refman/5.5/en/sql-mode.html), making it harder to carry expectations from manual testing over to code or from tool to tool. * MySQL recommends UTF-8 as a character-set, but still defaults to Latin-1. @@ -105,7 +105,7 @@ familiar with other SQL implementations). ### Preserving Data ... against unexpected changes: like most disk-backed storage systems, MySQL -is as reliable as the disks and filesystems its data lives on. MySQL provides +is as reliable as the disks and filesystems its data lives on. MySQL provides no additional functionality in terms of mirroring or hardware failure tolerance (such as [Oracle ASM](http://en.wikipedia.org/wiki/Automatic_Storage_Management)). However this is a limitation shared with many, _many_ other systems. @@ -556,18 +556,18 @@ MySQL's procedural dialect -- an implementation of the DECLARE done INT DEFAULT 0; DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1; - + DECLARE c_foo INTEGER; DECLARE c_bar INTEGER; DECLARE c_baz INTEGER; - + OPEN c; process_some_table: LOOP FETCH c INTO c_foo, c_bar, c_baz; IF done THEN LEAVE process_some_table; END IF; - + -- do something with c_foo, c_bar, c_baz END LOOP; END; |
