Stack Overflow
Stack Overflow

Questions tagged [popsql]

A Collaborative SQL editor for teams available for Mac, Windows, and Linux.

PopSQL allows teams to share SQL statements, organize them in folders, and keep a version history of them.

It also allows the team to visualize resulting data and metrics using charts.

It features autocomplete, inpection of an existing database schema, SSH tunnel support, and data export.

PopSQL supports multiple relational database engines such as Oracle, PostgreSQL, SQL Server, MySQL, BigQuery, Redshift, Snowflake, and SQLite. It also supports noSQL databases such as Cassandra and MongoDB.

60 questions
5
votes
6 answers

SQL code not running , getting a "permission denied for schema public" error message

CREATE TABLE student ( student_id INT PRIMARY KEY, nam VARCHAR (20), major VARCHAR (20) ); I'm just running this code and I keep getting a permission denied for schema public message. What does this mean and how can I fix it.?
noobguy
  • 115
  • 1
  • 1
  • 5
3
votes
5 answers

PopSQL error when testing connection: Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)

I am new to using SQL and MySQL. I recently installed MySQL Server 8.0.27 on Windows 10. Everything appeared to be going fine at first, since I started the server for port 3306 (I checked on services and the status says 'running') and ran the…
Akash Gupta
  • 31
  • 1
  • 1
  • 2
2
votes
1 answer

SQL Error: permission denied for schema public

So i went ahead for the 4 Hour SQL tutorial and really followed the video - failed on first task, not sure why - Using PopSQL Im suspecting the difference in colour of INT and PRIMARY KEY might be indicative, not sure how to fix Error: permission…
afirdaus04
  • 35
  • 1
  • 6
1
vote
1 answer

I get ER_PARSE_ERROR when trying to CREATE a TABLE with PRIMARY KEY and FOREIGN KEY

I'm learning SQL and from time to time I get this error: ER_PARSE_ERROR. For example: `CREATE TABLE branch_supplier( branch_id INT, supplier_name VARCHAR(40), suply_type INT, PRIMARY KEY(branch_id, supplier_name), FOREIGN…
Adrià Martínez
  • 33
  • 6
1
vote
1 answer

Can't connect to MySQL DB remotely

I keep trying to connect to my MySQL Database use POPSQL, and I keep getting the error code ECONNREFUSED (Error Connection Refused) M.Y.I.P:3306, and I can't figure out why. The set up is a follows: I'm running Plesk, on Cent OS, which uses a MySQL…
Ethan Lindsey
  • 39
  • 8
1
vote
4 answers

PopSQL error: Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)

I am new to using SQL and MySQL. I recently installed MySQL Server 8.0.25 on Windows 10. Everything appeared to be going fine at first, since I started the server for port 3306 (I checked on services and the status says 'running') and ran the…
Jalexander
  • 29
  • 1
  • 2
1
vote
0 answers

Run time input in MySQL

I have emp_table(table) having employee details. The query goes as follows. SELECT * FROM emp_table WHERE job = 'input()' I have to give input at run time to select a certain kind of JOB details my code was: SELECT * FROM emp_table WHERE job =…
Ram Prabodh Induri
  • 95
  • 1
  • 11
1
vote
0 answers

PopSQL and Command Line Client returns different result

So originally my question was - 'How to prevent duplicates between two columns, using one table?' I tried to check the same query via Command Line and it returned different result. Maybe I need to change the SQL editor? What is the problem here in…
Anton Ionov
  • 21
  • 1
  • 4
1
vote
2 answers

In SQL Server getting month or date using LIKE and Wildcard Characters gives error

I was trying to find customers born in month of december from a table customers using this query : SELECT * FROM customers WHERE date_of_birth LIKE '____-12-%' ; But it throws an error : ER_WRONG_VALUE: Incorrect DATE value: '____-12-%' The type…
Sunny Nehra
  • 11
  • 5
0
votes
1 answer

Should I be entering my table data before or after I create all the tables and how I want them linked together using foreign keys?

enter image description here I am attempting to create and link four tables. I have attached the screenshot for the tables. I begin my process as such: CREATE TABLE employee ( emp_id VARCHAR(40) PRIMARY KEY, emp_name VARCHAR(40), salary…
sullivan11342
  • 1
  • 2
0
votes
0 answers

Incorrect Integer Value SQL

I am new to SQL and using PopSQL for editing, I incourtered to an error "Incorrect Integer Value" while connecting the database with .csv file. After some search I came to know that maybe the column is string and I am using INT command for it. But…
hassaanullah 2000
  • 1
0
votes
0 answers

Getting error on PopSQL when trying to connect to MySQL database

I am currently doing the SQL tutorial with freecodecamp.org on YouTube. I've been having a lot of trouble with the setup of everything. I'm currently trying to connect PopSQL to the MySQL database I created. I haven't been able to find any solution…
Casualrobe
  • 1
  • 1
0
votes
1 answer

Trying to find all of whiskey sales from a certain store -SQL-

I want to find the total sales of Whiskeys at a certain store in the dataset Here's my code (Using PopSql connected to bigquery) SELECT DISTINCT category_name, ROUND(SUM(sale_dollars)) AS Total_Revenue FROM Liquor_Sales.Iowa WHERE store_name =…
Caleb Pool
  • 3
  • 2
0
votes
0 answers

Why is the code running properly when it shouldn't in PopSql?

CREATE TRIGGER my_trigger BEFORE INSERT ON employee FOR EACH ROW BEGIN INSERT INTO trigger_test VALUES('added a new employee'); END; The above code works fine in pop sql but it shouldn't work because the delimiter by default is ';' and you can't…
Shivam Tanwar
  • 1
0
votes
2 answers

How do I get column names of two tables at a time

How do I get the column name of two tables in a single query ? SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS where table_name = 'table_name'; This works for single table. But if I try SELECT column_name FROM INFORMATION_SCHEMA.COLUMNS…
Shridhar
  • 5
  • 3
1
2 3 4