I'm currently working on a PostgreSQL query to extract specific values from a JSONB column. Here's the query I'm using: select a.id, (jsonb_array_elements(a.info->'attribute1')->>'value') as attribute1, (a.info->>'attribute2') as attribute2, (a.info->>'attribute3') as attribute3, (jsonb_array_elements(a.info->'attribute4')->>'value') as attribute4 from a_table a where (cast(a.info->>'attribute3' as…
I have a problem as follows; Let's say I have 3 tables like this: tableA ID_name Name Email 1 Alice xx 2 Betty xx 3 Chris xx tableB Id_task id_name Tasks_submitted 1 1 1 2 2 1 3 1 1…
I made a windows desktop application using electron. I connected my program to mysql. However, in order to connect to the database, I had to specify the account credentials such as username, password, host, port, and database name. I read…
Below is the query: I got this query over internet while searching to sort comma separated values in a single column SELECT id, title, GROUP_CONCAT(aNumber ORDER BY aNumber) FROM ( SELECT id, title, CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(numbers, ',', tens.acnt * 10 + units.acnt…
I have a mysql database and i want to insert values similar to this one 12,3456.78. I tried using the float and double type but the result is rounded to 12 and using decimal is still not helping, i get…
Sorry for the poorly worded title. I just don't know how to phrase it succinctly. UPDATE: Reframing my question I decided to reframe my question because in responding to a comment, I realized that this question could be asked in…
I am working with a PostgreSQL database where I have a query that unions 5000 tables with identical structures. The query is saved as a view. I've noticed that the planning time for this query is significantly longer than the…
I try to use SELECT in echo because I make while loop and I want to SELECT id in table account so I will use this data inside form here is some of my php code: $sql = "SELECT *…
I am looking to group users into separate groups based on when they bought something. A new group starts after it's been more than 90 days when the user last bought an item. Example of what I am looking for:…
I want to update my dataset and use the GEOMETRY datatype instead of using latitude and longitude. The problem is I have set a geo column in my table with the datatype yet I can't put my data in it.…