Welcome To Snipplr


Everyone's Recent MySQL Snippets



0 838 posted 14 years ago by kaartz
Syntax used to create a table in MySQL. Replace column names as appropriate. Primary key should also be modified to suite needs.
2 925 posted 14 years ago by dkynyc
View the syntax used to create a table called time_zone.
1 872 posted 14 years ago by dkynyc
Allows us to see the syntax used to create a database.
1 872 posted 14 years ago by dkynyc
Issue commands via batch mode.
2 942 posted 14 years ago by dkynyc
0 1001 posted 14 years ago by Jamie
1 1026 posted 15 years ago by electblake
Display records older than one week.
1 1103 posted 15 years ago by galofre
1 677 posted 15 years ago by gcman105
How to add an auto-incremented column to an existing table without ex- and reimporting.
0 1214 posted 15 years ago by simondiercks
Simply uncomment the appropriate line for some common, useful Administration SQL statements for MySQL. (Uncomment and run 1 line at a time)
0 852 posted 15 years ago by zonetrooperex
Manejo de fechas y formateado MYSQL
0 893 posted 15 years ago by xaviles
Esquema basico de manejo de cursores en MYSQL
0 1041 posted 15 years ago by xaviles
Esquema de sentencias para el control de errores en SP de MYSQL. Es un metodo basico
0 1281 posted 15 years ago by xaviles
Just run the following query on your WordPress database, and all revisions (As well as meta associated with it) will be deleted from your database.
2 1138 posted 15 years ago by jessibird
This is useful for when a Wordpress environment goes live; typically the uploads have an absolute URL.
5 1261 posted 15 years ago by Jamie
After a problem with row break in a text field I found this way of searching within a where clause in an SQL query. Can be used for selection or update / replace purposes of course.
0 1616 posted 15 years ago by davidrinnan
General MySQL engine related commands
0 922 posted 15 years ago by sukantahazra
0 882 posted 15 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 1227 posted 15 years ago by bradless
1 1003 posted 15 years ago by therobot
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 1301 posted 15 years ago by johnandrewsroot