在NAVIcat中，应该怎么将查询结果按列打印。

Question

SELECT*FROM provincs\G

    -> ;

1064 - 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 '\G' at line 1

Answer 1

SELECT * FROM provincs\G；保证拼写正确，检查一下是不是你的表名拼写错了

Answer 2

select * from provinces; 首先保证语法正确，上面工具条应该有个查询按钮，点一下就行了