Postgresql – Transfer table ownership
In Postgres, when a table owner, say "xxx" tries to transfer the table ownership to user "yyy", he is getting error ERROR: must be member of role "yyy" When I searched further, it can be fixed in two ways. As…
Mysql – Select count of same entries in different tables
I got 3 tables | ID | Name | |:---- |:------:| | 1 | Brie | | 2 | Ray | | 3 | James | Table2 | ID | Q_id | Q_no | ans | |:---- |:------:| -----:|----:| |…
Mysql – How to validate at least one checkbox is checked in a loop in Laravel?
I'm trying to validate my checkbox from a loop, where at least one is checked and displays an error/alert or disable the submit button instead if there is no checkbox checked. I tried putting a required method inside my checkbox,…
Mysql – Better way to select max values in multiple-column group?
Simplified the following question I got from a coding challenge... I have a table grades like: year sex person mark 2000 M Mark 70 2010 F Alyssa 23 2020 M Robert 54 I want to select the people per year…
Postgresql – How to conditionally use an inner join?
I'm working on a CTE (probably not relevant), and I have two possible inner joins, but the second one should only be used if the first one is empty (it could be used anyway, in fact, IT MUST be executed…
PostgreSQL – assign exact date based on day of month
I don't even know where to start with this one, or if it's even possible to do in PostgreSQL (or if I'll just need to handle it in my code) I have a table of Bills, which specify which day…
Mysql concatenate parents and children as string
This is my database on mysql and I need extract concatenating all the parents and all children. id | name | parent_id | has_children 100017 | Roupas Femininas | 0 | 1 100018 | Meias | 100017 | 1 100419…
Postgresql – is it possible for a query to return the wildcard that matches a given string?
I have the following table in postgres: Table "public.items" Column | Type | Collation | Nullable | Default -------------+--------------------------+-----------+----------+--------------------------------------- id | integer | | not null | nextval('items_id_seq'::regclass) wildcard | character varying(255) | | not null | The wildcard column…
Mysql – Why does my function to collect data from database is not working
I am currently working on my first Java EE project. I am trying to display data from a database I created, but nothing is showing. So, I wonder if I did something bad in my connection or something else. I…
How can I convert a varchar into a date in MySQL Workbench?
Probably it's super simple but i've been stuck some hours on this. I have a column called "Publish_Date" which is a varchar, but my date shows like this: 17.01.11 (year.day.month) and I want to convert it to a date (at…