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 18248 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 1672 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 3343 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 2321 posted 12 years ago by philsown

MySQL create new database

Create a new database and its respective user with all privileges

0 1081 posted 12 years ago by claudiodev

MySQL US & CANADA Cities Database

3 4219 posted 13 years ago by frederichoule

MySQL Selecting domain from email

0 783 posted 14 years ago by Ez3k

MySQL Updated mysql database from SQL dump

0 1336 posted 14 years ago by greeneggs614

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

drop_tables_like(pattern, db)

0 1154 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 1251 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 1051 posted 14 years ago by Jamie

MySQL Create utf8 database cli

0 1048 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 1263 posted 15 years ago by errkk

MySQL Move Column in MySQL Table

0 1191 posted 15 years ago by Jamie

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

0 1264 posted 15 years ago by alexandrepayet

MySQL Specify 'Order By' order

0 1221 posted 15 years ago by bradless

MySQL Starting and stopping MySQL

1 950 posted 15 years ago by magicrebirth

MySQL Reset Auto Increment for a Table

0 1284 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 1677 posted 16 years ago by zingo

MySQL MySQL Capitalize

1 1017 posted 16 years ago by ping_ch

0 1227 posted 16 years ago by sebus