Welcome To Snipplr


Everyone's Recent MySQL Snippets Tagged sql



« Prev 1 Next »
A request to clear a single column in a table / MySQL /
0 10741 posted 4 years ago by cerxx
Show the output of a query in a more readable vertical format
0 900 posted 7 years ago by rm1984
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 811 posted 8 years ago by bvwatson
How to find a given column in a given database in MySQL
1 702 posted 11 years ago by philsown
Create a new database and its respective user with all privileges
0 534 posted 11 years ago by claudiodev
3 2258 posted 12 years ago by frederichoule
0 367 posted 12 years ago by Ez3k
drop_tables_like(pattern, db)
0 520 posted 12 years ago by abstraktor
the following code can be used to create a table with a dynamic name
0 598 posted 13 years ago by gtaking
This SQL query will find all the SlideDeck related entries in your WordPress database.
0 542 posted 13 years ago by Jamie
0 559 posted 13 years ago by hamsterbacke82
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 578 posted 13 years ago by errkk
0 623 posted 13 years ago by Jamie
0 628 posted 14 years ago by bradless
1 454 posted 14 years ago by magicrebirth
0 674 posted 14 years ago by kingkool68
Show table size, number of rows, and size of indexes in MySQL.
1 925 posted 15 years ago by zingo
1 477 posted 15 years ago by ping_ch
0 664 posted 15 years ago by sebus
« Prev 1 Next »