I need to create an INSERT INTO ... WHERE NOT EXISTS ... SQL query that works on both Postgres and Oracle. Unfortunately, since oracle does not support SELECT statements without FROM I'm struggling to get this query to work. I…
I am trying to display data from the SQL table onto the html page My data is a MEDIUMBLOB type data main.py @app.route("/text") def text(): def generate(): if 'name' in request.form: cursor = mysql.connection.cursor(MySQLdb.cursors.DictCursor) name = request.form['name'] here = cursor.execute("SELECT…
PostgreSQL has SETOF <sometype> type according to the doc and SETOF <sometype> type is used in a function as shown below: -- ↓ ↓ ↓ Here ↓ ↓ ↓ CREATE FUNCTION my_func() RETURNS SETOF <sometype> ... Now, I want to…
I'm fairly new to SQL and have an exercise I'm trying to figure out how to translate a YEAR column into the following conditions: YEAR is 1 if student is registered in courses 1009 & 1029 YEAR is 2 if…
I am trying to insert a txt file into mysql table but it is not working. I have tried using LOAD_FILE but it gave me an error code - MySQLdb.IntegrityError: (1048, "Column 'transcript' cannot be null") cursor.execute("insert into `movies` (`movie_name`,`movie_file`,`movie_password`,`transcript`)…
My question is that how many times will COUNT(*) be called for each group? Three times or just one time? If the answer is three times, how can i optimize it. SELECT COUNT(*) AS num1, COUNT(*) / 10 AS num2,…
I have an issue between two tables in sql Table 1 name_id 1 2 3 SPEC-A 100 110 120 SPEC-B 200 220 230 Table 2 name name_id cat M.John SPEC-B 2 J.Smith SPEC-A 3 So I would like to connect…
I wrote two queries and thought they would give the same result, but it didn't happen. Could you please explain to me why? 1) SELECT date, COUNT(DISTINCT user_id) FROM (SELECT user_id, date(time) as date, COUNT(order_id) FROM user_actions WHERE order_id NOT…
Mysql 8 takes 2 minutes to sort an empty set The following table on 8.0.33 MySQL Community Server CREATE TABLE `eventiAcc` ( `chiave` int NOT NULL AUTO_INCREMENT, `tipo` tinyint NOT NULL, `account` int DEFAULT NULL, `utente` int DEFAULT NULL, `timestp`…
Some background: I'm running the following simple select statement on Postgres 15.3 server with 128GB memory, and contrary to my belief it takes ~6 minutes. The statement in involve two relations, big_table_70m with approximately 70M rows and other_table_50m with a…