Login / Register

Share Snipplr

Follow @Snipplr

Welcome To Snipplr

Everyone's Recent Snippets Tagged mysql

« Prev 1 ... 15 16 17 18 19 Next »

PHP mySQL MIME Table (PHP)

PHP function that creates a mySQL INSERT statement for mime types. Type are extracted from a text file.

mysql

0 487 posted 15 years ago by fabian

SQL See all mysql grants

It does not show the grants themselves, but shows all users with grants.

mysql

0 484 posted 15 years ago by therobot

Bash Remove all tables with a certain pattern from the database

This script removes (DROPS) all tables that start with foo_. Usefull if you had some CMS or application that (ab)uses table prefixing, and want to clean 0ut your database. NOTE: the data is remove FOREVER! So take good casre: make backups and all...

mysql

2 664 posted 15 years ago by berkes

JavaScript Formatting dates in JavaScript (handles MySQL dates)

mysql

1 561 posted 15 years ago by penguin999

SQL Differences between two Tables

mysql

1 608 posted 15 years ago by zingo

PHP Remove Duplicate Rows

$duplicates checks and groups duplicated rows with the same field1 and field2 (like comments maybe) and $limit counts how many times a row is duplicated.

mysql

3 612 posted 15 years ago by Abe

PHP While Loop from MySQL Query

mysql

1 536 posted 15 years ago by AgentPhoenix

PHP Simple Data Access Class

This is a simple class to encapsulate CURD functions. This class also includes some simple search methods.

mysql

1 579 posted 15 years ago by ecavazos

PHP Usefull functions to work with MySQL under PHP5

mysql

3 694 posted 15 years ago by LoRd1990

Java Sample persistence.xml that uses hibernate & mysql

mysql

0 1289 posted 15 years ago by cfrias

Rails `No such file or directory â€“ /tmp/mysql.sock`

mysql

1 458 posted 15 years ago by cczona

R mysql rename table

mysql

1 552 posted 15 years ago by jpdamen

R php while statement associative array from mysql

mysql

1 652 posted 15 years ago by jpdamen

R typo3 open database connection

mysql

0 513 posted 15 years ago by jpdamen

R mysql insert query

mysql

1 575 posted 15 years ago by jpdamen

R mysql select query

mysql

1 522 posted 15 years ago by jpdamen

R mysql update query

mysql

1 530 posted 15 years ago by jpdamen

PHP Enum to Array / SQL to PHP

adapted from http://www.gotocode.com/art.asp?art_id=275&

mysql

0 656 posted 15 years ago by clapfouine

Ruby A monkey-patch to activerecord to reconnect after it loses the connection to the mysql server

mysql

1 635 posted 15 years ago by esad

PHP clean user input data ( GET, POST, COOKIE )

Created for my own purposes, thought I'd share though ;) copy paste at the top of your file and it does the magic :)

mysql

31 3655 posted 15 years ago by peteypablonz

SQL MySQL LOAD DATA INFILE with WHERE

mysql

1 474 posted 15 years ago by bassnode

PHP PHP MySQL Starting Point

mysql

5 455 posted 15 years ago by jrphelps

SQL Ordering multiple SELECT statements in a UNION

mysql

0 560 posted 15 years ago by andyhartleeds

PHP Using PHP and MyActiveRecord ( from www.wattz.net)

MyActiveRecord is a stand alone db abstraction layer to simplify things between php and mysql. you can download the latest version from www.wattz.net

mysql

0 612 posted 15 years ago by wattz

PHP PHP memory limit

Just a reminder to myself, not really a snippet. When running into memory/speed issues with PHP/MySQL apps, adjust the memory_limit parameter in php.ini.