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

Mysql prepare statement does not return anything. No syntax error. Why?

Scenario: I have a table in a mariaDB. It’s called “pages”. It just has three columns and a few entries for test purposes. Problem: I try to create a nice PREPARE statement in SQL. I did not get it working so I ended up with the following ‘simple’…
Matthi
  • 1,073
  • 8
  • 19
1
vote
1 answer

MySQL connection through jump server (Sequel Pro or Workbench)

Background: A client's site is hosted externally. Only whitelisted IP addresses can ssh to their server. My company recently moved into a shared space with a dynamic IP. I want to access mysql through sequel pro preferably. I've set up a jump…
Mullarkb
  • 143
  • 1
  • 3
  • 8
1
vote
1 answer

MySQL said: Access denied for user 'root'@'localhost' (using password: NO)"

I am trying to create a database with Sequel Pro and it keeps coming up with an error "Unable to connect to host because access was denied. Double-check your username and password and ensure that access from your current location is permitted. MySQL…
AltBrian
  • 2,392
  • 9
  • 29
  • 58
1
vote
1 answer

Unable to create stored procedure in mysql

I have created a stored procedure as follow : create procedure load_data() BEGIN DECLARE vcounter INT DEFAULT 0; while vcounter < 1000 do if vcounter % 2<>0 then INSERT INTO EMPDetails ( id, name ) VALUES ( null,…
Adam
  • 1,157
  • 6
  • 19
  • 40
1
vote
1 answer

Setting Decimal Datatype in Sequel Pro

I am new to Sequel Pro. I am trying to import a csv file that has longitude and latitude coordinates, but when the "CSV Import Field Mapping" window shows up, DECIMAL/FLOAT/DOUBLE is not one of the datatypes I can choose in the pulldown menu. The…
Cinji18
  • 619
  • 8
  • 22
1
vote
1 answer

Connecting to MySQL from Laravel vagrant box

I am using Sequel Pro on Mac and trying to see my database schemas that Laravel created. In the migrations folder I see a users and password reset tables. I am trying to see them in sequel pro which I do not. I used homestead and the vagrant box is…
cdub
  • 24,555
  • 57
  • 174
  • 303
1
vote
1 answer

SQL View only returns one row

I'm trying to create a view that returns the amount of courses each Californian student is enrolled in. There are 4 CA students listed in my 'Students' table, so it should return that many rows. create or replace view s2018_courses as select…
user8929613
1
vote
1 answer

How to connect to vagrant mysql database with Sequel Pro

How do I connect to vagrant mysql database with Sequel Pro? Specifically, ScotchBox 3?
LiveSource
  • 6,230
  • 4
  • 21
  • 20
1
vote
2 answers

Unable to connect to MYSQL container with sequel pro client

i am a newbie to docker and have bee struggling to connect to the docker container with sequel pro. I downloaded the image docker pull mysql/mysql-server:latest. And executed the command to run a container: docker run --name mysql-server -v…
EI-01
  • 1,075
  • 3
  • 24
  • 42
1
vote
1 answer

How to Create Lookup Field in Sequel Pro?

I have a table with a primary key lbxProgID. The FK is lbxClientID that references a clients table. zoom in of fields in question: Currently when I want to add an entry to this table, I need to know the actual integer ID of the client so I can add…
DW33
  • 11
  • 4
1
vote
1 answer

Docker - connecting to DB with sequel pro

I have installed a craft cms project with craftman which uses docker. Now I am trying to connect to the DB with sequel pro, but I can't. I have run the craftman ip command to get the ip of the docker container, which in my case was 172.17.0.2 and…
Leff
  • 1,968
  • 24
  • 97
  • 201
1
vote
1 answer

Unable to find or create new databases using Sequel Pro, but can using phpmyadmin

I am using MAMP Pro and I am having an issue where I cannot find existing databases on Sequel Pro, nor can I create new databases. However, on phpmyadmin, I can see and edit the existing databases and create new ones without any issue. I believe the…
Phrike
  • 91
  • 1
  • 2
  • 7
1
vote
0 answers

importing mysql dump method to find which line did it caused to fail

There are times that when you are importing a mySQL dump, it would break due to syntax, etc. Currently working on a very large database, running: mysql -u root -p database < import.sql will only verbose ERROR 1064 (42000) at line 116238: You have…
arvil
  • 840
  • 11
  • 27
1
vote
3 answers

First and second date from table in SQL

In SQL I am trying to extract the first and the second date from a table. I am using the query below which I formulated based on a number of posts I read on here about the same topic i.e. extracting the second date etc. But for some reason it does…
Maheen Siddiqui
  • 539
  • 8
  • 19
1
vote
1 answer

Can't add foreign key in MySQL Database

Trying to create a simple relation between two fields in two tables - 'Task' table with the field 'USER_TOKEN' and the 'USER' table with the field 'TOKEN'. The two fields are the same structure. As you can see the error and other things that may…
asaproG
  • 35
  • 1
  • 10
1 2 3
…
16 17