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

MySQL Greek utf-8 & mysql

mysql

1 1806 posted 16 years ago by jmacgr

MySQL MANEJO CURSOR MYSQL

Esquema basico manejo cursores en MYSQL

mysql

0 1593 posted 16 years ago by xaviles

MySQL Create UTF8 DB Command line

mysql

0 1599 posted 16 years ago by level09

MySQL select first character of second word (surname)

mysql

0 1773 posted 16 years ago by ReeceMarsland

MySQL How to Save results from MySQL into an external file

mysql

1 2512 posted 16 years ago by endorfin

MySQL MySQL Age Calucation

Some code I found for calculating and determining a persons age

mysql

1 1582 posted 16 years ago by mpcircuitry

MySQL Date formatting with LOAD DATA INFILE

Came across this nice snippet @ mysql.com

mysql

2 4687 posted 16 years ago by j4kp07

MySQL Drupal 6.x Find PHP code in database

mysql

2 2055 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 1899 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 1731 posted 16 years ago by beneberle

MySQL MySQL: Dump remote database

mysql

1 1927 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 1742 posted 16 years ago by ginoplusio

MySQL MySQL REGEX match comma-delimitted list

mysql

1 2429 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 2017 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 1818 posted 16 years ago by cherbert

MySQL Import MySQL dumpfile into database

mysql

0 1988 posted 17 years ago by danshields

MySQL Dump database mysql commandline

Remove <>

mysql

0 3095 posted 17 years ago by jodm

MySQL Purge MySQL Binary Logs

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

mysql

2 1930 posted 17 years ago by mushookies

MySQL MySQL Canada Provinces Territories

mysql

0 2071 posted 17 years ago by CuDDL

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

mysql

0 1977 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...