Lets say i have products table It have regular things but it also have image or collection field Good if product have only one image or collection But product could have multiple images like img1 img2 img3 etc How can…
if have these tables : orders(amount,unit_price,child_amount,child_price,service_id,issue_date,is_success) pools(name,for_view) services(id,pool_id) when i run this sql : SELECT SUM(orders.amount) AS totalAmount, SUM(orders.unit_price) AS totalPrice, SUM(orders.amount*orders.unit_price) AS total, SUM(orders.child_amount) AS totalAmountC, SUM(orders.child_price) AS totalPriceC, SUM(orders.child_amount*orders.child_price) AS totalC, pools.name, pools.for_view FROM orders INNER JOIN services…
Assume I have two tables a and b, each containing a series of dates: Table a: day_date 2020-1-1 2020-1-2 2020-1-3 2020-1-4 2020-1-5 2020-1-6 2020-1-7 2020-1-8 2020-1-9 2020-1-10 and table b: id some_date 0 2020-1-3 0 2020-1-6 0 2020-1-8 1 2020-1-2…
I have generated the following table from SQL database: First_User Second_User Count User1 NULL 427 User3 NULL 69 User2 NULL 499 User1 User1 1 User4 User2 48 User5 User2 13 I want to create this table from the above table:…
Hi im not a native speaker and im not into sql language. I can do some standard queries like select * from table... update and so on but have no expierience in deeper sql questions. plz ort gemeinde 1000 uttenthal…
I made a mistake when defining a unique key in one of my SQL tables, and this has resulted in duplicate rows of data being entered into the table. The rows of data look like this: A, B, C, D,…
I have a table that has daily data and thousands of rows per day: create table my_table(visitors_count int, dt date); select setseed(.42); insert into my_table select (random()*100)::int, current_date+(-random()*14)::int from generate_series(1,42000); However, some days are not present due to holidays: delete…
In our DB we have tables, that have 6-8 M records, this data is static and in order of performance optimization we decided to store some data from this tables in separate table, and for predefined filters use the values…
DBMS: PostgreSql, but MySql is acceptable as well I have 4 tables, permissions id slug allowed 1 create true 2 edit true 3 delete true 4 edit false roles id slug 1 Admin 2 Manger 3 User model_permissions model_type model_id…
This query returns the desired result: Select * from media This query returns 0: select id from media where conc_title = 'origin of life' conc_title has the type varchar and the entry is in the db. these modifications don't work…