Advanced Search

Welcome To Snipplr

Everyone's Recent Snippets Tagged mysql

1 ... 8 9 10 11 12 ... 19
Simply uncomment the appropriate line for some common, useful Administration SQL statements for MySQL. (Uncomment and run 1 line at a time)
0 476 posted 14 years ago by zonetrooperex
creates a user that has only access to one database, from any host
1 848 posted 14 years ago by manuelstofer
Manejo de fechas y formateado MYSQL
0 534 posted 14 years ago by xaviles
Esquema basico de manejo de cursores en MYSQL
0 701 posted 14 years ago by xaviles
Esquema de sentencias para el control de errores en SP de MYSQL. Es un metodo basico
0 865 posted 14 years ago by xaviles
0 563 posted 14 years ago by coevolve
This is useful for when a Wordpress environment goes live; typically the uploads have an absolute URL.
5 883 posted 14 years ago by Jamie
0 632 posted 14 years ago by jonniespratley
General MySQL engine related commands
0 567 posted 14 years ago by sukantahazra
0 498 posted 14 years ago by sukantahazra
0 545 posted 14 years ago by atma
1 552 posted 14 years ago by atma
I use something similar to the example to get the difference between statuses in a status log table that I have. It comes in handy when determining the number of days between status changes. This works in MySQL 5.0.
0 823 posted 14 years ago by bradless
1 611 posted 14 years ago by therobot
Function to fix char set and collation on mysql tables, see [this link](http://www.barattalo.it/2010/02/11/php-function-to-fix-collation-on-database-fields-of-mysql/ "Fix encoding on db") for examples and more infos.
1 934 posted 14 years ago by ginoplusio
This is useful for escaping multiple values in a POST array.
0 659 posted 14 years ago by bradless
0 597 posted 14 years ago by chrismendis
If the official codex approach (http://codex.wordpress.org/Changing_The_Site_URL) is causing you problems, give this a try. Be sure to change the constant declarations and modify table names as necessary for your instance. Confirmed working with WP v...
1 888 posted 14 years ago by johnandrewsroot
1 1037 posted 14 years ago by ginoplusio
1 685 posted 14 years ago by ginoplusio
A utility function to preserve an array in a session. Adding the newest element to the beginning of the array and popping out the last one. Useful for displaying for instance; your last searches option in your website.
1 773 posted 14 years ago by Heroftime
1 ... 8 9 10 11 12 ... 19