Menu

#62 MySQL select statement using JDBC

v1.1
open
nobody
5
2012-10-24
2004-02-19
Ben Martin
No

For a attribute scale using two attributes
hp < 10
hp < 20

The SQL generated and submitted to MySQL via JDBC seems
to include a SELECT (*) which MySQL doesn't like.

Submitted query for part of the lattice
select () FROM aom WHERE ( NOT (hp < 10) AND NOT (hp
<20) );
ERROR 1064: You have an error in your SQL syntax near
'
) FROM aom WHERE ( NOT (hp < 10) AND NOT (hp <20)
)' at line 1

But without the (*) part and just * MySQL runs the
query fine.

mysql> select * FROM aom WHERE ( NOT (hp < 10) AND
NOT (hp <20) );
+---------... data follows ...

Discussion


Log in to post a comment.

MongoDB Logo MongoDB