This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Last revision Both sides next revision | ||
database_notes [2019/03/24 17:03] steve |
database_notes [2019/03/24 17:04] steve |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Database Notes ====== | ====== Database Notes ====== | ||
- | ** This is legacy documentation from old releases.** | ||
- | |||
- | Developer Notes | ||
These are just notes and things I've picked up about SQL and the databases while working with this project. | These are just notes and things I've picked up about SQL and the databases while working with this project. | ||
- | MySQL | + | ===== MySQL ===== |
Copy table: | Copy table: | ||
Line 88: | Line 85: | ||
</code> | </code> | ||
- | Regular Expressions | + | ==== Regular Expressions ==== |
MySQL's regular expression function (REGEXP) is case INsensitive on non-binary strings. Convert the data to a binary string before running case sensitive matches: SELECT BINARY text REGEXP '<case-sensitive pattern>'; | MySQL's regular expression function (REGEXP) is case INsensitive on non-binary strings. Convert the data to a binary string before running case sensitive matches: SELECT BINARY text REGEXP '<case-sensitive pattern>'; | ||
Line 104: | Line 101: | ||
</code> | </code> | ||
- | SQLite | + | ===== SQLite ===== |
Create an index: | Create an index: |