Re: Pulling Percentages From Query

I'm trying to pull percentages from a query and really don't understand how to initiate this. SELECT COUNT(*) INTO @total FROM venues; SELECT venueID, COUNT(venueID)*100/@total AS Pct FROM venues GROUP BY venueID; PB Paul Nowosielski wrote: Dear All, I'm trying to pull percentages from a

Re: MAX() and GROUP BY question

On 11/10/06, [EMAIL PROTECTED] wrote: Hello everybody Can you explain me please how to get the entire row where ID is maximum per given status_id Mysql 4.0.xx Have you checked the manual? There is an entire page specifically about the group-wise maximum. Jochem -- MySQL General Mailing List

Re: Views accessed as table in MS Access

C K wrote: Hello, I am using MySQL 5.0.17 and MyODBC 3.51.12 with MS Access 2003/Xp with Jet 4.0. Currently it is not giving the normal problem of Access while inserting new records (#deleted), but when a View created in database is linked with MS Access it is not giviing correct results.

Re: check bugs.

C K wrote: please check bugs and please give the answer Bug ID=24216 and 24216 They are both the same bug ID, so I will only bother answering once. You probably are using InnoDB tables to store your data, and this is expected behaviour for InnoDB - MySQL provides a rough guess as to how

Re: access full-text index

AS for I know, you can use 'myisam_ftdump' to see the index contents and word distribution - Original Message - From: Leandro Guimarães Faria Corcete DUTRA [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, November 11, 2006 10:03:23 PM GMT-0500 US/Eastern Subject: Re: access

Re: InnoDB does not preserve AUTO_INCREMENT -- WTF!?

We ship out mySQL on our appliances in enterprise level scenarios. We often like to start the AUTO_INCREMENT for several tables at 10,000 -- this way we can reserve the lower 'block' of IDs for our own internal and 'default' use so all customers have the same basic database schema. It also

Re: Error:1067 could not start mysql server

Hi, On which platform? Have you checked with *.err file? Thanks ViSolve DB Team. - Original Message - From: VenuGopal Papasani [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, November 11, 2006 7:36 PM Subject: Error:1067 could not start mysql server Dear all, I am

RE: Views accessed as table in MS Access

Interesting. I also tried using views in Access, and found that it only gives data from the first table specified. However, when I tried accessing the same view from OpenOffice using ODBC, it worked fine. Are there any other ways we can find out if this is a MyODBC error or Access/MSJET?