I have following timeseries data table, Id Object_Id Datetime Sensor1 Sensor2 1 175 '2022-03-24 22:01:00' 0 0 2 175 '2022-03-24 22:02:00' 0 0 3 175 '2022-03-24 22:03:00' 5.5699381666667 81.342836833333 4 175 '2022-03-24 22:04:00' 5.5668366666667 81.281143 ... ... ... ... ...…
I have a text file with several hundred thousand primary IDs of rows I need to delete from a MySQL database of ~20m rows. What's the best way to do this?
I've just started working in an Oracle database after years of using MySQL and I'm a little confused about the grouping differences. As a starting point, let's say I have this project table: id name created 1 Created on September…
I want to code the registration function with mysql, but when I check the condition, it says Email already exists even though it doesn't exist in the database. Why is it that when I register, it always says that the…
Two queries; SELECT * FROM `products` WHERE product_type = "" AND product_description LIKE "%a%"; and SELECT * FROM `products` WHERE product_type = 10 AND product_description LIKE "%a%"; The product_type value is full and works when it is correct (2md query).…
I would like to calculate total Prise per month. i have a database where I save data every minute. TIME KWHI EUR 2023-12-02 23:00:15 8852.892 12.8040 2023-12-02 22:59:13 8852.892 13.4496 2023-12-02 22:58:11 8852.892 13.4496 2023-12-02 22:57:09 8852.892 13.4496 SELECT TIME,…
I have a query SELECT name FROM people WHERE age IN ('34','34') There is only one row with column age of 34, but I want to return that row 2 times since 34 appears twice in the array. Any solutions?
This MySQL function should generate a check digit using Luhn algorithm. Given the number 345722 the function should return 3. It returns 6 which is wrong. drop function if exists luhn; delimiter // create function luhn(myNum varchar(20)) returns varchar(1) sql…
Given the following table1 schema: +---------+-----------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+-----------------+------+-----+---------+----------------+ | ID | int | NO | PRI | NULL | auto_increment | | NAME | bigint unsigned | NO…
I'm trying to run "php artisan migrate" in docker app container bash, after successfully installing mysql, nginx, php and etc. containers. But this error comes up : SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = code_clan…