Let's say I have two tables with these data: author id | name --------- 1 | John 2 | Jack 3 | James 4 | Bob 5 | Gorge book id | author_id | title | state ------------------------------------- 1 |…
Hi have a table that has Owner ID which is a array of users. Below is my tables. Task table ID Task_Name Task_Owner 1 Create 1,3,4 2 Edit 2,1,3 3 Delete 2,1,4 Owner table: ID Owner_Name 1 Mike 2 Ken…
There is a table in PostgreSQL database which stores data about words from a book and pages where those words occur. Something like this: headword | dict_pages | timestamp_updated ----------+------------------+------------------------ abcdefg | {229} | 2023-07-28 14:49:13+00 ccdsd | {213} |…
I want a query that retrieves the result of values if it doesn't exist. Example: select * from the table.A where column1 in (1,2,3) If 2, 3 values exist then I will get 2 and 3 as a result. But…
Is postgresql can do average for rolling data? I have this case where I need to average the values for 5 days and get all the days filled up while waiting for the actual values so basically if I'm in…
I have the following table_1 which shows the time each person in Room_A. person start_time end_time John 5 16 Mary 7 10 Peter 8 12 Then I want to have an output table which shows the time and the people…
I have two tables time_info and category. I want to update the temp_id of time_info table whenever there is insertion of record or update of duration column of time_info table. Here is the schema time_info id name - text duration…
# index: `review_count`, `store_id`, `status`, `name`, `address` EXPLAIN ANALYZE SELECT store0_.name, store0_.status, store0_.name, store0_.address, category1_.name from store store0_ inner join category category1_ on store0_.category_id=category1_.category_id left outer join store_keyword storekeywo2_ on store0_.store_id=storekeywo2_.store_id left outer join keyword keyword3_ on storekeywo2_.keyword_id=keyword3_.keyword_id where store0_.review_count…
Am trying to fetch the data from the database into the WordPress plugin via SQL query. However, the loop is not working even though it is not showing any error. I tried many things on the internet but nothing of…
Why this SELECT "»" REGEXP "^[-а-я]*$" SQL statement returns 1 (true). Symbol "»" doesn't match this regular expression. In other case, it works correctly with symbol "«": BINARY after REGEXP doesn't resolve problem