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 756 posted 15 years ago by zonetrooperex

PHP Function to convert dates to and from Mysql

mysql

1 1188 posted 15 years ago by fackz

Bash Start and stop MySQL server on OS X

mysql

0 971 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 1137 posted 15 years ago by manuelstofer

MySQL Manejo de fechas MYSQL

Manejo de fechas y formateado MYSQL

mysql

0 797 posted 15 years ago by xaviles

MySQL Manejo de Cursores en SP en MYSQL

Esquema basico de manejo de cursores en MYSQL

mysql

0 951 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 1151 posted 15 years ago by xaviles

MySQL push flyspray tasks 30 days in the future

mysql

0 775 posted 15 years ago by yisreldov

PHP LoneDatabaseClass

mysql

0 791 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 1141 posted 15 years ago by Jamie

PHP Super Database Access/Service

mysql

0 916 posted 15 years ago by jonniespratley

MySQL MySQl table engine

General MySQL engine related commands

mysql

0 830 posted 15 years ago by sukantahazra

Java JDBC MySQL quick start

mysql

0 764 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 799 posted 15 years ago by atma

PHP PDO multiple inserts

mysql

1 808 posted 15 years ago by atma

Rails Rails has_many through without join tables - Proposal

mysql

0 1099 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 1084 posted 15 years ago by bradless

MySQL Show mysql database encoding

mysql

1 908 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 1251 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 905 posted 15 years ago by bradless

PHP Connecting to a MySQL DB

mysql

0 876 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 1171 posted 15 years ago by johnandrewsroot

MySQL Magento update base url after transfer

mysql

0 933 posted 15 years ago by danshields

MySQL Magento update base url after transfer

mysql

0 872 posted 15 years ago by danshields

PHP MySQLi convert a result set to an HTML table

mysql

2 1135 posted 15 years ago by ginoplusio

PHP MySQLi convert a result set to CSV or to JSON

mysql

2 1183 posted 15 years ago by ginoplusio

PHP MySQLi repair and optimize tables

mysql

1 1325 posted 15 years ago by ginoplusio

PHP MySQLi connection

mysql

1 962 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 1108 posted 15 years ago by Heroftime