Stack Overflow
Stack Overflow

Questions tagged [sequelpro]

Graphical sql browser for Macs

A graphical user interface for database management on OSX.

249 questions
1
vote
1 answer

Need to find time difference in hours between 2 timestamps for multiple rows in a result sql table

I had 3 tables on which I performed certain operations and was able to arrive at the following table Table1 OID SID OID_create SID_create 817953 951261 2020-05-01 00:00:16 2020-05-01 10:15:32 817953 951407 2020-05-01 00:00:16…
sup
  • 15
  • 4
1
vote
1 answer

Need help to group the available order details table to arrive at the distribution of count(order_line_item) , Qty and count(Qty)

I have a order table with the following information Order ID, Product ID, Quantity ordered OID PID Qty 1 10 1 1 20 2 2 10 2 2 40 4 3 50 1 3 20 3 4 30 1 4 90 2 4 90 5 5 10 2 5 20 2 5 70 5 5 60 1 6 80 2 If I…
sakura01
  • 13
  • 4
1
vote
0 answers

Access denied for user 'root'@'localhost' with postman API only

I'm using postman to try and make an API post request: http://127.0.0.1:8000/api/auth/register?name=corbin&email=corbin@example.com&password=password There must be a database connecting because I can migrate my db just fine. Using php artisan…
Kyle Corbin Hurst
  • 917
  • 2
  • 10
  • 26
1
vote
0 answers

Laravel Forge Database not Connecting with Sequel Pro

When I connect to my Laravel Forge server via Sequel Pro, it just sits there saying Connecting... But, it never does. I've even tested the connection, before connecting and it succeeds. Keep in mind, I have installed WordPress via Forge, and can…
Danny
  • 43
  • 7
1
vote
1 answer

SQL Query to conditionally join columns from different databases

I am migrating data from an old DB to a new one. My goal is to move a user's permissions from the old DB to the new DB. Both the old and new DBs already have matching user IDs. The problem is that the old database has multiple rows for each user's…
Smug
  • 39
  • 5
1
vote
0 answers

Unable to connect to RDS instance using MySQL client

First thing first, I have checked almost all the answers related to this but couldn't find the cure to the problem. To connect to RDS, I know that we need to set the inbound rules in the security group associated with the RDS instance to my…
roger_that
  • 9,493
  • 18
  • 66
  • 102
1
vote
1 answer

Connecting to local DB while running docker container

I am running an app from a docker container and at some point, I had Sequel Pro connected to my local DB but since reinstalling Sequel Pro, I haven't had luck connecting back to my local DB. Where would I find the IP/port to use for this? I tried…
herkypam
  • 75
  • 2
  • 11
1
vote
1 answer

Importing a DB into AWS RDS DB

I want to import a mySQL DB into an AWS mySQL DD by using a sql file that I previously exported from another DB, I am using Sequel Pro but I take ages. I would like to know if there is a faster way to do it, like uploading directly the sql file to…
Nuñito Calzada
  • 4,394
  • 47
  • 174
  • 301
1
vote
0 answers

MySQL server flicking on and off

I have installed MYSQL with homebrew and am accessing it via the client in system preferences. When I click "Start MYSQL Server" the only installed instance MySQL 8.0.14 goes from red to green becoming active, but only remains active for a few…
greenPlant
  • 482
  • 4
  • 16
1
vote
0 answers

Sequel Pro: Can't connect to MySQL server on '127.0.0.1' (61) using mariadb installed via homebrew

I'm trying to set up a wordpress environment. Using homebrew I've installed laravel valet and mariadb, and am using sequel pro to manage databases. Right now, I can start mariadb using brew services start mariadb. However, when I go to sequel pro…
Chris Shaugh
  • 185
  • 1
  • 1
  • 10
1
vote
2 answers

Connect to Mariadb via sequelpro to a synology NAS

The goal here is to connect to mariadb via sequelpro, or by ssh. The problem that I found is related with the application itself. If I get access to synology server via ssh, I can access to mysql server. How? Going to the folder and…
nunodsousa
  • 2,635
  • 4
  • 27
  • 49
1
vote
0 answers

Trying to get this code to pull using MAMP and sequelpro using c#

I am trying to get this code to pull from a sequel pro database using c# and MAMP and I keep getting the following error after I enter the city name that is for sure in the database. I don't understand why it's saying that the connection needs to be…
Leo Lyons
  • 41
  • 2
1
vote
0 answers

SQL query working on local but not working on production

I am trying to run following query in localhost (Sequel pro) is giving me correct output but when I am trying to run it on production 'distance' and 'branch_name' fields are empty. Local MySQL version is 5.5.58 and production MySQL version is…
Hishmat Mahesani
  • 11
  • 2
1
vote
1 answer

Inserting data in SQLPro

Is there a way to insert data here, for example, by clicking "Add new row" or double clicking the entry? I'm used to this feature in SequelPro, and it seems a bit crude to not allow a simple GUI way to add in a new row (the reason why I'm using this…
David542
  • 104,438
  • 178
  • 489
  • 842
1
vote
1 answer

Sequel Pro / Remove Line Breaks when pasting to spreadsheet

I know there have been a number of posts about this and I promise I looked through as many as I could stomach before posting my own version of it. I'm pulling an email body from sequel and pasting it into excel as part of a greater project. Each…
Winklevoss333
  • 89
  • 7
1 2 3
…
16 17