Welcome To Snipplr


Everyone's Recent Snippets Tagged mysql



PHP function that creates a mySQL INSERT statement for mime types. Type are extracted from a text file.
0 468 posted 15 years ago by fabian
It does not show the grants themselves, but shows all users with grants.
0 468 posted 15 years ago by therobot
This script removes (DROPS) all tables that start with foo_. Usefull if you had some CMS or application that (ab)uses table prefixing, and want to clean 0ut your database. NOTE: the data is remove FOREVER! So take good casre: make backups and all...
2 641 posted 15 years ago by berkes
1 593 posted 15 years ago by zingo
$duplicates checks and groups duplicated rows with the same field1 and field2 (like comments maybe) and $limit counts how many times a row is duplicated.
3 587 posted 15 years ago by Abe
1 521 posted 15 years ago by AgentPhoenix
This is a simple class to encapsulate CURD functions. This class also includes some simple search methods.
1 561 posted 15 years ago by ecavazos
1 537 posted 15 years ago by jpdamen
0 498 posted 15 years ago by jpdamen
1 553 posted 15 years ago by jpdamen
1 511 posted 15 years ago by jpdamen
1 511 posted 15 years ago by jpdamen
adapted from http://www.gotocode.com/art.asp?art_id=275&
0 640 posted 15 years ago by clapfouine
Created for my own purposes, thought I'd share though ;) copy paste at the top of your file and it does the magic :)
31 3527 posted 15 years ago by peteypablonz
1 456 posted 15 years ago by bassnode
5 446 posted 15 years ago by jrphelps
MyActiveRecord is a stand alone db abstraction layer to simplify things between php and mysql. you can download the latest version from www.wattz.net
0 594 posted 15 years ago by wattz
Just a reminder to myself, not really a snippet. When running into memory/speed issues with PHP/MySQL apps, adjust the memory_limit parameter in php.ini.
3 422 posted 15 years ago by Todd
0 545 posted 15 years ago by capu
4 558 posted 15 years ago by andyhartleeds
You can generate a simple bar chart of the values by executing this command...
0 556 posted 15 years ago by zingo