User Tools
database_notes
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
database_notes [2019/03/24 17:03] steve |
database_notes [2019/03/24 17:05] 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: | ||
| Line 124: | Line 121: | ||
| </code> | </code> | ||
| - | PostgreSQL | + | ===== PostgreSQL ===== |
| Show databases, tables, table description: | Show databases, tables, table description: | ||
database_notes.txt ยท Last modified: 2019/03/24 17:05 by steve
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
