Re: [libreoffice-users] Sorting a MySQL Database

Ian

Unless the query contains ORDER BY clause in general the return set will  
be whatever default order of the dataset. Usually what I have seen, is to  
have a saved query that has the all the relevant options built-in and run  
it. I am not sure how to do this best in Base; I tend to use MySQL/MariaDB  
with other tools because my results will be used on a production database.

Your SQL code below will run on any SQL database I am aware of. SQL is a  
query language that is independent of the database so plain vanilla SQL  
should always work.

>      Select * from {Table Name}
>      ORDER BY LastName, FirstName;

Jay


On Tue, 27 Aug 2013 06:06:04 -0400, Ian Whitfield <whitfield@telkomsa.net>  
wrote:

> Thanks Jay
>
> On 26/08/13 15:54, Jay Lozier wrote:
> > Ian,
> >
> > Is there an id key field? If there is the default sorting is by the id  
> > key (usually numerical order).
> > In SQL you can add the line:
> > ORDER BY Last-Name, First-Name
> > The default order is ascending (ASC) if descending is needed
> > ORDER BY Last-Name DESC, First-Name DESC
>
> Yes - I do have an ID Field ("Record_No").
> I found the correct SQL 5.1 syntax for me was -
>
>      Select * from {Table Name}
>      ORDER BY LastName, FirstName;
>
> This worked fine and does the same as the 'Sort' button BUT it is still  
> not "fixed" or remembered!!
> You have to run this each time you start.
>
> Is there no way to make this automatic when you start the Database??
>
> With thanks
>
> IanW
> Pretoria RSA


--
Jay Lozier
jslozier@gmail.com

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted