Mysql – Is it possible to create mutiple MySQL queries within the same table

MySQL

Is it possible to make multiple queries at once within the same query?

Here is an example of what I'm trying to do.

We have the following table:

| userid | price | stock | description | 
----------------------------------------
  1        10.00   5       some text 
  2        25.00   2       some text
  3        15.00   3       some text
  4        35.00   2       some text
  5        30.00   4       some text

The queries that I'm trying to do are:

the MIN and MAX price group by description
the price set by userid 2
Stock and price of the first three results only without grouping

So the HTML table will look like this:

description | Min_Price | Max_Price | Price Set by userid 2 | 1st Price | 1st Stock | 2nd Price | 2nd Stock | 3rd Price | 3rd Stock

Best Answer

MySQL Unions (http://dev.mysql.com/doc/refman/5.0/en/union.html) should probably put you on the right track.

You could also do most of it with sub selects, though that is probably not a great idea.

Related Solutions

Mysql – How to find all the tables in MySQL with specific column names in them

To get all tables with columns columnA or ColumnB in the database YourDatabase:

SELECT DISTINCT TABLE_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('columnA','ColumnB')
        AND TABLE_SCHEMA='YourDatabase';

Mysql – Should I use the datetime or timestamp data type in MySQL

Timestamps in MySQL are generally used to track changes to records, and are often updated every time the record is changed. If you want to store a specific value you should use a datetime field.

If you meant that you want to decide between using a UNIX timestamp or a native MySQL datetime field, go with the native format. You can do calculations within MySQL that way ("SELECT DATE_ADD(my_datetime, INTERVAL 1 DAY)") and it is simple to change the format of the value to a UNIX timestamp ("SELECT UNIX_TIMESTAMP(my_datetime)") when you query the record if you want to operate on it with PHP.

Best Answer

Related Solutions

Mysql – How to find all the tables in MySQL with specific column names in them

Mysql – Should I use the datetime or timestamp data type in MySQL

Related Topic