faqts : Computers : Databases : MySQL

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

9 of 20 people (45%) answered Yes
Recently 3 of 10 people (30%) answered Yes

Entry

mysql server is down each time i use ORDER BY in a query - an idea ? Thank You

Feb 11th, 2008 01:03
dman, The Guru, Curtis, pier carlo, http://sturly.com


I have noticed that it matters where you put the ORDER BY in a query, 
it 
needs to be after full select statement, for example:
SELECT * FROM myTable ORDER BY date

Give the SQL that you are using and I'll see what I can do.

[added by The Guru]

You might like to share the query with us so that we can look into 
where the things are going wrong.

The Guru