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 623 posted 8 months ago by cerxx
Show the output of a query in a more readable vertical format
0 121 posted 4 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 115 posted 5 years ago by bvwatson
How to find a given column in a given database in MySQL
1 91 posted 7 years ago by philsown
Create a new database and its respective user with all privileges
0 55 posted 7 years ago by claudiodev
3 332 posted 8 years ago by frederichoule
0 43 posted 9 years ago by Ez3k
drop_tables_like(pattern, db)
0 70 posted 9 years ago by abstraktor
the following code can be used to create a table with a dynamic name
0 83 posted 9 years ago by gtaking
This SQL query will find all the SlideDeck related entries in your WordPress database.
0 62 posted 9 years ago by Jamie
0 59 posted 9 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 67 posted 9 years ago by errkk
0 94 posted 9 years ago by Jamie
0 82 posted 10 years ago by bradless
1 57 posted 10 years ago by magicrebirth
Show table size, number of rows, and size of indexes in MySQL.
1 149 posted 11 years ago by zingo
1 66 posted 11 years ago by ping_ch
0 110 posted 11 years ago by sebus
« Prev 1 Next »