Railway•3y ago

MySQL querying in railway query option

Hello, I have created a mysql database in railway and connected to it remotely using workbench. I then imported data into it. However, when i try querying from the railway query, it fails despite it working on workbench. Why is that so? This is my query:

location_reviews;
select * from bp_reviews;

location_reviews;
select * from bp_reviews;

and the error it gives is

use location_reviews; select * from bp_reviews; - 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 'select * from bp_reviews' at line 2

use location_reviews; select * from bp_reviews; - 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 'select * from bp_reviews' at line 2

9 Replies

nebula•3y ago

just do

select * from bp_reviews;

select * from bp_reviews;

deadeagleOP•3y ago

it says

Unknown database 'railway'

Unknown database 'railway'

Rumon•3y ago

Try:

SELECT * FROM location_reviews.bp_reviews;

SELECT * FROM location_reviews.bp_reviews;

deadeagleOP•3y ago

same error

Web Dev Cody•3y ago

For Postgres I had to do select * from “public”.”myDbtable” for it to work

Rumon•3y ago

Is your MySQL database up and running? Can you manually check the tables from "Data" tab?

deadeagleOP•3y ago

Nope nothing is shown Yes the sql is up and running

angelo•3y ago

I think this may be a bug with MySQL on Railway. I have raised it to the team.

deadeagleOP•3y ago

thank you

Gaming

Programming

MySQL querying in railway query option