I built a woocommerce sql query to list all products with their important values. Here my query: SELECT p.ID, p.post_type as Art, p.post_title AS Produkt, p.post_excerpt AS Beschreibung, t.name AS Produzent, MAX(CASE WHEN pm1.meta_key = 'faktor' then pm1.meta_value ELSE NULL…
I have a table A, where data is a json column, and timestamp is a timestamp with timezone column: timestamp data 2023-08-29 13:00:00-04 { "a_123":{ "temp":85, "uv":5, "rain":0 }, "b_123":{ "temp":85, "uv":5, "rain":0 } } 2023-08-29 14:00:00-04 { "a_123":{ "temp":70,…
Im working on an employee management system using java and javafx. im just wondering ;in this project there's an admin part and there's an employee part. Employees will sign up and login then after logging in they enter their personal…
I have an array list of data I want to update to the inventory table. $data['items'] = DB::table('inventory_items')->select('inventory_items.*') ->join('sorder_parts', 'inventory_items.id', 'sorder_parts.inventory_id') ->where('sorder_parts.sorder_id', '=', $id) ->selectraw('inventory_items.quantity - sorder_parts.quantity AS new_quantity') ->get()->toArray(); foreach ($data as $product_item) { $reduce_quantity = InventoryItem::updateOrCreate(['id' => $product_item['items']['id']],…
I am trying to construct a SQL query that returns all the rows (id's) that have tag: 3 AND tag: 4 - in this case it is the single row for 564800, however I can't seem to figure out how…
I need to alter the Data Type of a named column (let's call them 'photo') across all the tables in a schema. For example: I have 300 tables with identical structure (except the data in each row of course). But…
I have a student list table. In the table, there is a column to display study programs. This column retrieves data from the study program database. However, what is displayed in the table is the study program id. What I…
I am trying to create a table and columns in the table and then insert data in the columns. I'm using pgadmin4. This is my query: INSERT INTO moon (ID, NAME, Age, Salary) VALUES (2, 'saqib', 4, 400) Error message:…
I need to estimate the size in GB of a table in a PostgreSQL database. I don't have the database yet (I need the estimate for cost projection purposes). The schema of the table will be: One column containing a…
The database used is PostgreSQL. I have a query that combines two tables and does a where search on some category and then does order by by some property. The table products has a 10+ million products. If I put…