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

« Prev 1 2 3 4 5 6 7 Next »

MySQL Magento update base url after transfer

mysql

0 1854 posted 16 years ago by danshields

MySQL Magento update base url after transfer

mysql

0 1746 posted 16 years ago by danshields

MySQL MySql script to find invalid email addresses

email
find

1 2446 posted 16 years ago by fackz

MySQL Specify 'Order By' order

0 1902 posted 16 years ago by bradless

MySQL Altering Database Tables: Add More Columns :

mysql

1 2068 posted 16 years ago by magicrebirth

MySQL Greek utf-8 & mysql

1 1796 posted 16 years ago by jmacgr

MySQL MANEJO CURSOR MYSQL

Esquema basico manejo cursores en MYSQL

mysql

0 1584 posted 16 years ago by xaviles

MySQL Create UTF8 DB Command line

mysql

0 1591 posted 16 years ago by level09

MySQL Starting and stopping MySQL

1 1491 posted 16 years ago by magicrebirth

MySQL select first character of second word (surname)

mysql

0 1758 posted 16 years ago by ReeceMarsland

MySQL How to Save results from MySQL into an external file

mysql

1 2504 posted 16 years ago by endorfin

MySQL MySQL Age Calucation

Some code I found for calculating and determining a persons age

mysql

1 1569 posted 16 years ago by mpcircuitry

MySQL Date formatting with LOAD DATA INFILE

Came across this nice snippet @ mysql.com

2 4675 posted 16 years ago by j4kp07

MySQL Drupal 6.x Find PHP code in database

2 2045 posted 16 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 1892 posted 16 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 1718 posted 16 years ago by beneberle

MySQL Reset Auto Increment for a Table

0 1880 posted 16 years ago by kingkool68

MySQL MySQL: Dump remote database

mysql

1 1915 posted 16 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 1737 posted 16 years ago by ginoplusio

MySQL MySQL REGEX match comma-delimitted list

1 2412 posted 16 years ago by j4kp07

MySQL Insert or update if unique key already exist

update

2 1993 posted 16 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 2007 posted 16 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 1803 posted 16 years ago by cherbert

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 2260 posted 16 years ago by iroybot

MySQL Import MySQL dumpfile into database

0 1974 posted 16 years ago by danshields

MySQL Dump database mysql commandline

Remove <>

mysql

0 3083 posted 17 years ago by jodm

MySQL Purge MySQL Binary Logs

Used to make sure the server log dose not fill up the hd.

log
mysql

2 1921 posted 17 years ago by mushookies

MySQL MySQL Canada Provinces Territories

0 2056 posted 17 years ago by CuDDL

MySQL mySQL 5 Import / Export bei einem 1und1 Homepage Server

mysql

0 1965 posted 17 years ago by humanoid

MySQL The Worst Performing Indexes

This script shows the top 10 worst indexes (in terms of selectivity %) on the whole MySQL server instance. Selectivity is the percentage of distinct values in an indexed field compared to the number of records in the table. Note that this query can...

mysql

1 1777 posted 17 years ago by Eloi