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 ... 6 7 8 9 10 ... 19 Next »

PHP PHP Mysql db logon

mysql

1 741 posted 14 years ago by sjacunningham

SQL Remove trailing newlines from database fields

sometimes we botch an import, and end up with return or newline characters in the field. So fields which should be empty have \r in them, or fields with text data have an invisible trailing newline. This makes it impossible to match the text values....

mysql

0 755 posted 14 years ago by powerthru

MySQL Add Wordpress admin user to database

When working on client sites, you often need admin access, instead of requiring them to set up an admin user, just make your own. ref: http://www.dnawebagency.com/how-to-add-an-admin-user-to-the-wordpress-database

mysql

2 1053 posted 14 years ago by timkinnane

MySQL Update Wordpress DB to new domain

If you\'ve got a Wordpress install that\'s changed domain or you\'re making a local or development copy, you\'ll need to update the Wordpress DB tables with the new URL.\r\nThe first step is the options table, with siteurl and homeurl. The posts als...

mysql

1 792 posted 14 years ago by timkinnane

MySQL MySQL - Group by price range

Group by user defined price bands.

mysql

1 2254 posted 14 years ago by daipratt

SQL Select Duplicates

mysql

1 682 posted 14 years ago by traeregan

SQL Select Records Beginning With Certain Letter

mysql

1 715 posted 14 years ago by traeregan

MySQL Reset MySQL Auto Increment number

for auto increment ids, when you delete records this will reset the number for the next auto id.

mysql

0 770 posted 14 years ago by matula

PHP Query the database PHP

To use: $update_sql = querys($sql); or $select_sql = getresult($sql); Used simplify selecting rows from a database. You'll need to pass in the SQL statement.

mysql

0 782 posted 14 years ago by shawntysco

PHP PHP, Build a basic dynamic DELETE string

Used to delete rows from the database. \r\nTo use:\r\n$del = delete(\"quick_links\", $_GET[\'id\']) ;

mysql

0 671 posted 14 years ago by shawntysco

PHP PHP, Build a basic dynamic INSERT string

Makes basic insert statements a breeze to type while doing basic PHP inserts.\r\n*The function for \\\'querys\\\' on line 44 can be found here: http://snipplr.com/view/40911/query-the-database-php/ *

mysql

0 673 posted 14 years ago by shawntysco

MySQL Load CSV back into mySQL

mysql

3 953 posted 14 years ago by matula

MySQL Create CSV from MySQL

mysql

5 876 posted 14 years ago by matula

PHP php-log - Process log files with PHP

Iâ€™ve recently had to quickly parse an Apache log file, to get basic usage statistics for a site over a month and wanted the ability to quickly process any general logs and store them in a MySQL table, so Iâ€™ve made a small package class.log. In...

mysql

2 1252 posted 14 years ago by dom111

PHP full php mysql connection script

mysql

0 797 posted 14 years ago by paschim

MySQL Number of records in one table of a type from another table.

You have two tables galleries and images, and you need to know how many images each gallery has associated with it. This Query returns the sum of distinct record joined to another table by a common field (gallery_id).

mysql

0 975 posted 14 years ago by jbranca

MySQL Display MYSQL date as readable to us humans

mysql

1 848 posted 14 years ago by flashmac

MySQL MySql Load Data

mysql

0 648 posted 14 years ago by kaartz

Bash Backup all MySQL databases

Script to backup all MySQL databases and delete copies after X days

mysql

1 708 posted 14 years ago by eusonlito

Bash Create symlink for mysql in MAMP

mysql

0 793 posted 14 years ago by bdani

PHP serialize and unserialize functions for MYSQL Storage

In a Project i had to save serialized arrays in a MYSQL Database, when i used that i got a Error Message for no reason (Error at offset XX of XX bytes in...). I wrote this little functions to fix that issue. (I dont recommend to save serialized Arra...

mysql

0 974 posted 14 years ago by FreaKzero

Bash Export MySQL to file

Dumps the contents of a mysql database to a .sql file named by the current date.

mysql

0 753 posted 14 years ago by gdvickery

Bash mysql ssh tunnel (then kill PID)

mysql

0 704 posted 14 years ago by moonbather

SQL Remove duplicate entries / rows from mySQL

This is the quick method and painless way to Remove duplicate entries from MySQL

mysql

2 827 posted 14 years ago by lixonic

Bash mysql-empty-tables

mysql

0 551 posted 14 years ago by barbelith

PHP PHP Smart Config File

Here's a little trick I started using when working with XAMPP for localhost and keeping things in tune with the live configuration variables such as username and passwords to mysql (or whatever you're writing for). The example below figures your w...