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 Add an attribute to existing table

Add an attribute to existing table

mysql

1 1139 posted 16 years ago by marouanomezzine

MySQL Restore Drupal 4 default input filters

mysql

0 1004 posted 16 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 1114 posted 16 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 1420 posted 16 years ago by zingo

MySQL How to follow the progress of a running MySQL command

mysql

1 1061 posted 16 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.