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

PHP Function to convert dates to and from Mysql

mysql

1 1394 posted 15 years ago by fackz

Bash Start and stop MySQL server on OS X

mysql

0 1190 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 1345 posted 15 years ago by manuelstofer

MySQL Manejo de fechas MYSQL

Manejo de fechas y formateado MYSQL

mysql

0 969 posted 15 years ago by xaviles

MySQL Manejo de Cursores en SP en MYSQL

Esquema basico de manejo de cursores en MYSQL

mysql

0 1124 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 1363 posted 15 years ago by xaviles

MySQL push flyspray tasks 30 days in the future

mysql

0 942 posted 15 years ago by yisreldov

PHP LoneDatabaseClass

mysql

0 938 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 1380 posted 15 years ago by Jamie

PHP Super Database Access/Service

mysql

0 1080 posted 15 years ago by jonniespratley

MySQL MySQl table engine

General MySQL engine related commands

mysql

0 1001 posted 15 years ago by sukantahazra

Java JDBC MySQL quick start

mysql

0 953 posted 15 years ago by sukantahazra

MySQL Find values that occur exactly once in table

mysql

1 853 posted 15 years ago by atma

MySQL Fing multiple values in MySQL

mysql

0 960 posted 15 years ago by atma

PHP PDO multiple inserts

mysql

1 969 posted 15 years ago by atma

Rails Rails has_many through without join tables - Proposal

mysql

0 1341 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 1324 posted 15 years ago by bradless

MySQL Show mysql database encoding

mysql

1 1109 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 1466 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 1119 posted 15 years ago by bradless

PHP Connecting to a MySQL DB

mysql

0 1036 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 1437 posted 15 years ago by johnandrewsroot

MySQL Magento update base url after transfer

mysql

0 1100 posted 15 years ago by danshields

MySQL Magento update base url after transfer

mysql

0 1041 posted 15 years ago by danshields

PHP MySQLi convert a result set to an HTML table

mysql

2 1390 posted 15 years ago by ginoplusio

PHP MySQLi convert a result set to CSV or to JSON

mysql

2 1425 posted 15 years ago by ginoplusio

PHP MySQLi repair and optimize tables

mysql

1 1557 posted 15 years ago by ginoplusio

PHP MySQLi connection

mysql

1 1142 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 1337 posted 15 years ago by Heroftime