Welcome To Snipplr


Everyone's Recent Snippets Tagged database



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 1435 posted 15 years ago by timkinnane
Simula in Django i campi created e updated aggiornati automaticamente alla creazione e alla modifica del record (Versione 2 senza funzione save ridefinita)
0 3389 posted 15 years ago by munkypot
1 1873 posted 15 years ago by traeregan
Find column name in all tables of a database
2 2078 posted 15 years ago by hairajeshk
You can use this SP like that; Exec CleanInjection 'INFECTED WORD','CLEAN WORD' (in use : Exec CleanInjection '<script></script>','')
2 1748 posted 15 years ago by emregulcan
A simple PHP object which connects to a mysql database, selects fields, creates users and more..
0 1518 posted 15 years ago by djstaz0ne
Create a new utf8 database in MySQL
1 1279 posted 15 years ago by manuelstofer
0 1216 posted 15 years ago by coevolve
Just a beginning, hoping to refine this ASAP.
0 1679 posted 15 years ago by alvincrespo
0 1404 posted 15 years ago by chrismendis
I had several vocabularies but wanted to merge them into one. A simple query does this for you. The vocabulary_id where I wanted to merge all the tags into is 3 The vocabulary_id where the tags are to be merged from is 7, 8 and 12
2 1653 posted 16 years ago by berkes
http://twitter.com/jose_506
0 1624 posted 16 years ago by jose_506
I used this code to run MySQL commands in ASP.NET
1 2089 posted 16 years ago by mpcircuitry
If you need to list all of the MySQL databases managed by Plesk along with their corresponding domains and login credentials, you can use this query:
1 1483 posted 16 years ago by tobewan
0 1712 posted 16 years ago by saturnxxi
Takes a .sql file and runs trough that, each line as an update_sql. Very usefull to track and migrate your blocks/views/cck etc changes.
0 1480 posted 16 years ago by berkes
I am forever forgetting this. Have to look up the 101 vs 103 in books online every time. Also forget which way around is US/NZ format. :-)
1 1936 posted 16 years ago by rengber
Dead simple, but often forgotten.
1 1620 posted 16 years ago by rengber
0 1164 posted 16 years ago by iTony