I am trying to build an annual leave program. I have two tables the first one stores all the staff data and the second one contains the staff who are on annual leave with their start and end date. I…
I'm struggling to know where to start on this one. I want to write a SELECT query which will return all the students in a particular class and the subjects they each take. But the subjects are stored in rows…
I have a mySQL with the following two tables: person keyed on ID staff keyed on ID and StaffID (used to link managers and their staff) The following stored procedure should insert a row into the staff table provided both…
My scheme on prisma: /// This model or at least one of its fields has comments in the database, and requires an additional setup for migrations: Read more: https://pris.ly/d/database-comments model articles { id String @id @default(uuid()) dealership_id String type String?…
I am trying to change column name in SQL but it is showing me error query alter table cust rename column first name to first_name(30) ; error ERROR: syntax error at or near "name"LINE 2: rename column first name to…
How to improve my query where I have used offset in mysql. I am trying to make pagination. I have a database there I have more then 800k data for a single column. Example: My table data like: ----------------------------------- |id…
I have price column in MySQL contains this values : price 1020.2200 202.0000 0.5000 820.6700 I want to split at the floating point. Here is what I'm trying to get : price p_units p_decimals 1020.2200 1020 22 202.0000 202 00…
I'm working on my first SQL case statement - and unsure how to do this. I have two different columns of data, one is for drive A, the other drive B. I want to select data from drive A for…
I am trying to connect to a MySQL database hosted on my website's domain using Python, but I keep encountering the following error: mysql.connector.errors.DatabaseError: 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061) my code: import mysql.connector try: db…
I have a problem on this query as I don't know now how to optimize it to make it faster it takes 20 seconds to load Employee Attendance View SELECT `datetimerecords`.`eid` AS `eid`, `datetimerecords`.`timedate` AS `timedate`, `datetimerecords`.`state` AS `state`, `employees`.`employeeid`…