Stack Overflow
Stack Overflow

Questions tagged [sequelpro]

Graphical sql browser for Macs

A graphical user interface for database management on OSX.

249 questions
0
votes
1 answer

Mysql UPDATE Query error: Unknown Column in 'field list'

I am trying to add a new column by using the following query: UPDATE t1 INNER JOIN (SELECT t1.CID as t1_id, t2.id as t2_id FROM t3 INNER JOIN t1 ON t3.CID = t1.CID INNER JOIN t4 ON t4.MID = t3.MID INNER JOIN t2 ON…
Cherry
  • 971
  • 1
  • 10
  • 20
0
votes
0 answers

Importing a WordPress database onto a VPS

I am moving a website from shared hosting to a VPS but I am unable to import the database correctly as I am getting a 500 error on my website. I will list the steps I have taken below, please could you check that I am not missing anything,…
Reece
  • 2,581
  • 10
  • 42
  • 90
0
votes
1 answer

Creating and Linking a Database using Sequel Pro

I am in the middle of transferring my website over to a Digital Ocean VPS from a Heart Internet reseller account but I am stuck on trying to get my old database to link to the new wordpress install. At the moment I am stuck on the following…
Reece
  • 2,581
  • 10
  • 42
  • 90
0
votes
2 answers

Connecting to Sequel Pro with Homestead issues

I have been checking out a lot of answers here and on GitHub regarding this issue, but whatever I try there is always something wrong. I also don´t get why with the same credentials sometimes I am able to connect other times I am not even able to do…
Code Worm
  • 313
  • 1
  • 4
  • 16
0
votes
0 answers

How to configure local MySQL connection (Sequel Pro & Laravel)?

I'm building a Laravel project and I've been trying for the past week to connect to MYSQL through Sequel Pro. I've tried tens of different combinations of host, username and password, to no avail. I have tried using localhost instead of 127.0.0.1…
bob
  • 466
  • 1
  • 7
  • 27
0
votes
1 answer

Save MySql function on Sequel Pro MariaDB

I have a function that works inside my script but when I try to run it on my Sequel Pro MariaDB to add it to the function list, I get a bunch of errors. drop function if exists related_count; create function related_count(parent int(11)) returns…
Maciek Semik
  • 1,872
  • 23
  • 43
0
votes
1 answer

Mysql query - insert from CSV conditional to comparison between table and CSV

I'm a rather newbie when it comes to SQL queries and not sure how to approach this: I have a CSV file that contains 5 columns, 2 of those columns are Value1 and Value2, I need to run over an existing sql table (for this question's purposes I'll call…
user51929
  • 185
  • 1
  • 15
0
votes
1 answer

MySQL said: Can't connect to MySQL server on '127.0.0.1' (4)

the above problem has few solutions here but I couldn't get any of them working so asking. I have installed mamp and also sequel pro. I am trying to connect using sequel pro but I am getting this error. The whole error is Unable to connect to host…
Hkm Sadek
  • 2,987
  • 9
  • 43
  • 95
0
votes
0 answers

MAX function in Aurora MySQL 5.6.10a

I am launching this query using Sequel Pro: select MAX (price) from t_hotel_price group by hotel_id but I got this error FUNCTION hotels.MAX does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual
Ramon De Les Olives
  • 657
  • 2
  • 6
  • 8
0
votes
1 answer

Connecting to AWS Aurora MySQL using Sequel Pro

I've just created a AWS Aurora MySQL with this end point: tdk.cwob1oxhu1so.eu-central-1.rds.amazonaws.com DB instance: tdk which I want to connect from a Sequel Pro client So I put tdk.cwob1oxhu1so.eu-central-1.rds.amazonaws.com in the Host, the…
Nuñito Calzada
  • 4,394
  • 47
  • 174
  • 301
0
votes
2 answers

Why doesn't my WHERE clause work when defining my function in MySQL?

Can anyone help me understand why when I run the following: DELIMITER // CREATE FUNCTION dbo.Profit (P_ProductID int, P_VendorID int, P_SellPrice decimal (12,4)) RETURNS decimal (12,4) DETERMINISTIC BEGIN DECLARE p_profit decimal (12,4) SET…
natehoffy
  • 1
  • 2
0
votes
0 answers

How to successfully import csv into MySQL using Sequel Pro

I'm pulling my hair out. I have a csv full of customer data, and am getting a number of errors when trying to import it into MySQL using Sequel Pro's Import function. ========== I'm importing with all the default options, encoding as latin1. The…
Zander F
  • 1
  • 1
  • 1
0
votes
1 answer

Syntax error when trying to run an IF EXISTS query

I am trying to run the below query (in Sequel Pro), but I am getting the following syntax error: '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 'IF …
BrianM
  • 115
  • 3
  • 11
0
votes
1 answer

Export SQL result to CSV but retain the newline values in fields

I am trying to export a query result into CSV via Sequel Pro and I want to retain its newline values. I tried escaping using REPLACE() and I also tried using other terminators such as ;. My content looks like this The word "adore" means to love…
Þaw
  • 2,047
  • 4
  • 22
  • 39
0
votes
0 answers

Cannot stop MySQL Server. Lost PID file?

When I put in mysql.server stop, I receive: ERROR! MySQL server PID file could not be found! I had this happen this morning, so I uninstalled SQL and deleted homebrew. And then, I reinstalled brew and reinstalled SQL. And it happened again. I just…
Sebastian
  • 957
  • 3
  • 15
  • 27
1 2 3
…
16 17