Graphical sql browser for Macs
A graphical user interface for mysql database management on OSX.
Questions tagged [sequelpro]
249 questions
0
votes
2 answers
Invalid use of group function (with no conditions)
The table looks like this:
| colA | colB | colC | colD |some other cols
-----------------------------
|double|double| int | int |some other datatyps
I want to select the sum of each column and group by them. At the moment I have no conditions…
nova
- 313
- 6
- 19
0
votes
0 answers
The SSH Tunnel has unexpectedly closed
This is beyond me and doesn't make sense. I have a newly created VM machine (vagrant) that I am trying to access via Sequel Pro I am able to vagrant ssh into the machine but when trying to connect with sequel pro i keep getting this message. SSH…
Rudy Jessop
- 872
- 1
- 11
- 23
0
votes
2 answers
Unknown Column Error on Update
I am experiencing some strange behavior on one of my tables that I cannot track down. Anytime I try to perform an update I get an Unknown Column Error
When I try to run:
UPDATE `bakerevents` SET `score`=300 WHERE `id`=2910;
I receive the following…
josh088
- 121
- 1
- 7
0
votes
1 answer
MySQL: Unknown column '%' in 'order clause' Error
The following (unabridged) MySQL query:
/* May Report */
SELECT db.prod.id AS "Prod. Spec. ID (TEST)",
db.prod.cycle_type AS "BiCode (TEST)",
SUM(db.prod.cycles) "Number of Cycles (TEST)",
db.instetail_d.id AS "Detail # (TEST)",
…
Mike
- 1,080
- 1
- 9
- 25
0
votes
1 answer
How to save query results column into a column in table in same database
I'm having difficulty copying the results of this query (a column titled "FIPminus") into a table starting_pitcher_stats that I have in the same database.
When I run the following code, the results appear as in the screenshot beneath the code below.…
LeeZee
- 107
- 1
- 12
0
votes
1 answer
MYSQL IN only returning first row
I have read several posts about similar issues but all of them were problems in the code while mine even occurs in the mysql sequel console.
my query: SELECT * FROM users WHERE id IN ("1,2") ORDER BY id DESC
My Users table currently contains two…
noa-dev
- 3,561
- 9
- 34
- 72
0
votes
1 answer
How can I combine two procedures in one to populate one table rather than each of the two procedures populating it's own table?
I created two tables that were each populated with a different procedure in MySQL with Sequel Pro. While each table has the correct information in it after running the respective procedure, I'm thinking that my data will be less scattered tables if…
LeeZee
- 107
- 1
- 12
0
votes
1 answer
Sequel Pro Connection to mysql server
I want to connect to my DO droplet via sequelpro. Therefore I took the following steps:
mysql my.conf
[mysqld]
...
bind-address = DROPLET IP
mysql
GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' INDENTIFIED BY 'password';
FLUSH ALL…
sesc360
- 3,155
- 10
- 44
- 86
0
votes
1 answer
Query works on Sequel Pro but not on my php script
This query works fine on Sequel Pro:
SELECT t1.* FROM `erapido_messages` t1
LEFT OUTER JOIN `erapido_messages` t2 ON `t1.sender_id` = `t2.sender_id`
AND (`t1.msg_date` < `t2.msg_date` OR `t1.msg_date` = `t2.msg_date` AND `t1.sender_id` !=…
Gabriel Ferraz
- 592
- 6
- 26
0
votes
1 answer
how can i combine my two queries
here is the first query
SELECT DISTINCT u.email, lastorder, datediff(curdate(),lastorder),
CASE WHEN datediff(curdate(),lastorder)<=29 then "<=29"
WHEN datediff(curdate(),lastorder)<=43 then "<=43"
WHEN datediff(curdate(),lastorder)<=60 then…
0
votes
1 answer
Sequel Pro for Mac - MySQL said: Can't connect to MySQL server on '127.0.0.1' (4)
I can SSH to my server and then connect to MySQL just fine using terminal. I use the same credentials in Sequel Pro and I get this message:
MySQL said: Can't connect to MySQL server on '127.0.0.1' (4)
I never had this problem before. It just…
gfrobenius
- 3,987
- 8
- 34
- 66
0
votes
0 answers
Trouble excluding matched values in SQL
I am trying to bring up potential name matches with keywords and then transfer the IDs from one table to the other. My issue is arising where I cannot filter out results from the ID table that have already been matched (and therefore have a matching…
Pierce Lieberman
- 1
- 1
0
votes
2 answers
Mathematical operations using MySQL
I want to do a couple of mathematical operations using different columns from different tables.
Say I have two tables A & B:
A
Value Size Pack
-----------------------------------------
234567 10 1
234589 20 …
theduker
- 21
- 6
0
votes
2 answers
UPDATE mySQL table using JOIN when two values match
I'm attempting to use the following code to JOIN my MySQL tables, TableA and TableB, when both their owner and pos columns match, setting TableA's val in the matching record to TableB's val:
UPDATE TableA A
JOIN TableB B
ON A.owner = B.owner AND…
amoeba
- 95
- 4
- 17
0
votes
2 answers
Created view loads every time I want to see the contents
I got a weird situation where each time I want to see the contents of a generated table view it starts loading the data instead of immediately showing the data.
When I use this query the data will be showed immediately:
CREATE VIEW train_set
AS…
Rotan075
- 2,567
- 5
- 32
- 54