Forums

Help with MySQL Console

How do I run queries in the MySQL console? When I try to run a select statement, all I get is a "->" prompt. I've verified that the tables I'm querying exits in the database.

deleted-user-53344 | 7 posts | Nov. 20, 2012, 2:07 a.m. | permalink

sounds like you forgot to put a semicolon at the end of the query.

Beloved premium user catweazle | 20 posts | Nov. 20, 2012, 4:31 a.m. | permalink

Yup, sounds that way. Or instead of a semicolon you can use \G which presents the data in a more verbose form - useful for tables with a lot of columns, but takes up many more rows.

deleted-user-39880 | 669 posts | Nov. 20, 2012, 1:43 p.m. | permalink

I'm an idiot. Thank you.

deleted-user-53344 | 7 posts | Nov. 27, 2012, 1:51 a.m. | permalink

The \G switch is nice to know about. Cheers Cartroo.

Staff hansel | 459 posts | PythonAnywhere staff | Nov. 27, 2012, 11:41 a.m. | permalink