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
0 answers

Out of range value for column 'release_d' at row 2

First time to ask a question. Will do my best to follow the tips: UPDATE albums SET release_d = 1800 WHERE release_d < 1980; or UPDATE albums SET release_d = '1800' WHERE release_d <= '1980'; I receive the error…
Paula
  • 21
  • 1
  • 4
0
votes
2 answers

Select from table where in other table most efficient way

I have a list of ID numbers as one table in my mySQL database; I have a second table that has From_ID, To_ID, and Frequency columns. I'd like to make a third table that has the same structure as the second, but with only those rows for which the…
Pete Ludlow
  • 121
  • 1
  • 1
  • 8
0
votes
0 answers

Using 'Group By' Twice in Sequel

All, I'm using the following Sequel query... select u.full_name, u.id, sum(hit_count), tag_names from MyTable as t inner join MyUsers as u on u.id=t.user_id where t.created_at >= '2015-1-01 04:00:00' AND t.created_at < '2015-2-01 04:00:00' AND…
Greg
  • 1,264
  • 14
  • 21
0
votes
1 answer

SQL Join query that selects rows and checks if they exist in another table

Not sure if this is possible in a single query but looking to do this directly in SequelPro. I have a table containing cars, and if they are sold or live. I also have another table which is called data_store and contains some information about those…
Lovelock
  • 7,689
  • 19
  • 86
  • 186
0
votes
2 answers

SQL - return records with multiple categories

I am relatively new to using group by and aggregate functions in SQL, I have the following tables: CREATE TABLE `artists` (`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, `name` VARCHAR( 100 ) NOT NULL ); CREATE TABLE `genres` (`id` INT NOT NULL…
jagfiend
  • 3
  • 4
0
votes
2 answers

Mac OS Yosemite : How to start mysql and connect Sequel Pro?

I have just installed MySQL using the installation documentation. MySQL is installed in the directory /usr/local as indicated in the documentation. I attempted to start MySQL using the following command on the command…
Pracede
  • 4,226
  • 16
  • 65
  • 110
0
votes
0 answers

Can't delete child records with trigger on Sequel Pro

First I want to say I've never tried using triggers before, and I read a lot of information to do this. What I want to do is delete all records from gallery_assets_meta where its parent_id is equal to gallery_assets.id. This was what I tried on…
rafaelmorais
  • 1,323
  • 2
  • 24
  • 49
0
votes
1 answer

Mysql Find users that are part of two differnt projects

I'm searching my submission fields for users that signed up for two different projects. This is what I have, that is not working correctly. Any help would be great! SELECT user_id, COUNT(*) FROM submissions WHERE project_id = 125 or…
Steven P
  • 1
0
votes
1 answer

Sequel Pro - How to reading in Characters like Ö, ü, ç, ñ, ß

I am reading in data to MySQL using Sequel Pro but it won't reading in special characters like Ö, ü, ç, ñ, ß. I tried Western ISO Latin 1, that doesn't work. I also tried Western DOS Latin 1, that actually converts these characters to something…
PMa
  • 1,751
  • 7
  • 22
  • 28
0
votes
1 answer

How to edit an existing index in Sequel Pro?

Is there a way to edit an existing index in Sequel Pro (Mac OSX)? In the Indexes pane, I only see a plus (add) and minus (remove). I can't seem to modify any of the existing indexes, such as renaming it or adding more columns to create a…
prograhammer
  • 20,132
  • 13
  • 91
  • 118
0
votes
1 answer

MySQL date range query working in Sequel Pro but not in PHP (DataTables)

I have a query that successfully returns results using the sequel pro app on OSX: WHERE `LastReported` BETWEEN "24/06/2014" AND "31/07/2014"; My date field in the database isn't a proper date field, it's a VARCHAR field with dates (populated from a…
BSUK
  • 692
  • 1
  • 12
  • 28
0
votes
2 answers

SQL Querying multiple tables throwing syntax error?

I was hoping someone could help me figure out what I am doing wrong with a SQL query I am trying to run from within Sequel Pro. The error message says You have an error in your SQL syntax; check the manual that corresponds to your MySQL server…
J Gegs
  • 3
  • 2
0
votes
1 answer

Can't connect to localhost MySQL database through command line?

Weird issue. Can't connect to localhost MySQL database from command line, but I can through MySQL program, Sequel Pro. Any ideas why? I entered the same user/password, but I'm getting a access denied error for root@localhost Extra question: can you…
blunatic
  • 325
  • 2
  • 6
  • 16
0
votes
1 answer

`INSERT` is only inserting a single row

I've been happily using SequelPro in place of phpMyAdmin to access my local database. I've inserted hundreds of rows into some tables without a glitch. Now I can't insert more than a single row into any table - even using the same INSERT script I…
emma
  • 784
  • 2
  • 9
  • 23
0
votes
3 answers

Greater than (>) not working in mysql query

I'm trying to run a query on my WordPress database to get a list of all posts and some other data from a certain month. I'm running into an issue with post_date, where looking for posts before a certain date works fine, but looking for posts after a…
hookedonwinter
  • 12,436
  • 19
  • 61
  • 74
1 2 3
…
16 17