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 650 posted 14 years ago by zonetrooperex

PHP Function to convert dates to and from Mysql

mysql

1 1064 posted 14 years ago by fackz

Bash Start and stop MySQL server on OS X

mysql

0 867 posted 14 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 1001 posted 14 years ago by manuelstofer

MySQL Manejo de fechas MYSQL

Manejo de fechas y formateado MYSQL

mysql

0 684 posted 14 years ago by xaviles

MySQL Manejo de Cursores en SP en MYSQL

Esquema basico de manejo de cursores en MYSQL

mysql

0 851 posted 14 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 1023 posted 14 years ago by xaviles

MySQL push flyspray tasks 30 days in the future

mysql

0 654 posted 14 years ago by yisreldov

PHP LoneDatabaseClass

mysql

0 692 posted 14 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 1035 posted 14 years ago by Jamie

PHP Super Database Access/Service

mysql

0 794 posted 14 years ago by jonniespratley

MySQL MySQl table engine

General MySQL engine related commands

mysql

0 711 posted 14 years ago by sukantahazra

Java JDBC MySQL quick start

mysql

0 662 posted 14 years ago by sukantahazra

MySQL Find values that occur exactly once in table

mysql

1 616 posted 14 years ago by atma

MySQL Fing multiple values in MySQL

mysql

0 684 posted 14 years ago by atma

PHP PDO multiple inserts

mysql

1 676 posted 14 years ago by atma

Rails Rails has_many through without join tables - Proposal

mysql

0 964 posted 14 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 972 posted 14 years ago by bradless

MySQL Show mysql database encoding

mysql

1 790 posted 14 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 1125 posted 14 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 793 posted 14 years ago by bradless

PHP Connecting to a MySQL DB

mysql

0 761 posted 14 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 1047 posted 14 years ago by johnandrewsroot

MySQL Magento update base url after transfer

mysql

0 806 posted 14 years ago by danshields

MySQL Magento update base url after transfer

mysql

0 741 posted 14 years ago by danshields

PHP MySQLi convert a result set to an HTML table

mysql

2 990 posted 14 years ago by ginoplusio

PHP MySQLi convert a result set to CSV or to JSON

mysql

2 1029 posted 14 years ago by ginoplusio

PHP MySQLi repair and optimize tables

mysql

1 1204 posted 14 years ago by ginoplusio

PHP MySQLi connection

mysql

1 850 posted 14 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 973 posted 14 years ago by Heroftime