I have a database of a number of purchased plans with a value of minutes_left from which I want to subtract 1 number every minute. Now I am using this code using cron job: $sql = "SELECT * FROM pls";…
The problem consists of two parts, one is to upload the data which is an 8*8 numpy array to the mysql database, the other one is to retrieve and update the data with seaborn and matplotlib. For the first part,…
I'm seeing something strange after upgrading my app to SpringBoot 3 from SpringBoot 2. The application relies on an existing database (MySQL) which doesn't use good practices. One of them is using Y N for booleans stored in a VARCHAR.…
I'm working on a quote generating system that creates a quote for a user and saves it to a database. I'd like users to be able to share their quotes with friends and family without exposing the auto-incrementing ID (to…
I have 2 tables, which represent one to many relationship CREATE TABLE a( id int, a_text varchar(255) ); And CREATE TABLE b( a_id int, b_text varchar(255) ); Where column b_text contains enum values. Table A: Id a_text 1 'text 1'…
So, I have 4 tables: Drugs Manufacturers Drug_manufacturers drug_reports Drugs table id name 1 row 1 2 row 2 Manufacturers table: id name 1 ДИГОКСИН ТАБЛ. 0,25МГ №40 2 DRUG NAME 54 Drug manufacturers table drug_id manufacturer_id counter 1 3…
I am using an SQL table to keep track of the number of meals given to students every day. The table is structured as follows: ID_Student MealDate MealType 1 2023-05-21 1 2 2023-05-21 1 1 2023-05-21 2 2 2023-05-21 2…
I have two tables, both tables have a column with the same value. Table 1 |sn|Name |Age |Address |Date | |1 |Name 1|Age 1|Address 1|18-05-2023| |2 |Name 2|Age 2|Address 2|21-05-2023| |3 |Name 3|Age 3|Address 3|21-05-2023| |4 |Name 4|Age 4|Address 4|21-05-2023|…
I am trying to insert dates along with other data into my SQL table: insert into weather values (1, 'London', -1, str_to_date('2021-01-01','y%-m%-d%')), (2, 'London', -2, str_to_date('2021-01-02','y%-m%-d%')), (3, 'London', 4, str_to_date('2021-01-03','y%-m%-d%')), but I am getting the message below: Error Code: 1411.…
I have the following query: select u.* from users u left join customers_cards cc on cc.user_id = u.id where u.belongs_to = "ezpay" and cc.id is null It returns users who have not added any card yet. I need to delete…