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 10705 posted 4 years ago by cerxx
Show the output of a query in a more readable vertical format
0 898 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 808 posted 8 years ago by bvwatson
How to find a given column in a given database in MySQL
1 698 posted 11 years ago by philsown
Create a new database and its respective user with all privileges
0 530 posted 11 years ago by claudiodev
3 2250 posted 12 years ago by frederichoule
0 365 posted 12 years ago by Ez3k
drop_tables_like(pattern, db)
0 516 posted 12 years ago by abstraktor
the following code can be used to create a table with a dynamic name
0 595 posted 13 years ago by gtaking
This SQL query will find all the SlideDeck related entries in your WordPress database.
0 541 posted 13 years ago by Jamie
0 551 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 572 posted 13 years ago by errkk
0 618 posted 13 years ago by Jamie
0 624 posted 14 years ago by bradless
1 450 posted 14 years ago by magicrebirth
0 672 posted 14 years ago by kingkool68
Show table size, number of rows, and size of indexes in MySQL.
1 918 posted 15 years ago by zingo
1 472 posted 15 years ago by ping_ch
0 660 posted 15 years ago by sebus
« Prev 1 Next »