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 1621 posted 16 years ago by zonetrooperex

PHP Function to convert dates to and from Mysql

mysql

1 2354 posted 16 years ago by fackz

Bash Start and stop MySQL server on OS X

mysql

0 1977 posted 16 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 2269 posted 16 years ago by manuelstofer

MySQL Manejo de fechas MYSQL

Manejo de fechas y formateado MYSQL

mysql

0 1729 posted 16 years ago by xaviles

MySQL Manejo de Cursores en SP en MYSQL

Esquema basico de manejo de cursores en MYSQL

mysql

0 1898 posted 16 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 2174 posted 16 years ago by xaviles

MySQL push flyspray tasks 30 days in the future

mysql

0 1564 posted 16 years ago by yisreldov

PHP LoneDatabaseClass

mysql

0 1626 posted 16 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 2544 posted 16 years ago by Jamie

PHP Super Database Access/Service

mysql

0 1782 posted 16 years ago by jonniespratley

MySQL MySQl table engine

General MySQL engine related commands

mysql

0 1708 posted 16 years ago by sukantahazra

Java JDBC MySQL quick start

mysql

0 1639 posted 16 years ago by sukantahazra

MySQL Find values that occur exactly once in table

mysql

1 1569 posted 16 years ago by atma

MySQL Fing multiple values in MySQL

mysql

0 1712 posted 16 years ago by atma

PHP PDO multiple inserts

mysql

1 1643 posted 16 years ago by atma

Rails Rails has_many through without join tables - Proposal

mysql

0 2202 posted 16 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 2216 posted 16 years ago by bradless

MySQL Show mysql database encoding

mysql

1 1822 posted 16 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 2549 posted 16 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 2011 posted 16 years ago by bradless

PHP Connecting to a MySQL DB

mysql

0 1837 posted 16 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 2462 posted 16 years ago by johnandrewsroot

MySQL Magento update base url after transfer

mysql

0 1863 posted 16 years ago by danshields

MySQL Magento update base url after transfer

mysql

0 1754 posted 16 years ago by danshields

PHP MySQLi convert a result set to an HTML table

mysql

2 2599 posted 16 years ago by ginoplusio

PHP MySQLi convert a result set to CSV or to JSON

mysql

2 2585 posted 16 years ago by ginoplusio

PHP MySQLi repair and optimize tables

mysql

1 2521 posted 16 years ago by ginoplusio

PHP MySQLi connection

mysql

1 1880 posted 16 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 2195 posted 16 years ago by Heroftime