I have a table with b-tree index on column A (non-unique). Now I want to add a check for uniqueness of column A and column B combination when inserting, so I want to add a unique composite index (A, B).…
I have a table with an item, its cost and the date it was added. CREATE TABLE item_prices ( item_id INT, item_name VARCHAR(30), item_price DECIMAL(12, 2), created_dttm DATETIME ); INSERT INTO item_prices(item_id, item_name, item_price, created_dttm) VALUES (1, 'spoon', 10.20 ,…
I'm trying to build a pandas df with an SQL postgres timescale db query and this works below but the problem is the query builds an enourmous file for the one point I am after /5231/REGCHG total_power. The data has…
I have 3 tables: customers (CustomerID) orders (OrderID, CustomerID) orders_products (OrderID, ProductID) I need to select each customer with their total orders and total number of products ordered by them. To count total orders by each customer, the query is:…
Mysql version: 8.0.21 I am lookig of get the latest value of each "TableData" which has the type "fruit". Table Name: TableNames _________________________________________ | id | name | id_group | type | |-----------------------------------------| | 0 | AppleGroup | apple |…
the query is CREATE TABLE order( order_id int primary key, customer_name varchar(30) not null, product_name varchar(20) not null, date_ordered date, quantity int, unit_price float, phone_no varchar(20) ); the error is : ERROR 1064 (42000): You have an error in your…
I am trying the following Postgresql query with Prisma's $executeRaw function. But it is not returning the values inserted. Instead only returning the number of records inserted. await prismaClient.$executeRaw(` INSERT INTO table1 (name, place, animal, thing) SELECT * FROM table2…
I have the following tables in a MySQL database: team team_id name 3 Rangers 12 Capitals 19 Red Wings 4 Bruins 212 Avalanche 102 Flyers 20 Islanders 50 Sabres 7 Stars player id name 2 Zach 1 Deb 17 William…
I have a MySQL query which should count the amount of replies to your comments with relations to other columns. I try to "relate" two columns together but can't figure out how to create a correct query. The table somewhat…
First of all, sorry for bad title - I can't figure out how to write generalized formulation of my problem. I have a table in PostgreSQL with users and dates of their internships. It looks like this: user_id start end…