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 13954 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 1445 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 1254 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 1143 posted 12 years ago by philsown

MySQL create new database

Create a new database and its respective user with all privileges

0 930 posted 12 years ago by claudiodev

MySQL US & CANADA Cities Database

3 2938 posted 13 years ago by frederichoule

MySQL Selecting domain from email

0 687 posted 14 years ago by Ez3k

MySQL Updated mysql database from SQL dump

0 1095 posted 14 years ago by greeneggs614

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

drop_tables_like(pattern, db)

0 936 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 1026 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 886 posted 14 years ago by Jamie

MySQL Create utf8 database cli

0 912 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 973 posted 14 years ago by errkk

MySQL Move Column in MySQL Table

0 1009 posted 14 years ago by Jamie

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

0 1095 posted 15 years ago by alexandrepayet

MySQL Specify 'Order By' order

0 1052 posted 15 years ago by bradless

MySQL Starting and stopping MySQL

1 807 posted 15 years ago by magicrebirth

MySQL Reset Auto Increment for a Table

0 1066 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 1407 posted 16 years ago by zingo

MySQL MySQL Capitalize

1 834 posted 16 years ago by ping_ch

0 1075 posted 16 years ago by sebus