Login / Register

Share Snipplr

Welcome To Snipplr

Everyone's Recent MySQL Snippets

MySQL Wordpress updating URL paths after address change

If the official codex approach (http://codex.wordpress.org/Changing_The_Site_URL) is causing you problems, give this a try. Be sure to change the constant declarations and modify table names as necessary for your instance. Confirmed working with WP v...

1 664 posted 13 years ago by johnandrewsroot

MySQL Magento update base url after transfer

mysql

0 489 posted 13 years ago by danshields

MySQL Magento update base url after transfer

mysql

0 460 posted 13 years ago by danshields

MySQL MySql script to find invalid email addresses

email
find

1 618 posted 13 years ago by fackz

MySQL Specify 'Order By' order

0 505 posted 13 years ago by bradless

MySQL Altering Database Tables: Add More Columns :

mysql

1 558 posted 13 years ago by magicrebirth

MySQL Greek utf-8 & mysql

1 471 posted 13 years ago by jmacgr

MySQL MANEJO CURSOR MYSQL

Esquema basico manejo cursores en MYSQL

mysql

0 379 posted 13 years ago by xaviles

MySQL Create UTF8 DB Command line

mysql

0 407 posted 13 years ago by level09

MySQL Starting and stopping MySQL

1 354 posted 13 years ago by magicrebirth

MySQL select first character of second word (surname)

mysql

0 438 posted 13 years ago by ReeceMarsland

MySQL How to Save results from MySQL into an external file

mysql

1 695 posted 13 years ago by endorfin

MySQL MySQL Age Calucation

Some code I found for calculating and determining a persons age

mysql

1 412 posted 13 years ago by mpcircuitry

MySQL Date formatting with LOAD DATA INFILE

Came across this nice snippet @ mysql.com

2 2242 posted 13 years ago by j4kp07

MySQL Drupal 6.x Find PHP code in database

2 625 posted 13 years ago by ReeceMarsland

MySQL Drupal 5.x Find PHP code in database

used to find content that uses the PHP input filter....useful for upgrading core!

0 552 posted 13 years ago by ReeceMarsland

MySQL Wordpress: Local To Remote Procedures

Just updated for WP 3 (added wp_postmeta table for menus)! Test out the new installation thoroughly but everything should be fine, and your CMS should be running live on the new server!

0 471 posted 13 years ago by beneberle

MySQL Reset Auto Increment for a Table

0 560 posted 13 years ago by kingkool68

MySQL MySQL: Dump remote database

mysql

1 505 posted 13 years ago by nate63179

MySQL Stop utf8 problems with mysql

- fields on db with utf8_general_ci collation - make this query after any connection - put meta charset utf8 - read and write strings without problems

mysql
php

0 469 posted 13 years ago by ginoplusio

MySQL MySQL REGEX match comma-delimitted list

1 550 posted 13 years ago by j4kp07

MySQL Insert or update if unique key already exist

update

2 527 posted 13 years ago by Zwendel

MySQL Get random record based on weight

Must have a field named Weight. The more Weight the more often the record is selected. Weight should be an integer between 1 and 10.

mysql
query

1 583 posted 13 years ago by BFTrick

MySQL MySQL Insert Unique Reference

MySQL Insert Unique Reference using MAX() to obtain latest value Alternate solution to using Composite Primary Keys which INNODB engine does not support.

mysql

0 444 posted 13 years ago by cherbert

MySQL Delete Orphaned Records

mysql

1 421 posted 13 years ago by nkm

MySQL Conditional String Replace

as a note to self... in order to find it laters... This will only alter the value of fieldname if the conditions in the WHERE clause are met. With replace we only replace a certain string within fieldname with the replace_with string

1 492 posted 13 years ago by iroybot

MySQL Import MySQL dumpfile into database

0 456 posted 13 years ago by danshields

MySQL Dump database mysql commandline

Remove <>