Graphical sql browser for Macs
A graphical user interface for mysql database management on OSX.
Questions tagged [sequelpro]
249 questions
-1
votes
1 answer
one application with two database in heroku
I want to create one more database in current application served by heroku (database is clearDB and its management is sequel pro).
In heroku config, I tried to set Environment variables like DATABASE_SECOND_URL, dbname2, etc, however, couldn't add…
tac
- 1
- 1
-1
votes
1 answer
SQL query with multiple tables, columns, values
I'm very new to SQL, so be gentle if I write complete bullshit. I got a phpbb database, where I need to get post_topic and post_text of all topics that are in topics_track from a specific user. My unsuccessful query (again, with basically no…
-1
votes
1 answer
Can't connect to MySQL server on 'internal-db.xxxxx.gridserver.com' (4)
I'm trying to connect to mySQL via Sequel Pro, but continue to receive the "MySQL said: Can't connect to MySQL server on 'internal-db.xxxx.gridserver.com' (4)" error message.
mySQL is hosted via mediatemple.
I'm on macOS Sierra v 10.12.2
I've…
Simon Cooper
- 1,574
- 4
- 24
- 53
-1
votes
1 answer
Sequel Pro MySQL Error: Access denied for user 'root'@'localhost' to database 'sakila'
Sequel Pro won't let me run the sakila db. the following error comes up:
Access denied for user 'root'@'localhost' to database 'sakila'
How do I fix this?
Arushi Tainwala
- 1
- 1
- 1
-1
votes
1 answer
Error executing MySQL code
I am using SEQUEL Pro and MySQL. When I execute each line individually no errors are generated and code works as expected. When I try to execute all lines together I get the error below.
DELIMITER $$
CREATE TEMPORARY TABLE pricesOutput (price…
Clive
- 1
-2
votes
1 answer
Get SELECT * WHERE {certain parameters are met} but is blocked by the WHERE statment
The title may be a little misguided but I am unsure of how to phrase it.
I am having an issue where I need to return the details of the manager with the most subordinates.
The table is currently set out like this for example.
I am currently running…
SLHEFC1928
- 19
- 1
- 5
-2
votes
1 answer
Is there a good standalone Mac application for Python?
I'm just getting into Python coding on my Mac using El Capitan. The main code I use is SQL, which I almost exclusively do through Sequel Pro. But as I'm using Python more-and-more (mostly through TextWrangler currently) and I was wondering if…
Ryan
- 501
- 1
- 12
- 26
-3
votes
2 answers
what is wrong with mysql statement
this is my statement and what I'm trying to do is get the average amount per user per order, running into problems and don't know how to fix it,
all help is appreciated
SELECT usuarios.email, AVG(pedidos_onlines.total),
CASE WHEN p.nombre like…
-5
votes
2 answers
Select columns thats greater than?
I have a table(mysql) and in my query I would like to get only the columns that are greater or equal to 4, but I have no clue how to do that.
SELECT * FROM my_table WHERE * (all foo columns foo1-foo7) >= 4 AND date = '2015-09-03'
My table looks…
Locos
- 105
- 1
- 8