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 Tagged mysql

« Prev 1 2 3 4 5 6 Next »

MySQL Restore Drupal 4 default input filters

mysql

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

mysql

4 2275 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

1 2496 posted 17 years ago by zingo

MySQL How to follow the progress of a running MySQL command

mysql

1 2084 posted 17 years ago by paulbooker

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.