Login / Register

Share Snipplr

Follow @Snipplr

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 605 posted 13 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 608 posted 13 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 900 posted 13 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 615 posted 13 years ago by timkinnane

MySQL MySQL - Group by price range

Group by user defined price bands.

mysql

1 2059 posted 13 years ago by daipratt

SQL Select Duplicates

mysql

1 546 posted 13 years ago by traeregan

SQL Select Records Beginning With Certain Letter

mysql

1 588 posted 13 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 635 posted 13 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 627 posted 13 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 546 posted 13 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 553 posted 13 years ago by shawntysco

MySQL Load CSV back into mySQL

mysql

3 790 posted 13 years ago by matula

MySQL Create CSV from MySQL

mysql

5 736 posted 13 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 1029 posted 13 years ago by dom111

PHP full php mysql connection script

mysql

0 646 posted 13 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 794 posted 13 years ago by jbranca

MySQL Display MYSQL date as readable to us humans

mysql

1 705 posted 13 years ago by flashmac

MySQL MySql Load Data

mysql

0 517 posted 13 years ago by kaartz

Bash Backup all MySQL databases

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

mysql

1 558 posted 13 years ago by eusonlito

Bash Create symlink for mysql in MAMP

mysql

0 637 posted 13 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 797 posted 13 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 571 posted 13 years ago by gdvickery

Bash mysql ssh tunnel (then kill PID)

mysql

0 561 posted 13 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 686 posted 13 years ago by lixonic

Bash mysql-empty-tables

mysql

0 437 posted 13 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...