Fwd: Re: Problem with GROUP BY ... DESC
> > Ver 11.15 Distrib 3.23.46, for pc-linux-gnu (i686) > > > > The problem that has cropped up I have is that in all GROUP BY column DESC > > statements, the DESC is now not being recognized, and the query is being > > returned in ascending order. If I use ORDER BY... DESC that works fine. > >I'm seeing the same bug on 3.23.45 (and maybe others but I can't remember >all the versions I've played with recently). It does the same thing where >it accepts the syntax but does not respect it (and returns rows in the >default ASC ordering). The problem is apparently solved if you kluge with e.g. select field, count(field) from table group by field order by field desc but it IS a kluge. AJ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with GROUP BY ... DESC
Hello: I'm new to the list and have a question. I upgraded from version 3.22 to this version: Ver 11.15 Distrib 3.23.46, for pc-linux-gnu (i686) The problem that has cropped up I have is that in all GROUP BY column DESC statements, the DESC is now not being recognized, and the query is being returned in ascending order. If I use ORDER BY... DESC that works fine. For example, I have a database with about 25,000 records, and I get these results: WORKING CORRECTLY. select memberno from testpubl order by memberno desc limit 7 (0,0): 7395261 | (1,0): 7395260 | (2,0): 7395259 | (3,0): 7395258 | (4,0): 7395257 | (5,0): 7395256 | (6,0): 7395255 | NOT WORKING... select memberno from testpubl group by memberno desc limit 7 (0,0): 24754 | (1,0): 24755 | (2,0): 24805 | (3,0): 24818 | (4,0): 24853 | (5,0): 24882 | (6,0): 24961 | (I know that in this example I could just use the ORDER BY statement, but I wanted to show what was going on. I have other queries with COUNT() statements in them that need the GROUP BY statement and are having problems.) It's hopefully implicit here that all these statements were working fine before the upgrade. Any comments would be greatly appreciated. AJ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can you convert a MS Sql database to MySQL?
Does anyone know any good source of info for the conversion of MS Sql databases to MySql? Perhaps a prog that does this? Thanks for any information in advance, AJ Workman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Locked out of mySQL.
Hello, I'm trying to learn mysql & PHP. I recently set up the mysql server (with the file: mysql-3.23.32-pc-linux-gnu-i686.tar.gz) My problem is this: I either forgot the password, or neglected to set up any user accounts. The documentation says to do this: ./bin/mysqladmin -u root -p password 'new-password' ./bin/mysqladmin -u root -h twistedlogic -p password 'new-password' which returns the following: Enter password: ./bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' I also tried renaming the mysql directory (in /usr/local/) and re-installing it. no. maybe I did something wrong there, because that seems to me it should have worked, being a binary package... and the mysql table being held in mysql/data/mysql. anyway, if anyone knows how I can get back in tell me! :) thanks, AJ. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
