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 1079 posted 14 years ago by erraja_07

MySQL Updated mysql database from SQL dump

mysql

0 1252 posted 14 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 1163 posted 14 years ago by TheJasonParker

MySQL Ordering by specific field values

mysql

0 1028 posted 14 years ago by takel

MySQL Countif in MySQL

mysql

0 1018 posted 14 years ago by dsoms

MySQL import from file

mysql

1 1040 posted 14 years ago by yanek1988

MySQL mysql md5 hash slect

mysql

0 992 posted 14 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 1472 posted 14 years ago by tonatiuh

MySQL Find and Replace on MySQL

mysql

0 1264 posted 14 years ago by BoNzO

MySQL MySQL Find and Replace

mysql

3 1447 posted 14 years ago by nielsenrc

MySQL migrate from detailed stats to hourly stats

mysql

0 948 posted 14 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 1151 posted 14 years ago by daipratt

MySQL Small MySQL backup shell script

mysql

0 1074 posted 14 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 1178 posted 14 years ago by gtaking

MySQL Repair a un-repairable MySql table in phpmyadmin

Use this to repair a corrupt table in phpmyadmin

mysql

0 1040 posted 14 years ago by howardpanton

MySQL Mysql - md5 hash look up

mysql

0 1035 posted 14 years ago by sjacunningham

MySQL Mysql multiple insert from select

mysql

0 1044 posted 14 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 1416 posted 14 years ago by daipratt

MySQL Reset root password in MySQL

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

mysql

0 1085 posted 14 years ago by isholgueras

MySQL Reset root password in MySQL

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

mysql

0 1052 posted 14 years ago by isholgueras

MySQL select duplicate data from mysql table

mysql

1 1399 posted 14 years ago by kaartz

MySQL SELECT ALL => MySQL Database

Use this to select all fields between two different dates

mysql

0 1081 posted 14 years ago by howardpanton

MySQL Create utf8 database cli

mysql

0 1004 posted 14 years ago by hamsterbacke82

MySQL Add 1 to a field (MySQL)

mysql

2 1310 posted 14 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 1510 posted 14 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...