|
gibney.org : Technology : Programming : SQL
(Entry Nr. 55, by user 1
| edit)
|
| Speed optimization techniques |
| The \\\% mystery SELECT * FROM some_table WHERE some_field LIKE "\\\%" matches fields beginning with the character ä |
| LOAD DATA The LOAD DATA statement loads data from a textfile into a table. |
| Pipe a zipped dump into mysql For exampe to restore a database backup. |
| Disable MySql binlog mysqld --disable-binlog-do-db |
| Dump Tables LIKE "some_prefix%" |
|
Maatkit
A collection of Perl scripts, that might be worth checking out:
www.maatkit.org |
| Create a new entry at this position |