AW: Befehl zusammenfassen

[Christoph Loeffler]

Hallo,

Am Mittwoch, 24. Juli 2002 um 14:36 tipperte Ralf:

> Grobmeier, Christian wrote:

>> SELECT          products.products_model,
>>                 products.products_bestnrlieferant,
>>                 products_description.products_nema
>> FROM            products,
>>                 products_description
>> WHERE...
>> SORT BY products.products_bestnrlieferant

> Sollte das nicht ORDER BY heissen? Oder ist das eine 
> nicht-ANSI-SQL-Erweiterung von MySQL?

ja, es sollte ORDER BY heissen, sort by gibt es laut Manual
nicht.

SELECT Syntax

SELECT [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
       [SQL_CACHE | SQL_NO_CACHE] [CALC_FOUND_ROWS] [HIGH_PRIORITY]
       [DISTINCT | DISTINCTROW | ALL]
    select_expression,...
    [INTO {OUTFILE | DUMPFILE} 'file_name' export_options]
    [FROM table_references
        [WHERE where_definition]
        [GROUP BY {unsigned_integer | col_name | formula} [ASC | DESC], ...]
        [HAVING where_definition]
        [ORDER BY {unsigned_integer | col_name | formula} [ASC | DESC] ,...]
        [LIMIT [offset,] rows]
        [PROCEDURE procedure_name]
        [FOR UPDATE | LOCK IN SHARE MODE]]
        
ciao 
Christoph Loeffler                

---
Infos zur Mailingliste, zur Teilnahme und zum An- und Abmelden unter
-->>  http://www.4t2.com/mysql