I have a table with the following columns: ClientID, Amount, etc. The problem is that some clients have two or more rows with Amount = 0, and I want to remove these rows. I've searched some information but only found…
I have a table of entries in a mysql table: script lastRun processed ________________________________ scriptA 1663695633 0 scriptB 1663695647 1 scriptA 1663695776 0 scriptB 1663695799 1 scriptC 1663695950 1 scriptA 1663695957 0 scriptB 1663695959 1 I am trying to get…
This is the table I am working with: +---------------------+----------- | Field | Type | +---------------------+--------------+ | ID | binary(17) | | MiscSensor_ID | binary(17) | | rawValue | varchar(100) | | RawValueUnitType_ID | int | | timestamp | timestamp |…
Description To test our updates, we compare an old, updated database schema with a fresh installation. The two schemas should be identical. We use SHOW CREATE TABLE to find the differences. However, we noticed that with MySQL 8 we find…
As you can see below I have Name column. I want to split it by / and return the value in array. MyTable Id Name 1 John/Warner/Jacob 2 Kol If I write a query as Select Id, Name from MyTable…
I have the following SQL database details: import sqlalchemy as sch from config import Config db_uri = os.environ["SQLALCHEMY_DATABASE_URI"] + os.environ["DB_NAME"] in the env file I have these SQLALCHEMY_DATABASE_URI = 'mysql+pymysql://*****:*****@instance-amazonaws.com:3306/' DB_NAME = 'DB_NAME' Now db_engine = extrac_db.create_engine(Config.db_uri) db_connection = db_engine.connect()…
select * from `attendance_marks` where exists (select * from `attendables` where `attendance_marks`.`attendable_id` = `attendables`.`id` and `attendable_type` = 'student' and `attendable_id` = 258672 and `attendables`.`deleted_at` is null ) and (`marked_at` between '2022-09-01 00:00:00' and '2022-09-30 23:59:59') this query is taking too…
consider the table date id 9/2 1 9/2 2 9/2 3 9/3 4 this can be pivoted up using count and case statements for each date 9/2 9/3 3 1 but is it possible to do the same thing without…
Newbie here having trouble wiring up some tables for a game's leaderboard. Would appreciate help! I have 3 tables; here's an ER diagram: ┌─────┐ ┌─────┐ │ IPs ├─||─────────────────|<─┤Names│ └──┬──┘ └──┬──┘ │ │ │ │ │ │ │ │ │ │…
Hello i am doing an request to an SQL Database (in php) witch looks like this... SELECT firstname FROM users WHERE job = '$jobL' Lets assume in the Database are three users with the $jobL namend: Mike, Steve & Danny.…