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 Altering Database Tables: Add More Columns :

mysql

1 1203 posted 15 years ago by magicrebirth

MySQL Greek utf-8 & mysql

mysql

1 996 posted 15 years ago by jmacgr

MySQL MANEJO CURSOR MYSQL

Esquema basico manejo cursores en MYSQL

mysql

0 873 posted 15 years ago by xaviles

MySQL Create UTF8 DB Command line

mysql

0 909 posted 15 years ago by level09

MySQL select first character of second word (surname)

mysql

0 980 posted 15 years ago by ReeceMarsland

MySQL How to Save results from MySQL into an external file

mysql

1 1303 posted 15 years ago by endorfin

MySQL MySQL Age Calucation

Some code I found for calculating and determining a persons age

mysql

1 873 posted 15 years ago by mpcircuitry

MySQL Date formatting with LOAD DATA INFILE

Came across this nice snippet @ mysql.com

mysql

2 3399 posted 15 years ago by j4kp07

MySQL Drupal 6.x Find PHP code in database

mysql

2 1222 posted 15 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!

mysql

0 1079 posted 15 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!

mysql

0 992 posted 15 years ago by beneberle

MySQL MySQL: Dump remote database

mysql

1 1105 posted 15 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

0 968 posted 15 years ago by ginoplusio

MySQL MySQL REGEX match comma-delimitted list

mysql

1 1279 posted 15 years ago by j4kp07

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

1 1113 posted 15 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 1067 posted 15 years ago by cherbert

MySQL Delete Orphaned Records

mysql

1 932 posted 15 years ago by nkm

MySQL Import MySQL dumpfile into database

mysql

0 1062 posted 15 years ago by danshields

MySQL Dump database mysql commandline

Remove <>

mysql

0 1204 posted 15 years ago by jodm

MySQL Purge MySQL Binary Logs

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

mysql

2 926 posted 15 years ago by mushookies

MySQL MySQL Canada Provinces Territories

mysql

0 1353 posted 15 years ago by CuDDL

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

mysql

0 1113 posted 15 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...