gibney.org : Technology : Programming : SQL


just a logo :)

search:


See as: raw | code

terms of service | imprint

gibney.org
is powered by m1d1





SQL
(Entry Nr. 55, by user 1 | edit)
How we do stuff with SQL Databases.
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