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 18720 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 1821 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 3439 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 2436 posted 13 years ago by philsown

MySQL create new database

Create a new database and its respective user with all privileges

0 1192 posted 13 years ago by claudiodev

MySQL US & CANADA Cities Database

3 4384 posted 14 years ago by frederichoule

MySQL Selecting domain from email

0 832 posted 14 years ago by Ez3k

MySQL Updated mysql database from SQL dump

0 1460 posted 14 years ago by greeneggs614

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

drop_tables_like(pattern, db)

0 1283 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 1359 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 1147 posted 14 years ago by Jamie

MySQL Create utf8 database cli

0 1149 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 1362 posted 15 years ago by errkk

MySQL Move Column in MySQL Table

0 1314 posted 15 years ago by Jamie

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

0 1386 posted 15 years ago by alexandrepayet

MySQL Specify 'Order By' order

0 1324 posted 15 years ago by bradless

MySQL Starting and stopping MySQL

1 1020 posted 15 years ago by magicrebirth

MySQL Reset Auto Increment for a Table

0 1375 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 1804 posted 16 years ago by zingo

MySQL MySQL Capitalize

1 1107 posted 16 years ago by ping_ch

0 1354 posted 17 years ago by sebus