Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

mysql sql drupal wordpress database mac osx convert textmate date command backup ip url replace find user list line table log update query data regex csv php terminal order email path search security unix mail magento Bash linux cache code copy regexp filter forms text joomla cakephp server customer class windows format web iphone ajax api xml android actionscript window animation magentoextension apache Business

Welcome To Snipplr

Everyone's Recent MySQL Snippets

« Prev 1 2 3 4 5 6 7 Next »

MySQL mySQL 5 Import / Export bei einem 1und1 Homepage Server

mysql

0 842 posted 15 years ago by humanoid

MySQL The Worst Performing Indexes

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...

mysql

1 767 posted 15 years ago by Eloi

MySQL MySQL Table - list of all country names (in Turkish)

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.

list
mysql

0 1231 posted 15 years ago by sensimevanidus

MySQL How to install a gzipped mysqldump on a local Mamp server

mysql

0 836 posted 15 years ago by paulbooker

MySQL mySQL - granting access permissions

granting DB specific and general access priveleges from the CLI

1 850 posted 15 years ago by stiobhart

MySQL mySQL - database backup commands

CLI commands for backing up mySQL database

2 1017 posted 15 years ago by stiobhart

MySQL Clear WP revisions in DB

wordpress

2 725 posted 15 years ago by atma

MySQL Create Table Users

Splitting table users in frequently and infrequently accessed attributes

mysql

2 1178 posted 15 years ago by Eloi

MySQL Create Table Sessions

Saving the IP as Int we save a lot of space and permit do beautibul selects

ip
mysql

2 793 posted 15 years ago by Eloi

MySQL WordPress Query to Identify Unused Tags

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.

wordpress

0 744 posted 15 years ago by jkriddle

MySQL MySQL queries for performing bulk operations on Drupal nodes

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)

drupal

1 861 posted 15 years ago by zachharkey

MySQL MySQL queries for bulk editing Drupal url aliases

In case you don't feel like loading 3 pages to edit a single url alias.

drupal

1 833 posted 15 years ago by zachharkey

MySQL Select between two dates

date
mysql

2 870 posted 15 years ago by craig1709

MySQL Add an attribute to existing table

Add an attribute to existing table

mysql

1 903 posted 15 years ago by marouanomezzine

MySQL Selectively updating Drupal's pathauto aliases based on patterns

We wanted to change all /films/example style paths to /film/example (basically remove the 's'). Here was the query that worked:

drupal

1 661 posted 15 years ago by zachharkey

MySQL Restore Drupal 4 default input filters

0 764 posted 15 years ago by zachharkey

MySQL Correcting wrong character encoding in MySQL data

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 860 posted 15 years ago by jdbartlett

MySQL MySQL table size, number of rows, and size of indexes

Show table size, number of rows, and size of indexes in MySQL.

mysql
sql

1 1147 posted 15 years ago by zingo

MySQL ConversiÃ³n de Latin1 a UTF8

wordpress

0 897 posted 15 years ago by rolandog

MySQL How to follow the progress of a running MySQL command

mysql

1 831 posted 15 years ago by paulbooker

MySQL WordPress blog changes domain

This gets me every time. Why doesn't my blog work?! Oh yeah, that's why.

wordpress

0 634 posted 15 years ago by jaspertandy

MySQL MySQL Search & Replace on WP-Posts Table

wordpress

1 761 posted 15 years ago by mattbrett

MySQL Fix screwy URL aliases for project_issue nodes

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.