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 want to create a table for student with the attributes enroll_id and std_name. The enroll_id is Primary Key of the table and the format of enroll_id is year+brach code (CS,EC,MC,CV)+college code (001 to 300)+ entry type(D for lateral entry…
I want to filter out the record with the highest salary for each department. If there are multiple records that meet this condition in a department, keep all of them.Then I write SQL following: SELECT id, name, salary, departmentId FROM…
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…
Using default windows install instructions on a bare Windows 10 installation. Got server running. Re-stating: this is thus far using ONLY default values; no changes. I was able to login from another computer using an existing 3.3.5 client, but not…
I'm trying to write to the database after authenticating, but unable to. Once I log in successfully, I redirect to index.php <?php session_start(); if (isset($_SESSION["user_id"])) { $mysqli = require __DIR__ . "/database.php"; $sql = "SELECT * FROM user WHERE id…
After defining a table-valued function in mssql select * from funcA() is possible. But mysql seems impossible, is that correct? How can I do it in MYSQL? If this is not possible with a function, is there a similar way?…
I am learning to use groupBy. In my exercise, I must count the number of tickets that were sold and add the total money collected. $tickets = Ingresostaquilla::groupBy('tipo') ->selectRaw('count(*) as quantity, tipo') ->get(); I did the count by type of…
I have the following query: SELECT m.id_ AS match_id, mv.id_ AS match_version_id, t.id_ AS tournament_id FROM test.match_version AS mv JOIN test.match_ AS m ON m.id_ = mv.match_id JOIN test.tournament AS t ON t.orig_id = m.tournament_orig_id AND t.tour_id = m.tour_id ORDER…
We have a live MySQL server at the company where everything comes together. It was created around 1998 and has been running continuously ever since. The MySQL version is 3.51. WinMySQL version 1.4 from 2001. I was just born at…