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 ... 12 13 14 15 16 ... 19 Next »

PHP REST MySQL Service

mysql

0 1348 posted 16 years ago by jonniespratley

PHP Full REST JSON MySQL Management Class

I am currently still working on this, and will make changes.

mysql

1 1601 posted 16 years ago by jonniespratley

PHP list->mysql query iteration for cron job

I needed to have a cron job that did some MySQL work iterating through a long list of items based on the content of a table in MySQL. I wanted each item in the table to be iterated over roughly once every 5 minutes, but building up the in-memory lis...

mysql

0 1276 posted 16 years ago by cori

MySQL How to follow the progress of a running MySQL command

mysql

1 1563 posted 16 years ago by paulbooker

Python Simple csv dump script

mysql

1 1599 posted 16 years ago by vasilije

Rails Ruby on Rails - MAMP - MySQL socket

mysql

0 1328 posted 16 years ago by oli

PHP alter table (float)

mysql

0 1354 posted 17 years ago by stavelin

MySQL Fix screwy URL aliases for project_issue nodes

I currently have project_issue nodes set for replacement pattern issues/issue[nid] in Drupal 5.x PathAuto. This query fixes all of the URL aliases for entries created before this was set correctly.

mysql

0 1428 posted 17 years ago by tgbdad

SQL Select random row from a SQL database.

This is by no means the most efficient way to do this, in terms of performance. It is however the easiest way.

mysql

1 1515 posted 17 years ago by xtheonex

XML tomcat mysql jndi connection pool

mysql

0 1381 posted 17 years ago by vasilije

MySQL MySQL Capitalize

mysql

1 1196 posted 17 years ago by ping_ch

Other Database Connection Class

mysql

0 1461 posted 17 years ago by jonniespratley

Other calls to mysql in UTF-8

mysql

0 1281 posted 17 years ago by moonbather

PHP Export MySQL Data as CSV

# Export MySQL Data as CSV This code takes a `mysql_query()` resource and outputs its rows into CSV spreadsheet format. Edit the `header('Content-Disposition...` declaration to tell the user's browser to either display the data as plain text or do...

mysql

6 2115 posted 17 years ago by mikegreen

Bash MySQL Server Status

mysql

1 1075 posted 17 years ago by endorfin

Bash What MySQL Version

mysql

0 1099 posted 17 years ago by endorfin

Bash convert mysql engine to innodb

mysql

0 1308 posted 17 years ago by rowntreerob

Bash SSH tunnel to local port

To connect to your database remotely, tunnel in via SSH. This creates an encrypted tunnel to your Sliceâ€™s mySQL port (3306) on your local port of 8888. Point your local admin/GUI app to localhost:8888. If this does not work, and you are running...

mysql

3 1626 posted 17 years ago by zachwood

PHP Optimixe MySQL database with php

mysql

1 1471 posted 17 years ago by iTony

SQL Duplicate or clone one or more rows in MySQL

mysql

1 4036 posted 17 years ago by gfazioli

PHP Single MySQL Result

Simple but useful function for getting a single piece of data from a database and placing it straight into a variable. Example: $variable = one_result("SELECT columnOne FROM table WHERE columnTwo=whatever"); This would insert the value of colu...