Welcome To Snipplr


Everyone's Recent MySQL Snippets



1 ... 4 5 6 7 8
Used to make sure the server log dose not fill up the hd.
2 309 posted 12 years ago by mushookies
This script shows the top 10 worst indexes (in terms of selectivity %) on the whole MySQL server instance. Selectivity is the percentage of distinct values in an indexed field compared to the number of records in the table. Note that this query can...
1 283 posted 12 years ago by Eloi
This will create and then populate a MySQL table with a list of the names for countries in existence. Country names are in Turkish language.
0 546 posted 12 years ago by sensimevanidus
granting DB specific and general access priveleges from the CLI
1 364 posted 12 years ago by stiobhart
CLI commands for backing up mySQL database
2 447 posted 12 years ago by stiobhart
2 276 posted 12 years ago by atma
Splitting table users in frequently and infrequently accessed attributes
2 644 posted 12 years ago by Eloi
Saving the IP as Int we save a lot of space and permit do beautibul selects
2 338 posted 12 years ago by Eloi
If you run a query to delete old posts manually from MySQL in a WordPress database, the old tags will remain and appear in your tag cloud/listing. This allows you to identify those unused tags, and then delete them with an additional query.
0 319 posted 12 years ago by jkriddle
Administering more than one node at a time through the Drupal admin interface is like drinking a milkshake through a buckytube. [How to use phpmyadmin and sql to perform mass operations on nodes](http://drupal.org/node/134535)
1 398 posted 12 years ago by zachharkey
In case you don't feel like loading 3 pages to edit a single url alias.
1 404 posted 12 years ago by zachharkey
2 387 posted 12 years ago by craig1709
Add an attribute to existing table
1 400 posted 12 years ago by marouanomezzine
We wanted to change all /films/example style paths to /film/example (basically remove the 's'). Here was the query that worked:
1 305 posted 12 years ago by zachharkey
When you forget to "SET NAMES utf8", you'll probably end up with a bunch of latin1 data in your utf8 column. This query fixes that, CONVERTing the existing data to its correct collation.
4 372 posted 12 years ago by jdbartlett
Show table size, number of rows, and size of indexes in MySQL.
1 537 posted 12 years ago by zingo
This gets me every time. Why doesn't my blog work?! Oh yeah, that's why.
0 290 posted 12 years ago by jaspertandy
I currently have project_issue nodes set for replacement pattern issues/issue[nid] in Drupal 5.x PathAuto. This query fixes all of the URL aliases for entries created before this was set correctly.
0 319 posted 12 years ago by tgbdad
1 288 posted 13 years ago by ping_ch
Some other alter syntax examples at the URL, which beats the pants off the MySQL manual for some reason.
0 385 posted 13 years ago by tclancy
0 385 posted 13 years ago by sebus
1 ... 4 5 6 7 8