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…
Why do most(all?) SQL Databases give: SELECT FALSE < FALSE; -- FALSE / 0 Ok SELECT TRUE < FALSE; -- FALSE / 0 Ok SELECT NOT(FALSE) < FALSE; -- TRUE / 1 What? SELECT NOT(TRUE) < FALSE; -- TRUE /…
I have a many to many table that holds both EventId and TagId. +-------+---------+ | TagId | EventId | +-------+---------+ | 150 | 61096 | | 149 | 61096 | | 149 | 61095 | +-------+---------+ How can I query…
I'm triyng do bulk insert data into two tables with a many to many relationship, no issue if I insert on a single table but I'm unable to insert in both at once. CREATE TABLE IF NOT EXISTS `mydbv3`.`PRODOTTI` (…
So I'm running a query against a MariaDB in PHPMyAdmin, its been working fine until we have got to a new month and for the life of me I can't see the issue. The table is in the following format…
I trying to fetch data from two related tables using a foreign key and keep the data as separate records / objects. The best solution I have found so far is using JOINs with column prefixing to differentiate between the…
UserID Access 1 ["1"] 2 ["2", "3"] 3 ["3"] I have the above table, I'm looking to return a merged array of all the Access values. So the result would be ["1","2","3"] I have tried with: SELECT JSON_ARRAYAGG(Access) FROM table;…
I have a problem. i need to research through query all text containing a substring given by a post method on php. for example, if i input an "a" or a number like "1" (char not int) i need to…
I'm trying to calculate regular an overtime hours for an employee that works 2 jobs at the same company. The reason it needs to be done this way, is the hours get billed to separate departments. Overtime begins after the…
I am trying to insert authors in an authors table to match sources through an association table of author_ids and source_ids in a flask website. I am using mariaDB, therefore I am aiming to have it all in one SQL…