Here I'm trying to keep track of my Employees Skills like when they are added, when removed and then new skills are added. So, I'm getting storing them in the database as follows: Then Retrieving the data as follows: $skillHistories…
I'm completely new in mysql and struggling to write a store procedure to get a required result set. As you can see below are the tables I have, I'm using node & express api to connect to mysql database. Then…
ID POSITION EXPERIENCE SALARY 1 top 90 1500 2 bottom 100 1500 3 top 90 750 4 left 90 1000 5 right 100 1300 6 top 90 1500 7 left 80 2000 8 top 80 1000 9 bottom 100 2000…
I have a table that contains this (HIght value, LOw value data according to a DatetTime): mysql> select dt, hi, lo from mytable where dt >='2022-10-03 09:20:00' limit 20; +---------------------+--------+--------+ | dt | hi | lo | +---------------------+--------+--------+ | 2022-10-03…
I'm trying to build a filter on my data using laravel .. I have many to many relationships between the BasicItem model And AttValue Model and table Item_value between them. this code works as what I want but I need…
This is the error im getting: UPDATE problemas SET situacao='Concluido' WHERE id=? SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right…
For example, let us consider this table: In this image consists of rows of 8 where names like Mike,Glenn,Daryl,Shane and Patricia is included with their respective ages Id Name Age 1 Mike 25 2 Glenn 19 3 Glenn 19 4…
My query: SELECT * FROM outlets INNER JOIN users ON outlets.owner=users.id; The result is an array in which the indexes from one table match those of another table. Is it possible to somehow make such a request that owner =…
Mysql giving bad performance while passing column value as bigint and column created with data type is varchar. Below is my create table query and index created on 3 columns(user_id,category,status). I am using spring jpa to interact with mysql and…
I have this error on PopSQL : Error: Failed to add the foreign key constraint. Missing index for constraint 'etape__ibfk_1' in the referenced table 'etapexprojet_' Error Code: ER_FK_NO_INDEX_PARENT This is my code, i'm only creating tables and it has a…