The SQL statement is as follows: SELECT * FROMchannelASaJOINfloorsbONa. iflooridb. idjoinfloorscona. oflooridc. id connects to the same table consecutively. This SQL statement can be directly executed on the mysql terminal. However, when running with jdbc. Error message: YouhaveanerrorinyourSQLsyntax; checkthemanualthatcorrespondstoyourMyS... mysql database
The SQL statement is as follows:
SELECT * FROM
Channel AS a JOIN floors B ON a. ifloorid = B. id
Join floors c on a. ofloorid = c. id
Connects to the same table consecutively.
This SQL statement can be directly executed on the mysql terminal.
However, when running with jdbc. Error message:
You have an error in your SQL syntax;
Check the manual that corresponds to your MySQL server version for the right syntax to use near ''floors 'B ON a. ifloorid = B. id JOIN 'floors 'c ON ??? Ofloorid = c. ID' at line 1
The database version is 5.5, and the mysql jar version is 5.1.6.