Question

myeclipse 创建db browser无法查看表数据

Error: Cannot edit: Syntax error or access violation message from server: "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 'OPTION SQL_SELECT_LIMIT=2000' at line 1"

Answer 1

set linesize 300
select * from ALL_tables where table_name='PHONEREQUEST';
看看这个表显示在哪个用户下

Answer 2

数据库驱动版本和数据库不匹配，更新一下驱动jar包试试