Re: order by: more that one field

2004-02-13 Thread William R. Mussatto
Mike Mapsnac said:
> Have some questions about Order By:
>
> Can a mysql query be order by more than  one field?
>
> If this two queries will give different result or not?
> #1 select * from t1 Order by id, username;
> #2 select * from t2 Order by id
>
> _
> Choose now from 4 levels of MSN Hotmail Extra Storage - no more account
> overload! http://click.atdmt.com/AVE/go/onm00200362ave/direct/01/
>
yes.

William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



order by: more that one field

2004-02-13 Thread Mike Mapsnac
Have some questions about Order By:

Can a mysql query be order by more than  one field?

If this two queries will give different result or not?
#1 select * from t1 Order by id, username;
#2 select * from t2 Order by id
_
Choose now from 4 levels of MSN Hotmail Extra Storage - no more account 
overload! http://click.atdmt.com/AVE/go/onm00200362ave/direct/01/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]