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
nebula3y ago
just do
select * from bp_reviews;
select * from bp_reviews;
deadeagle
deadeagle3y ago
it says
Unknown database 'railway'
Unknown database 'railway'
Rumon
Rumon3y ago
Try:
SELECT * FROM location_reviews.bp_reviews;
SELECT * FROM location_reviews.bp_reviews;
deadeagle
deadeagle3y ago
same error
Web Dev Cody
Web Dev Cody3y ago
For Postgres I had to do select * from “public”.”myDbtable” for it to work
Rumon
Rumon3y ago
Is your MySQL database up and running? Can you manually check the tables from "Data" tab?
deadeagle
deadeagle3y ago
Nope nothing is shown Yes the sql is up and running
angelo
angelo3y ago
I think this may be a bug with MySQL on Railway. I have raised it to the team.
deadeagle
deadeagle3y ago
thank you
Want results from more Discord servers?
Add your server