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…
I have the following table <state_table> that tracks entries per minute of an id and its state: minute id type ------ -- ---- 1 A solid 1 A solid 1 A solid 1 A liquid 1 B solid 1 B…
I have wondered about my current database design I made for my uni organization website. In general this website is for displaying informations and events. The event is different for each departement. It does some normal things like displaying event,…
Question: List the name of the team and number of wins of all teams that had more wins than the average team had. Order results by descending number of wins. SELECT mlb_team.name, mlb_team.wins, AVG(mlb_team.wins) FROM mlb_team GROUP BY mlb_team.name HAVING…