When a post is accessed, I need, in addition to returning the information of this posts, to return the previous one if it exists and the next one. I would like to know if there is a way to select…
I have a MySQL database table that looks like below: +----------+------------+---------------------+ | name | event | created | +----------+------------+---------------------+ | Player1 | Logged in | 2023-02-14 10:05:00 | | Player2 | Logged in | 2023-02-14 10:05:30 | | Player3 |…
I have the table contacts which contains duplicate records: id name is_contacted created_at I need to delete duplicates, but keep the first record(among the duplicates for each name) where is_contacted=1. If among the record duplicates there are no records where…
I'm working on a transport program that forces me to create a long query to search for possible routes. I need to optimize the query as much as possible. It calculates stopovers between bus stops. People get off at one…
So i am working on a program that is and I am stuck. I have a login and signup system that saves new signups in a mysql database. At the start of the program I take the passwords and names…
I have some trouble, Data Example: animal_table: id name desc farmer_table: id name desc investor_table: id name desc Main Trouble: now i will create Simple CRUD applications, but there is some conditions. Investors(Many) to Animals(Many) Farmers(One) to Animals(Many) how do…
can someone help me make it simple and fast? select k1.sto, k1.mm,k1.dd, k1.yy, k1.sto_name, k1.trannum, count(k2.barcode) from trans012020 as k1 , trans012020 as k2 where k1.barcode=123456789 and k1.mm=k2.mm and k1.dd=k2.dd and k1.yy=k2.yy and k1.sto=k2.sto and k1.trannum=k2.trannum group by k1.trannum having…
I'm learning from an online course MySQL using the WampServer and editing code in MySQL Workbench. Trying to create a table with the following code, the column nome appears to be the primary key from the table, but i'm only…
Lets say I have a table like this: ma_id act_date 1 2023-01-01 1 2023-01-02 1 2023-01-03 1 2023-01-05 1 2023-01-06 2 2023-02-08 2 2023-02-09 I have read a lot of guides but couldn't find what I was looking for... I…
fairly new to SQL in general. I'm currently trying to bolster my general understanding of how to pass commands via cursor.execute(). I'm currently trying to grab a column from a table and rename it to something different. import mysql.connector user…