Welcome To Snipplr
Everyone's Recent MySQL Snippets Tagged mysql
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
You have two tables galleries and images, and you need to know how many images each gallery has associated with it. This Query returns the sum of distinct record joined to another table by a common field (gallery_id).
0
781
posted 13 years ago by jbranca
Syntax used to create a table in MySQL. Replace column names as appropriate. Primary key should also be modified to suite needs.
2
594
posted 13 years ago by dkynyc
How to add an auto-incremented column to an existing table without ex- and reimporting.
0
789
posted 14 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
471
posted 14 years ago by zonetrooperex
Esquema de sentencias para el control de errores en SP de MYSQL. Es un metodo basico
0
860
posted 14 years ago by xaviles
This is useful for when a Wordpress environment goes live; typically the uploads have an absolute URL.
5
878
posted 14 years ago by Jamie
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
817
posted 14 years ago by bradless
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
881
posted 14 years ago by johnandrewsroot