Login / Register

Share Snipplr

Follow @Snipplr

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 10849 posted 4 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 915 posted 7 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 824 posted 8 years ago by bvwatson

MySQL What MySQL Table Has What Column

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

1 715 posted 11 years ago by philsown

MySQL create new database

Create a new database and its respective user with all privileges

0 544 posted 11 years ago by claudiodev

MySQL US & CANADA Cities Database

3 2283 posted 12 years ago by frederichoule

MySQL Selecting domain from email

0 375 posted 12 years ago by Ez3k

MySQL Updated mysql database from SQL dump

0 686 posted 12 years ago by greeneggs614

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

drop_tables_like(pattern, db)

0 528 posted 13 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 610 posted 13 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 551 posted 13 years ago by Jamie

MySQL Create utf8 database cli

0 571 posted 13 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 589 posted 13 years ago by errkk

MySQL Move Column in MySQL Table

0 633 posted 13 years ago by Jamie

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

0 671 posted 14 years ago by alexandrepayet

MySQL Specify 'Order By' order

0 644 posted 14 years ago by bradless

MySQL Starting and stopping MySQL

1 464 posted 14 years ago by magicrebirth

MySQL Reset Auto Increment for a Table

0 679 posted 14 years ago by kingkool68

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