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 17833 posted 5 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 1606 posted 9 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 3077 posted 10 years ago by bvwatson

MySQL What MySQL Table Has What Column

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

1 2007 posted 12 years ago by philsown

MySQL create new database

Create a new database and its respective user with all privileges

0 1040 posted 12 years ago by claudiodev

MySQL US & CANADA Cities Database

3 3864 posted 13 years ago by frederichoule

MySQL Selecting domain from email

0 749 posted 14 years ago by Ez3k

MySQL Updated mysql database from SQL dump

0 1242 posted 14 years ago by greeneggs614

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

drop_tables_like(pattern, db)

0 1080 posted 14 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 1173 posted 14 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 991 posted 14 years ago by Jamie

MySQL Create utf8 database cli

0 1002 posted 14 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 1142 posted 14 years ago by errkk

MySQL Move Column in MySQL Table

0 1122 posted 15 years ago by Jamie

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

0 1203 posted 15 years ago by alexandrepayet

MySQL Specify 'Order By' order

0 1164 posted 15 years ago by bradless

MySQL Starting and stopping MySQL

1 900 posted 15 years ago by magicrebirth

MySQL Reset Auto Increment for a Table

0 1206 posted 15 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 1589 posted 16 years ago by zingo

MySQL MySQL Capitalize

1 978 posted 16 years ago by ping_ch

0 1176 posted 16 years ago by sebus