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 1788 posted 16 years ago by magicrebirth

MySQL Greek utf-8 & mysql

mysql

1 1553 posted 16 years ago by jmacgr

MySQL MANEJO CURSOR MYSQL

Esquema basico manejo cursores en MYSQL

mysql

0 1341 posted 16 years ago by xaviles

MySQL Create UTF8 DB Command line

mysql

0 1364 posted 16 years ago by level09

MySQL select first character of second word (surname)

mysql

0 1532 posted 16 years ago by ReeceMarsland

MySQL How to Save results from MySQL into an external file

mysql

1 2227 posted 16 years ago by endorfin

MySQL MySQL Age Calucation

Some code I found for calculating and determining a persons age

mysql

1 1329 posted 16 years ago by mpcircuitry

MySQL Date formatting with LOAD DATA INFILE

Came across this nice snippet @ mysql.com

mysql

2 4389 posted 16 years ago by j4kp07

MySQL Drupal 6.x Find PHP code in database

mysql

2 1790 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!

mysql

0 1630 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!

mysql

0 1498 posted 16 years ago by beneberle

MySQL MySQL: Dump remote database

mysql

1 1689 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

0 1489 posted 16 years ago by ginoplusio

MySQL MySQL REGEX match comma-delimitted list

mysql

1 2067 posted 16 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 1738 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 1556 posted 16 years ago by cherbert

MySQL Delete Orphaned Records

mysql

1 1467 posted 16 years ago by nkm

MySQL Import MySQL dumpfile into database

mysql

0 1711 posted 16 years ago by danshields

MySQL Dump database mysql commandline

Remove <>

mysql

0 2779 posted 16 years ago by jodm

MySQL Purge MySQL Binary Logs

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

mysql

2 1649 posted 16 years ago by mushookies

MySQL MySQL Canada Provinces Territories

mysql

0 1855 posted 16 years ago by CuDDL

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

mysql

0 1691 posted 16 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...