Welcome To Snipplr


Everyone's Recent MySQL Snippets Tagged database



« Prev 1 Next »
Show the output of a query in a more readable vertical format
0 1869 posted 9 years ago by rm1984
Sets up the database for my project management software (in development - C#)
0 3674 posted 11 years ago by JordanRowles
This is a very simple snippet about how to create a database 1st, a user and then assign some privileges to the user to allow him/her to perform some specific actions like insert, create, update, select etc.
0 1659 posted 11 years ago by apphp-snippets
How to find a given column in a given database in MySQL
1 2461 posted 13 years ago by philsown
You could start a transaction before running your queries and then rollback after running them. Note that to do this you'll require InnoDB or XtraDb tables (won't work on MyISAM).
0 2511 posted 13 years ago by satie83
0 1179 posted 15 years ago by hamsterbacke82
If you\'ve got a Wordpress install that\'s changed domain or you\'re making a local or development copy, you\'ll need to update the Wordpress DB tables with the new URL.\r\nThe first step is the options table, with siteurl and homeurl. The posts als...
1 1369 posted 15 years ago by timkinnane
granting DB specific and general access priveleges from the CLI
1 1381 posted 16 years ago by stiobhart
CLI commands for backing up mySQL database
2 2612 posted 16 years ago by stiobhart
« Prev 1 Next »