Graphical sql browser for Macs
A graphical user interface for mysql database management on OSX.
Questions tagged [sequelpro]
249 questions
1
vote
2 answers
Struggling with a min(date) solution
I have a dataset with these columns:
Date
Code
Link
Clicks
Each code represents a person, and my goal is to find the first date someone posted each link and how many clicks each link has. To be considered a legitimate post, a link must have a…
vudupins
- 39
- 6
1
vote
2 answers
MySQL - Count number of rows in each group
I have a SQL table user_game which contains the games that a user owns:
| id | user_id | game_id |
|----|---------|---------|
| 83 | 1 | 1 |
| 84 | 1 | 2 |
| 85 | 1 | 3 |
| 86 | 2 | 2 |
| 87 | 2 …
Zephyr
- 225
- 1
- 3
- 14
1
vote
1 answer
Importing another table into a database and adding fields
I have a csv file which I wish to import into my database. However, the columns in the csv file do not match the columns in the table I want to import it into. I would like to do two things:
Import the table but only some of the columns
Provide…
user6369603
1
vote
0 answers
Need to order each of three colums "lg_ID" 1st, "Starting_pitcher" 2nd, and "Game-Date" third, with Game_Date rows in ascending, sequential order?
I'm having difficulty ordering by "Starting_Pitcher" column for the full range of dates available in the Game_Date column; When I click on "Game_Date" column heading in Sequel Pro with the purpose of ordering any given starting_pitcher results by…
LeeZee
- 107
- 1
- 12
1
vote
3 answers
SSH access on Sequel Pro not working with Vagrant
Trying to get in to this vagrant box using Sequel Pro. The Error Detail screen is;
Used command: /usr/bin/ssh -v -N -S none -o ControlMaster=no -o ExitOnForwardFailure=yes -o ConnectTimeout=10 -o NumberOfPasswordPrompts=3 -o TCPKeepAlive=no -o…
mikelovelyuk
- 4,042
- 9
- 49
- 95
1
vote
1 answer
Docker + MariaDB connection
Ive got a magent2 docker VM running - all working well. The only issue is I cant seem to figure out how to conenct to the DB via Sequel Pro...
Im using nginx/php7.0/mariaDB images with Dinghy/Docker/Virtualbox.
Pretty new to docker so if you could…
Tom Burman
- 947
- 3
- 15
- 37
1
vote
2 answers
How can I create a column with categorical values ("home", "away") conditional on column values from another table
I would like to create a column in table "starting_pitcher_game_log" for "HomeAway_ID" conditional on values of two columns in another table, "FLD_team_ID" and "Away_Team_ID" such that when "FLD_team_ID" and "Away_Team_ID" are equal to each other,…
LeeZee
- 107
- 1
- 12
1
vote
2 answers
How do I resolve 'Unexpected number of row removed!'?
I'm trying to delete all row of data in my tables and reset the auto increment. When I do, I get this message :
Unexpected number of rows removed!
One row was not removed. Reload the table to be sure that the contents
have not changed in the…
jackjoesmith
- 951
- 4
- 20
- 33
1
vote
1 answer
SSH Port forwarding failed when trying to connect to remote database via SSH
I am trying to connect to my remote MySQL database at my DigitalOcean SSD via SSH using Sequel Pro. This is my setup:
Name: MyWebApp
MySQL-Host: 188.226.150.240
User: localhost
Password: mySQLpassword
Database: rails
Port: 3306
SSH host:…
Tintin81
- 9,821
- 20
- 85
- 178
1
vote
1 answer
Why does Sequel Pro show a different result for a table's key values than MySQL on the command line?
This is the structure of a particular table in Sequel Pro:
This is that same table structure as viewed on the command line:
Here is the output of SHOW CREATE TABLE field_data_field_checklist_status:
| field_data_field_checklist_status |
CREATE…
Blake Frederick
- 1,510
- 20
- 31
1
vote
1 answer
Remote login to Heroku postgres?
I have a rails app hosted on heroku that uses postgres as the db.
I'd like to manage a few records of the db using a visual db management application, like Sequel Pro.
Sequel Pro needs the credentials of the database to log on (host, username,…
johncorser
- 9,262
- 17
- 57
- 102
1
vote
1 answer
How do I add a foreign key to a table in Sequel Pro?
I am trying to add a foreign key to a table in Sequel Pro (using the UI).
I have two tables: "titles" and "categories" as below:
CREATE TABLE `titles` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` tinytext NOT NULL,
`category`…
Tim Elhajj
- 835
- 1
- 9
- 16
1
vote
2 answers
How do I Sequel Pro with PuPHPet?
I have just set up a virtual machine using Vagrant and Puphpet. I know I have MySQL because I can mysql in the command line. I just did a basic install.
I don't know how to set up my sequel pro to get access though. I am using the "Standard" option…
mikelovelyuk
- 4,042
- 9
- 49
- 95
1
vote
1 answer
Insert into a many-to-many table based on current row information
I have a many-to-many table of products and models ids. Is it possible to insert new rows if the ids match in another row?
Example Table:
| p_id | m_id |
+------+------+
| A | 2 |
| A | 3 |
| B | 1 |
| B | 2 |
| C | 1 …
Ian Davis
- 63
- 1
- 4
1
vote
4 answers
MySQL VARCHAR Type won't CONVERT to Integer
I have a column of data of type VARCHAR, that I want to CONVERT or CAST to an integer (my end goal is for all of my data points to be integers). However, all the queries I attempt return values of 0.
My data looks like this:
1
2
3
4
5
If I run…
Daniel
- 2,345
- 4
- 19
- 36