Welcome To Snipplr


Everyone's Recent Snippets Tagged mysql



1 ... 10 11 12 13 14 ... 19
This could be further abstracted to work with other db's. Also, it really should be using Ruby's Tempfile class instead of assuming the local machine is *NIX based, but it works :)
0 630 posted 14 years ago by nate63179
1 703 posted 14 years ago by Mithun
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 684 posted 14 years ago by tobewan
Where: * 3307 is the local port used to connect to the remote database. You can use 3306, however, this could conflict with your PC’s MySQL installation. * localhost and 3306 is the MySQL address from the remote server (most people will...
0 585 posted 14 years ago by danshields
1 660 posted 14 years ago by oslego
1 637 posted 14 years ago by troynt
Must have a field named Weight. The more Weight the more often the record is selected. Weight should be an integer between 1 and 10.
1 707 posted 14 years ago by BFTrick
MySQL Insert Unique Reference using MAX() to obtain latest value Alternate solution to using Composite Primary Keys which INNODB engine does not support.
0 581 posted 14 years ago by cherbert
1 534 posted 14 years ago by nkm
This snippet collects a date from a var and formats it into the correct format for database date entry
0 673 posted 14 years ago by daveismyname
0 500 posted 14 years ago by 1b0t
Remove <>
0 721 posted 14 years ago by jodm
3 819 posted 14 years ago by nkm
Dumps whole query so developer can see where is error. However it's potential security issue, exposing SQL commands to attacker. (Recommended to use only during development, replace message code with some custom error text)
0 806 posted 14 years ago by acosonic
This piece of code will store each line of a txt file into a mysql database
2 974 posted 14 years ago by fackz
Used to make sure the server log dose not fill up the hd.
2 565 posted 14 years ago by mushookies
0 517 posted 14 years ago by jonniespratley
Outputs MySQL server stats : uptime, threads, questions, slow queries, opens, flush tables, open tables, queries per sec (avg).
2 462 posted 14 years ago by NyX
How to fix MySQL Query Browser socket connection problem
0 604 posted 14 years ago by armandoalves
0 924 posted 14 years ago by CuDDL
4 710 posted 14 years ago by pdswan
1 ... 10 11 12 13 14 ... 19