Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

form regex email curl url http login css mysql database ajax javascript js sql class php header redirect table ie data dropdown sort list object date phone number format svn command resize image file textmate plugin path math actionscript event mail link window debug template Bash java search html post mac error xhtml page google wordpress server rails browser python script replace style array forms backup flash video ruby DOM xml category unix osx download simple c code windows navigation jquery cakephp regexp text function button links filter ie6 linux images htaccess apache free files copy log module query background

Welcome To Snipplr

Everyone's Recent Snippets Tagged mysql

« Prev 1 ... 8 9 10 11 12 ... 19 Next »

MySQL MySQL Administation Snippet

Simply uncomment the appropriate line for some common, useful Administration SQL statements for MySQL. (Uncomment and run 1 line at a time)

mysql

0 757 posted 15 years ago by zonetrooperex

PHP Function to convert dates to and from Mysql

mysql

1 1196 posted 15 years ago by fackz

Bash Start and stop MySQL server on OS X

mysql

0 977 posted 15 years ago by davidrinnan

SQL SQL: Create a user that has only access to one database

creates a user that has only access to one database, from any host

mysql

1 1140 posted 15 years ago by manuelstofer

MySQL Manejo de fechas MYSQL

Manejo de fechas y formateado MYSQL

mysql

0 805 posted 15 years ago by xaviles

MySQL Manejo de Cursores en SP en MYSQL

Esquema basico de manejo de cursores en MYSQL

mysql

0 955 posted 15 years ago by xaviles

MySQL Control de Errores en SP MySQL (Basico)

Esquema de sentencias para el control de errores en SP de MYSQL. Es un metodo basico

mysql

0 1155 posted 15 years ago by xaviles

MySQL push flyspray tasks 30 days in the future

mysql

0 782 posted 15 years ago by yisreldov

PHP LoneDatabaseClass

mysql

0 800 posted 15 years ago by coevolve

MySQL MySQL Find and Replace

This is useful for when a Wordpress environment goes live; typically the uploads have an absolute URL.

mysql

5 1143 posted 15 years ago by Jamie

PHP Super Database Access/Service

mysql

0 918 posted 15 years ago by jonniespratley

MySQL MySQl table engine

General MySQL engine related commands

mysql

0 835 posted 15 years ago by sukantahazra

Java JDBC MySQL quick start

mysql

0 768 posted 15 years ago by sukantahazra

MySQL Find values that occur exactly once in table

mysql

1 717 posted 15 years ago by atma

MySQL Fing multiple values in MySQL

mysql

0 802 posted 15 years ago by atma

PHP PDO multiple inserts

mysql

1 811 posted 15 years ago by atma

Rails Rails has_many through without join tables - Proposal

mysql

0 1103 posted 15 years ago by viatropos

MySQL calculate the difference between dates in one columns within the same table

I use something similar to the example to get the difference between statuses in a status log table that I have. It comes in handy when determining the number of days between status changes. This works in MySQL 5.0.

mysql

0 1090 posted 15 years ago by bradless

MySQL Show mysql database encoding

mysql

1 909 posted 15 years ago by therobot

PHP PHP function to change collation on MySQL db

Function to fix char set and collation on mysql tables, see [this link](http://www.barattalo.it/2010/02/11/php-function-to-fix-collation-on-database-fields-of-mysql/ "Fix encoding on db") for examples and more infos.

mysql

1 1260 posted 15 years ago by ginoplusio

PHP Escaping Multiple Post Values for MySQL with PHP

This is useful for escaping multiple values in a POST array.

mysql

0 914 posted 15 years ago by bradless

PHP Connecting to a MySQL DB

mysql

0 881 posted 15 years ago by chrismendis

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

mysql

1 1176 posted 15 years ago by johnandrewsroot

MySQL Magento update base url after transfer

mysql

0 935 posted 15 years ago by danshields

MySQL Magento update base url after transfer

mysql

0 875 posted 15 years ago by danshields

PHP MySQLi convert a result set to an HTML table

mysql

2 1144 posted 15 years ago by ginoplusio

PHP MySQLi convert a result set to CSV or to JSON

mysql

2 1195 posted 15 years ago by ginoplusio

PHP MySQLi repair and optimize tables

mysql

1 1328 posted 15 years ago by ginoplusio

PHP MySQLi connection

mysql

1 966 posted 15 years ago by ginoplusio

PHP A utility function to preserve an array in a session.

A utility function to preserve an array in a session. Adding the newest element to the beginning of the array and popping out the last one. Useful for displaying for instance; your last searches option in your website.

mysql

1 1111 posted 15 years ago by Heroftime