Welcome To Snipplr


Everyone's Recent MySQL Snippets



1 2 3 4 5 ... 8
Con estas instrucciones se pueden corregir los caracteres latinos que hayan sido almacenados erróneamente en una base de datos MySQL
1 238 posted 9 years ago by n19ht
0 135 posted 9 years ago by apro2000
remove the square brackets
0 141 posted 9 years ago by springy
Snippet used to create users on databases
1 148 posted 9 years ago by digitalclubb
0 121 posted 9 years ago by pwd
Seleccion los datos mas repetidos de una tabla y los ordeno por la cantidad que se repiten, sirve para seleccionar a los usuarios más activos por ejemplo, etc.
0 255 posted 9 years ago by serialk89
0 68 posted 9 years ago by Ez3k
0 92 posted 9 years ago by kidmizere
Get closest location to a set of gps coordinates (x, y) given a database table with columns lat(latitude) and lng(longitude)
0 63 posted 9 years ago by muximus
0 85 posted 9 years ago by erraja_07
The datetime_field value in the database is '0000-00-00 00:00:00'.
0 94 posted 9 years ago by dsoms
For example: search_value = 3, column_value = 1,2,3,4,5,6
0 111 posted 9 years ago by dsoms
MYSQL Convertir un timestamp en heure lisible
0 119 posted 9 years ago by Phibo
0 109 posted 9 years ago by erraja_07
Go to the Windows command line by going to Start -> Run and typing in cmd. You need to change directory to the MySQL bin directory. On my version, the directory is c:\wamp\bin\mysql\mysql4.1.22\bin. Therefore, the command to change to this dire...
0 113 posted 9 years ago by TheJasonParker
drop_tables_like(pattern, db)
0 114 posted 9 years ago by abstraktor
0 120 posted 9 years ago by takel
0 112 posted 9 years ago by dsoms
1 80 posted 9 years ago by yanek1988
0 127 posted 9 years ago by sjacunningham
With this snipt you could replace all the "<br>" tags that you have in a table for php newline character.
0 181 posted 9 years ago by tonatiuh
0 145 posted 9 years ago by BoNzO
3 144 posted 9 years ago by nielsenrc
If a MySQL DB for WordPress is encoded as latin1, these steps will prevent utf8 encoding issues.
0 126 posted 9 years ago by theriddlebrothers
If you run a query to delete old posts manually from MySQL in a WordPress database, the old tags will remain and appear in your tag cloud/listing. This allows you to identify those unused tags, and then delete them with an additional query.
0 80 posted 9 years ago by theriddlebrothers
If you every get hit by ERROR 1153 (08S01): Got a packet bigger than 'max_allowed_packet' bytes, then this might help. You also need to make sure that the user that you log in with has SUPER privileges on their account.
0 136 posted 9 years ago by daipratt
Ftp your *.sql file to the (remote) machine, login via SSH and then go to the directory where your sql file is and run this code.
0 90 posted 9 years ago by TheJasonParker
1 2 3 4 5 ... 8