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 857 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 777 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 1248 posted 15 years ago by sensimevanidus

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

mysql

0 847 posted 15 years ago by paulbooker

MySQL mySQL - granting access permissions

granting DB specific and general access priveleges from the CLI

1 861 posted 15 years ago by stiobhart

MySQL mySQL - database backup commands

CLI commands for backing up mySQL database

2 1026 posted 15 years ago by stiobhart

MySQL Clear WP revisions in DB

wordpress

2 746 posted 15 years ago by atma

MySQL Create Table Users

Splitting table users in frequently and infrequently accessed attributes

mysql

2 1189 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 801 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 757 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 873 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 846 posted 15 years ago by zachharkey

MySQL Select between two dates

date
mysql

2 881 posted 15 years ago by craig1709

MySQL Add an attribute to existing table

Add an attribute to existing table

mysql

1 908 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 671 posted 15 years ago by zachharkey

MySQL Restore Drupal 4 default input filters

0 774 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 871 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 1162 posted 15 years ago by zingo

MySQL ConversiÃ³n de Latin1 a UTF8

wordpress

0 909 posted 15 years ago by rolandog

MySQL How to follow the progress of a running MySQL command

mysql

1 844 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 638 posted 15 years ago by jaspertandy

MySQL MySQL Search & Replace on WP-Posts Table

wordpress

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