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 MySQL - Regular expressions

mysql

0 1826 posted 15 years ago by erraja_07

MySQL Updated mysql database from SQL dump

mysql

0 2087 posted 15 years ago by greeneggs614

MySQL Restore MySQL database in WampServer

Go to the Windows command line by going to Start -> Run and typing in cmd. You need to change directory to the MySQL bin directory. On my version, the directory is c:\wamp\bin\mysql\mysql4.1.22\bin. Therefore, the command to change to this dire...

mysql

0 1845 posted 15 years ago by TheJasonParker

MySQL Ordering by specific field values

mysql

0 1718 posted 15 years ago by takel

MySQL Countif in MySQL

mysql

0 1695 posted 15 years ago by dsoms

MySQL import from file

mysql

1 1699 posted 15 years ago by yanek1988

MySQL mysql md5 hash slect

mysql

0 1665 posted 15 years ago by sjacunningham

MySQL To replace \"br /\" (html tag) for php new line tag

With this snipt you could replace all the "<br>" tags that you have in a table for php newline character.

mysql

0 2330 posted 15 years ago by tonatiuh

MySQL Find and Replace on MySQL

mysql

0 2144 posted 15 years ago by BoNzO

MySQL MySQL Find and Replace

mysql

3 2376 posted 15 years ago by nielsenrc

MySQL migrate from detailed stats to hourly stats

mysql

0 1546 posted 15 years ago by pflangan

MySQL Increase the max_allowed_packet in MySQL

If you every get hit by ERROR 1153 (08S01): Got a packet bigger than 'max_allowed_packet' bytes, then this might help. You also need to make sure that the user that you log in with has SUPER privileges on their account.

mysql

0 1890 posted 15 years ago by daipratt

MySQL Small MySQL backup shell script

mysql

0 1774 posted 15 years ago by xnet74

MySQL Create a table with a dynamic name

the following code can be used to create a table with a dynamic name

mysql

0 1928 posted 15 years ago by gtaking

MySQL Repair a un-repairable MySql table in phpmyadmin

Use this to repair a corrupt table in phpmyadmin

mysql

0 1759 posted 15 years ago by howardpanton

MySQL Mysql - md5 hash look up

mysql

0 1679 posted 15 years ago by sjacunningham

MySQL Mysql multiple insert from select

mysql

0 1786 posted 15 years ago by luglio7

MySQL MySQL UNIX timestamp to readable date

Convert a Drupal time stamp field into a readable format. The Drupal time stamp field is in the UNIX format.

mysql

1 2208 posted 15 years ago by daipratt

MySQL Reset root password in MySQL

How to reset a root password in mysql with OS root user

mysql

0 1791 posted 15 years ago by isholgueras

MySQL Reset root password in MySQL

How to reset a root password in mysql with OS root user

mysql

0 1783 posted 15 years ago by isholgueras

MySQL select duplicate data from mysql table

mysql

1 2157 posted 15 years ago by kaartz

MySQL SELECT ALL => MySQL Database

Use this to select all fields between two different dates

mysql

0 1761 posted 15 years ago by howardpanton

MySQL Create utf8 database cli

mysql

0 1686 posted 15 years ago by hamsterbacke82

MySQL Add 1 to a field (MySQL)

mysql

2 2097 posted 15 years ago by cjmling

MySQL Add Wordpress admin user to database

When working on client sites, you often need admin access, instead of requiring them to set up an admin user, just make your own. ref: http://www.dnawebagency.com/how-to-add-an-admin-user-to-the-wordpress-database

mysql

2 2455 posted 15 years ago by timkinnane

MySQL Update Wordpress DB to new domain

If you\'ve got a Wordpress install that\'s changed domain or you\'re making a local or development copy, you\'ll need to update the Wordpress DB tables with the new URL.\r\nThe first step is the options table, with siteurl and homeurl. The posts als...