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

SQL Remove all characters between '[' ']' from entry

I am rather new at SQL and need to remove all characters between '[' and ']' and leave the remaining string behind. An example of what I am looking for is as follows: [test]hi -> hi I am assuming this is possible using a SQL command.
likwidmonster
  • 403
  • 1
  • 5
  • 18
0
votes
1 answer

Sequel Pro Trigger, updating calculated fields in a 2nd table

Ok so I'm putting together a finance database in Sequel Pro (the MySQL app for Mac). I've got a table that logs prices/stock-levels and I'll have a 2nd table that maintains calculated values like deltas (day-to-day changes) and eventually moving…
CalvinGraham
  • 11
  • 3
0
votes
1 answer

Sequel Pro Combine Multiple lines where only 1 column is different but the rest are the same

I have a table of meals and there are several id's associated with other tables on the main table. I have another table where the ingredients for the meals are listed by ids so that I don't have to type the ingredients over and over. But when I run…
Lauren Townsend
  • 5
  • 4
0
votes
1 answer

How do I find the average difference in two times from an activity log in sql?

So I have an activitylog column in review table Table screenshot with the contents similar to 2016-11-16 15:56:15 - Sent by author to LIGHT
2016-11-17 07:31:15 - Reviewed and forwarded to ALL
2016-12-17 11:28:31 -…
evkyee
  • 1
  • 3
0
votes
1 answer

MySql error assigning variables

I'm trying to write a script that will create smaller tables from a large parent tables. (I have no choice in this case.) However, it's been a while since I've had to do any serious SQL work and I'm stumped by what is probably something stupid...…
tobybot
  • 516
  • 5
  • 15
0
votes
1 answer

MySQL Table Trigger Correct Syntax

I'm trying to add a table trigger to MySQL DB using Sequel Pro. The behavior I want is this: Whenever a specific column in one of my tables is updated, I want to record the old value in another table so I can reference it later. I'm using the GUI…
Leigh Scherrer
  • 123
  • 2
  • 7
0
votes
2 answers

Delete Table Across Multiple Databases

Is there a way to delete a table across multiple databases using MYSQL? I am using Sequel Pro but don't see any option within the GUI to do this so I am wondering if there is some sort of command that can do this? The table name is the same across…
Cole
  • 317
  • 4
  • 14
0
votes
1 answer

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

I'm trying to import a CSV 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've tried this syntax STR_TO_DATE(@$1, '%d/%m/%y') which is not working. The CSV file format Date…
Manoj H L
  • 843
  • 9
  • 22
0
votes
0 answers

Sequal Pro: able to enter DB, but unable to read table

There are multiple databases on the server, after I enter the 1st db it does show the tables. The weird thing is that I required to get the data from the 3rd db, but after I choose it by the filter, it still shows the tables in 1st db. I figure out…
yimingStar
  • 53
  • 6
0
votes
1 answer

SQL query works in DB client but not works within the Laravel app

I have a custom SQL query that is loading perfectly fine within my Sequel Pro database application, however when this is loaded through my Laravel app I am getting an error on my web app. The error i'm getting it as follows : Syntax error or access…
Zabs
  • 13,852
  • 45
  • 173
  • 297
0
votes
1 answer

How to query specific values in sequel pro?

I'm using sequel pro to run some queries on a large database that I have. I am quite new to this so please excuse if my question is stupid or obvious. I have data from app users who have played a specific game (which in our database has value 32.…
Maheen Siddiqui
  • 539
  • 8
  • 19
0
votes
0 answers

Delete Same Table Across Many Databases

I currently run a large network of WordPress installs that utilize many similar plugins. I am attempting to cleanup some old tables but since each install has it's own database, I was wondering how I can utilize a query or Sequel Pro to achieve…
Cole
  • 317
  • 4
  • 14
0
votes
2 answers

TYPO3 Exception: No pages are found on the rootlevel

Unfortunately I couldn't find any help by googleing through the net. Here's my case: I'm trying to install TYPO3 locally on my Mac (OS 10.12.2) using Sequel Pro for the database and MAMP Pro for the host. For that I downloaded the .zip from…
Xandru
  • 13
  • 10
0
votes
2 answers

SQL Query Table doesn't exsist

When I am writing a query via Sequel Pro and format it like this a.TBL_ADJUSTMENT I get the following error Table 'a.TBL_ADJUSTMENT' doesn't exist. How can I write it so that I can label my tables with a letter/number?
Jess McKenzie
  • 8,345
  • 27
  • 100
  • 170
0
votes
1 answer

How can I export data view?

I have a view in phpmyadmin and I would like to download the table that the view creates in a SQL file. (click on view->export data->ok) But when I import the downloaded SQL file in Sequel Pro I get the error: [ERROR in query 7] You have an error in…
user2212461
  • 3,105
  • 8
  • 49
  • 87
1 2 3
…
16 17