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 service

Welcome To Snipplr

Everyone's Recent MySQL Snippets

« Prev 1 2 3 4 5 6 7 Next »

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 2748 posted 17 years ago by sensimevanidus

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

mysql

0 2097 posted 17 years ago by paulbooker

MySQL mySQL - granting access permissions

granting DB specific and general access priveleges from the CLI

1 1939 posted 17 years ago by stiobhart

MySQL mySQL - database backup commands

CLI commands for backing up mySQL database

2 3241 posted 17 years ago by stiobhart

MySQL Clear WP revisions in DB

wordpress

2 1700 posted 17 years ago by atma

MySQL Create Table Users

Splitting table users in frequently and infrequently accessed attributes

mysql

2 2250 posted 17 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 1902 posted 17 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 1721 posted 17 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 2051 posted 17 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 2034 posted 17 years ago by zachharkey

MySQL Select between two dates

date
mysql

2 2274 posted 17 years ago by craig1709

MySQL Add an attribute to existing table

Add an attribute to existing table

mysql

1 1961 posted 17 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 1705 posted 17 years ago by zachharkey

MySQL Restore Drupal 4 default input filters

0 1870 posted 17 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 2285 posted 17 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 2510 posted 17 years ago by zingo

MySQL ConversiÃ³n de Latin1 a UTF8

wordpress

0 2087 posted 17 years ago by rolandog

MySQL How to follow the progress of a running MySQL command

mysql

1 2097 posted 17 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 1545 posted 17 years ago by jaspertandy

MySQL MySQL Search & Replace on WP-Posts Table

wordpress

1 1628 posted 17 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.