Stack Overflow
Stack Overflow

Questions tagged [sequelpro]

Graphical sql browser for Macs

A graphical user interface for database management on OSX.

241 questions
5
votes
1 answer

Exporting table with SequelPro into csv file

I'm trying to export a MySQL table into csv file using SequelPro, however the result file is not properly formatted. For instance, on the first column should the id, in some of the records there is a number, but in others there is text instead. This…
WagnerMatosUK
  • 3,861
  • 5
  • 45
  • 84
5
votes
3 answers

How to change a string to a date during import using Sequel Pro?

I'm trying to import a file into a MySQL table using Sequel Pro. I know I need to use STR_TO_DATE, but I can't figure out the right syntax. I'm getting a bunch of these errors for each row: [ERROR in row 1] You have an error in your SQL syntax;…
Tim Elhajj
  • 625
  • 1
  • 8
  • 16
5
votes
1 answer

Can't connect to MySQL

I'm trying to connect to MySQL, using Sequel Pro, something I have done many times before. Host 127.0.0.1, username root, no password. I get the following message: Unable to connect to host 127.0.0.1 because access was denied. Double-check your…
japem
  • 869
  • 3
  • 13
  • 27
4
votes
3 answers

How do I import data from a csv to SequelPro?

I have a small data file and I'd like to analyze it with SequelPro. I have it connected to a MySQL server running on my computer. When I try to import, the Import button is just greyed out.
Sebastian
  • 817
  • 1
  • 9
  • 21
4
votes
2 answers

Disable Strict mode in Sequel Pro

How to disable mysql strict mode in Sequel Pro on Mac? I got this error sql_mode = only_full_group_by. Been trying to find the solution, but nothing helps. Plss help!!!
Syamim Hazmi
  • 61
  • 1
  • 7
4
votes
2 answers

Import null and improperly formatted datetime values into datetime column MySQL

I'm using a MySQL database with the Sequel Pro interface, and am new to SQL. I'm attempting to import data from a csv file and one of the columns I am importing into is of type datetime. However, the format I receive the data in is mm/dd/yy hh:mm…
djar
  • 69
  • 1
  • 9
4
votes
1 answer

getting started with loops and iteration in sequel pro

I'm using sequel pro to select data from several tables. There are two things I need to do that seem to need a loop of some kind. I have never used any form of iteration in sql and can't find a beginners-level resource to learn from. Can anyone…
AJDncnsn
  • 51
  • 1
  • 3
3
votes
1 answer

I can connect to DB through Sequel Pro, but not through command line

I can connect to my db with Sequel Pro just fine, but I can't through the command line. I've followed their instructions here:…
Kaleidoscope
  • 3,489
  • 1
  • 23
  • 21
3
votes
1 answer

Does MySQL support the bracket wildcard?

I tried using the brackets wild card and nothing came up. I'm using SequelPro (and I think that uses MySQL, though I could be wrong). Does it support the bracket [] wildcard? If not, what can I use in it's replacement? Here's an example -- SELECT…
Sebastian
  • 817
  • 1
  • 9
  • 21
3
votes
4 answers

Laravel/Homestead - can't connect to the DB

I have installed homestead on my machine and cloned a project from a remote repository, now I am trying to create a DB for my project. This is how my .env file looks…
Leff
  • 1,744
  • 11
  • 63
  • 133
3
votes
0 answers

Unable to connect Sequel Pro with mysql docker container

I feel like this should be an easy fix but I can't seem to figure this out. I just installed docker and ran: docker run -d --name test-mysql -p 3306:3306 -e MYSQL_ALLOW_EMPTY_PASSWORD=yes -e MYSQL_DATABASE=test mysql I did this to create my first…
Ghostdragon777
  • 53
  • 3
3
votes
1 answer

How can I connect to a local sqlite3 database?

I'm running a local node.js app on localhost:3000. It has a database named database in a file called db.sqlite. I tried to connect to the database with the host localhost:3000, but sequel pro says MySQL said: Unknown MySQL server host…
Himmators
  • 12,918
  • 30
  • 111
  • 198
3
votes
2 answers

Converting VARCHAR column to INT in MySQL / Sequel Pro

I'm trying to set the column in my database from VARCHAR to INT (values are already in DB) When doing this action, the following happens (example): | number (varchar) | number (int | | 20090911913 > 2147483647 | | 3009092113 > 2147483647…
Orion
  • 227
  • 1
  • 4
  • 13
3
votes
4 answers

vagrant sequel pro SSH Tunnel remote host can't connect, bad password

I'm new to MySQL and Vagrant and spent several hours trying to set both up. I can connect to MySQL from the command line with: mysql --host=127.0.0.1 --user=root --password=[my_password] I'm trying to connect with Sequel Pro and following a couple…
KM617
  • 137
  • 2
  • 15
3
votes
0 answers

Kitematic + MariaDB + SequelPro

I'm recently using Kitematic (Docker), Struggling between Vagrant and Docker. Working with Docker and Kitematic is smooth, I can create, initiate a DB via Console. But If I want to manipulate the db via sequel pro, or just import from local, I…
Locke
  • 542
  • 4
  • 19
1
2
3
…
16 17