Snipplr

(MySQL) What MySQL Table Has What Column - philsown

Fri, 16 Nov 2012 00:50:08 GMT

How to find a given column in a given database in MySQL

(MySQL) create new database - claudiodev

Mon, 22 Oct 2012 21:45:32 GMT

Create a new database and its respective user with all privileges

(MySQL) US & CANADA Cities Database - frederichoule

Sat, 22 Oct 2011 12:36:31 GMT

(MySQL) Selecting domain from email - Ez3k

Wed, 15 Jun 2011 01:04:00 GMT

(MySQL) Updated mysql database from SQL dump - greeneggs614

Thu, 28 Apr 2011 06:35:03 GMT

(MySQL) alle Tabellen eines bestimmten Musters aus einer Datenbank löschen - abstraktor

Sun, 17 Apr 2011 06:41:26 GMT

drop_tables_like(pattern, db)

(MySQL) Very simple search retrieval query, ranking with tf-idf weight - jatkins

Mon, 04 Apr 2011 20:33:17 GMT

This assumes two tables: `search_results` and `keyword_counts`. `search_results` is an inverted index with, at minimum, fields for the keyword indexed, its occurrences, and the indexed item's id in the table it is in (e.g. `item_id` in `search_results` could be `45`, referencing `id = 45` in `documents`) in the table it's in. `keyword_counts` has a row for each indexed item with the total number of unique words in it and its id in the table the actual item is in. Released into the public domain. This may have bugs in it, but it's worked so far for me.

(MySQL) Create a table with a dynamic name - gtaking

Sat, 01 Jan 2011 01:07:27 GMT

the following code can be used to create a table with a dynamic name

(MySQL) Find All SlideDeck Slides from the wp_posts Table - Jamie

Tue, 14 Dec 2010 12:15:33 GMT

This SQL query will find all the SlideDeck related entries in your WordPress database.

(MySQL) Create utf8 database cli - hamsterbacke82

Sat, 30 Oct 2010 13:39:30 GMT

(MySQL) Move WordPress to another host - errkk

Tue, 12 Oct 2010 20:42:18 GMT

SQL query to update *wp_options* records that are specific to the host of a WordPress site. Run this query after copying the DB to another server (if this URL is different). Useful for deploying WordPress from a dev server to a live environment.

(MySQL) Move Column in MySQL Table - Jamie

Fri, 09 Jul 2010 08:17:57 GMT

(MySQL) MySQL - Most relevant weighted results based (MATCH AGAINST) - LuckyShot

Tue, 27 Apr 2010 10:42:40 GMT

(MySQL) MYSQL : Calcul sur des dates avec des fonctions dans mysql - alexandrepayet

Fri, 09 Apr 2010 08:17:09 GMT

(MySQL) Specify 'Order By' order - bradless

Mon, 25 Jan 2010 15:10:44 GMT

(MySQL) Starting and stopping MySQL - magicrebirth

Tue, 22 Dec 2009 15:07:10 GMT

(MySQL) Reset Auto Increment for a Table - kingkool68

Thu, 19 Nov 2009 15:04:39 GMT

(MySQL) EAN13 Check - occam

Wed, 05 Aug 2009 13:36:24 GMT

This verify's the checksum of a EAN13 barcode.

(MySQL) MySQL table size, number of rows, and size of indexes - zingo

Wed, 04 Mar 2009 22:15:38 GMT

Show table size, number of rows, and size of indexes in MySQL.

(MySQL) MySQL Capitalize - ping_ch

Mon, 26 Jan 2009 09:45:18 GMT