MySQL Forums
Forum List  »  Oracle

count (*), fails, count(*) works, how do I fix it?
Posted by: Eric Gandt
Date: June 02, 2006 01:05PM

Migrating an application from Oracle to mysql, now I can change much of the code base, but there are some parts that are off limits, the place I encounter issues is that the off limit code is using count (*), where there is a space between the count and the (*), now mysql needs count(*), no space. Is there a way around this, all other DBs I've tried Oracle,DB2,MS SQL all support count_(*) where _ is a space, but mysql does not. Is there a fix for this simple yet very annoying error?


Thanks,
ERIC GANDT
Fatwire Software

Options: ReplyQuote


Subject
Views
Written By
Posted
count (*), fails, count(*) works, how do I fix it?
5599
June 02, 2006 01:05PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.