tag:blogger.com,1999:blog-1604594366142210766.post947118793233370379..comments2023-05-15T02:58:09.512-07:00Comments on Java ${Level Up}: Connect to mysql 5 with Tomcat 6dimkahttp://www.blogger.com/profile/08664787622082725550noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-1604594366142210766.post-74030020348537497772009-01-11T02:08:00.000-08:002009-01-11T02:08:00.000-08:00I think that you must using HAVING instead of WHER...I think that you must using HAVING instead of WHERE. See: http://dev.mysql.com/doc/refman/5.0/en/select.html Can you write error in comment?dimkahttps://www.blogger.com/profile/08664787622082725550noreply@blogger.comtag:blogger.com,1999:blog-1604594366142210766.post-56900852492336651632009-01-11T02:02:00.000-08:002009-01-11T02:02:00.000-08:00Hi...I have a problem with mysql SQL syntax: simpl...Hi...<BR/>I have a problem with mysql SQL syntax: simple SELECTs work good, but something like "SELECT count(*) from my_table where a=1 and b=2" doesn't work... <BR/><BR/>I'm using:<BR/>Netbeans 6.5 MySQL 5.1 connector/J 5.1.6 Servlets<BR/><BR/>didn't configure anything - just using netbeans with tomcat and mysql library in project properties.Anonymousnoreply@blogger.com