I am trying to figure out what would be the most efficient way of achieving the following: I have two tables: word_translations(id, word_id, language_id) and translations(id, text, word_translation_id, created_at, updated_at, user_id) So there is a one-to-many relationship between word_translations and…
Here is a question concerning a basic DB query in PostGres. I have two tables created as follow: => create table Prix (rank integer primary key, value bigint unique); CREATE TABLE => create table Pris (rank integer primary key, value…
I am trying to parse this sql query using spring data jpa to use in my application. It is a postgresql qurey using some of the geospatial functions using postgis. This query is basically trying to find all the records…
I have two simple queries below: SELECT * from table_name where status IN (0, 1, 2, 3, 4) SELECT * from table_name where status NOT IN (5, 6) The possible value of status is 0 to 6, and column status…
I have an entity that has, among other things, two jsonb columns : "options" and "features". I want to copy data from a field inside the options column to a two levels deep field inside features. What I've tried :…
I have two tables, one is products and the other is varients. In product table I store product basic data such as name, image, brand, etc. In varients table I store variants of product such as 1kg, 2kg, 5kg, etc…
I'm trying to create a summary report of sales per year with a couple of tables like the following: products id (PK) [... ] Orders id (PK) date product_id (FK to products I've written a query where I select from…
Working with PHP and SQL here. I have a bridging table in my database that has columns with separate options (option 1, option 2, etc) and another table with the information of each option. This is because the result may…
I need to update the value of pm_virtual.meta_value = 'no', only for those products that have pm_downloadable.meta_value = 'yes'. How do I do this? SELECT p.ID, p.post_title, pm_downloadable.meta_value AS downloadable_trait, pm_virtual.meta_value AS virtual_trait FROM xhdps_posts AS p INNER JOIN xhdps_postmeta…
I have a table of data with multiple columns and containing a column named 'weight' set to VARCHAR character type. It contains a mix of characters such as '400', '203.12', and '602.35 grams', and NULL values. Task is to clean…