Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

mysql sql drupal wordpress database mac osx convert textmate date command backup ip url replace find user list line table log update query data regex csv php terminal order email path search security unix mail magento Bash linux cache code copy regexp filter forms text joomla cakephp server customer class windows format web iphone ajax api xml android actionscript window animation magentoextension apache Business service

Welcome To Snipplr

Everyone's Recent MySQL Snippets Tagged sql

« Prev 1 Next »

MySQL A request to clear a single column in a table / MySQL /

A request to clear a single column in a table / MySQL /

0 39754 posted 6 years ago by cerxx

MySQL Show the output of a query in a more readable vertical format

Show the output of a query in a more readable vertical format

0 2484 posted 10 years ago by rm1984

MySQL Find last two updates to a record

Created as reply to question on ittoolbox.com:"Need your help in writing a query to pull audit history i.e. Last updated by a user 'XYZ' and for the same record key (ID) the second last record in the audit history table. i.e. Last update by this user...

0 4083 posted 11 years ago by bvwatson

MySQL What MySQL Table Has What Column

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

1 2989 posted 13 years ago by philsown

MySQL create new database

Create a new database and its respective user with all privileges

0 1677 posted 13 years ago by claudiodev

MySQL US & CANADA Cities Database

3 5224 posted 14 years ago by frederichoule

MySQL Selecting domain from email

0 1264 posted 15 years ago by Ez3k

MySQL Updated mysql database from SQL dump

0 2074 posted 15 years ago by greeneggs614

MySQL alle Tabellen eines bestimmten Musters aus einer Datenbank lÃ¶schen

drop_tables_like(pattern, db)

0 1770 posted 15 years ago by abstraktor

MySQL Create a table with a dynamic name

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

0 1914 posted 15 years ago by gtaking

MySQL Find All SlideDeck Slides from the wp_posts Table

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

0 1630 posted 15 years ago by Jamie

MySQL Create utf8 database cli

0 1672 posted 15 years ago by hamsterbacke82

MySQL Move WordPress to another host

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.

1 1930 posted 15 years ago by errkk

MySQL Move Column in MySQL Table

0 1873 posted 16 years ago by Jamie

MySQL MYSQL : Calcul sur des dates avec des fonctions dans mysql

0 1984 posted 16 years ago by alexandrepayet

MySQL Specify 'Order By' order

0 1899 posted 16 years ago by bradless

MySQL Starting and stopping MySQL

1 1484 posted 16 years ago by magicrebirth

MySQL Reset Auto Increment for a Table

0 1877 posted 16 years ago by kingkool68

MySQL MySQL table size, number of rows, and size of indexes

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

1 2477 posted 17 years ago by zingo

MySQL MySQL Capitalize

1 1625 posted 17 years ago by ping_ch

0 1912 posted 17 years ago by sebus