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

SQL UPDATE statement from SELECT statement?

I have an id and abbreviation column in a table. I would like to update the abbreviation column in another database on another server.. I know how to get a SQL select statement, but how would I get an UPDATE statement from this that to run on the…
David542
  • 104,438
  • 178
  • 489
  • 842
0
votes
1 answer

MYSQL: Can't Select values although I know they are there

I'm dealing with this problem in my MYSQL database for several hours now. I work with OS X 10.8.4 and use the tool Sequel Pro to work with my database. The table I have troubles with looks like this: CREATE TABLE `Descriptions` ( `id` int(11)…
Marc U.
  • 63
  • 4
0
votes
1 answer

what does MYSQL-entries beginning with sha512:1000: contain?

I'm trying to reset a user-password in a database belonging to a codeigniter application. (though the app might not use standard Codeigniter encryption). Some of the values have been reseted to an alphanumeric value and some are manually set through…
Himmators
  • 14,278
  • 36
  • 132
  • 223
0
votes
1 answer

display results that match user input

I am trying to create a function that searches the database for stores that are located within the postcode entered by the user in a form by matching the first few letters for example, SW1. So basically: User inputs postcode in text box. User…
user2656943
0
votes
0 answers

How to set up a local MySQL user on a Mac on a Zend installation

I am trying to set up a user for a localhost database on my Mac. I created the database in localhost and imported the SQL. That works fine and I can log into localhost (the local installation of MySQL on my Mac via Sequel Pro) and see it. I think…
sehummel
  • 5,476
  • 24
  • 90
  • 137
0
votes
1 answer

Error in writing dynamic query in MySQL

I am new bee at RDBMS, I want to get a row from one of the five tables and the name of table is value of one of the fields of another table. So I am trying to store the value in one variable from one query and then using that value query again in…
user2391188
  • 3
  • 3
0
votes
4 answers

How to connect an iOS app to a database (mySQL & SequelPro)?

I'm searching for a way to connect an app with a database, created in Sequel Pro which is connected with a mySQL Server (started over MAMP). I've already searched for some solutions but there are hundreds of different posts, some said that SQLite…
RForce
  • 5
  • 1
  • 1
  • 2
0
votes
1 answer

How to create JSON string in Sequel Pro TEXT editor?

I figure this may be an unconventional way of creating a JSON string. But, I really need to just be able to make it right in "Sequel Pro" like this I want to be able to just edit it right there like that. But when I receive the string on the client…
brybam
  • 5,009
  • 12
  • 51
  • 93
0
votes
2 answers

MYSQL loop shows only first record

I'm trying to create a procedure with a loop inside, but when i call it just show the first record and dont interate. delimiter // create procedure load_foo_test_data() begin declare v_max int unsigned default 10; declare v_counter int unsigned…
Vertig0
  • 623
  • 3
  • 15
0
votes
2 answers

Sequel pro won't connect anymore

I'm running into some trouble right now. I worked yesterday on my db using sequel pro for TigerV1 (for an old OS X 10.4 powerpc). The problem is, this morning, sequel pro won't connect anymore. I deleted my "Favorite" and than retyped the…
Joel Gagnon-Lafrenière
  • 1
  • 1
  • 1
0
votes
1 answer

Cannot make foreign key field nullable with Sequel Pro

I'm having a defined relation to my user table as foreign key, but they don't necessarily need to be set. I.e. there must not be a related record. In my MySQL editor (Sequel Pro) I cannot make the addressId "allow null". It ignores the input. Im…
preyz
  • 3,029
  • 5
  • 29
  • 36
0
votes
1 answer

How can I delete a stored procedure on a table?

I have a table where I can't duplicate a row because one of the fields has a stored procedure, named items.calcPrice, on it that no longer exists. Here's the MySQL command: INSERT INTO items (folder_id) VALUES (56) the error message says, "Couldn't…
tim peterson
  • 23,653
  • 59
  • 177
  • 299
-1
votes
1 answer

Need to derive count of occurrence in Table 2 based on the results of Occurrence in Table 1 using sql query

Table_1 has order_id, country_id details table_ID order_id country_id 1 100 IN 2 200 USA 3 300 UK 4 400 IN 5 500 UK 6 600 UK 7 700 …
sql101
  • 3
  • 1
-1
votes
1 answer

How to find unique count of each value from a table?

How to count the occurrence of each city within a range? I am a beginner to SQL. I have a table like this: ID City 1 A 2 A 3 A 4 B 5 B 6 C 7 D 8 E 9 C Using the SQL query: select `city` from `table` where `id` between 3 and 9…
learning_always
  • 13
  • 1
-1
votes
1 answer

can not migrate using Laravel migrate

I bought new MacBook Pro,i install mysql in it, and then install sequel pro to view the table and database, but when I command php artisan migrate this error accuse error image almost last 30 hours I am suffering this Problem can any one help see
dhruvin prajapati
  • 184
  • 1
  • 3
  • 15
1 2 3
…
16
17