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 846 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 863 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 1181 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 900 posted 14 years ago by timkinnane

MySQL MySQL - Group by price range

Group by user defined price bands.

mysql

1 2383 posted 14 years ago by daipratt

SQL Select Duplicates

mysql

1 762 posted 14 years ago by traeregan

SQL Select Records Beginning With Certain Letter

mysql

1 811 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 882 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 913 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 765 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 772 posted 14 years ago by shawntysco

MySQL Load CSV back into mySQL

mysql

3 1068 posted 14 years ago by matula

MySQL Create CSV from MySQL

mysql

5 982 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 1422 posted 14 years ago by dom111

PHP full php mysql connection script

mysql

0 925 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 1099 posted 14 years ago by jbranca

MySQL Display MYSQL date as readable to us humans

mysql

1 953 posted 14 years ago by flashmac

MySQL MySql Load Data

mysql

0 739 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 806 posted 14 years ago by eusonlito

Bash Create symlink for mysql in MAMP

mysql

0 896 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 1095 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 864 posted 14 years ago by gdvickery

Bash mysql ssh tunnel (then kill PID)

mysql

0 797 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 927 posted 14 years ago by lixonic

Bash mysql-empty-tables

mysql

0 650 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...