I have a table that read day_sunday, day_monday, etc... So I need to check that for today's column if value is true then what data is stored. For example 17 may => Wednesday so the query will be select *…
I noticed strange MySQL behaviour on projects staging server. Given: create table test_table ( id int auto_increment, name varchar(64) not null, constraint test_table_pk primary key (id) ); insert into test_table (id, name) VALUES (3, 'value 3'); insert into test_table (id,…
I have downloaded mysql now opened terminal to run but it is not taking password. In the image it shows enter password but i am not able to write please give me solution It is not taking password but it…
my updated_at column is set to current timestame ON UPDATE. If the column active was False and is changed to True, I also want to change activated_at to be the same value as updated_at. will the query UPDATE mytable SET…
I have the following data: create schema test_schema; create table test_schema.joinedDf(id long, firstName text, lastName text, age Int, month Int, salary decimal); insert into test_schema.joinedDf(id, firstName, lastName, age, month, salary) values( 1111, "Peter", "Ivanov", 29, 10,300000.0000000000), ( 1111, "Peter", "Ivanov",…
In a MySQL database table, among other records, there is a number of pairs differing by the value of just one column, like: | FirstName|LastName |Number| | -------- | ------- |------| | John | Smith |15 | | John |…
How do I calculate these two aliases and show them in other columns? SELECT SUM(qty1) AS ali_qty1, (SELECT SUM(qty2) FROM table2 WHERE col2 = 'B') AS ali_qty2, (SELECT SUM(ali_qty1) - SUM(ali_qty2) as total_qty) FROM table1 WHERE col1= 'A' table1 ID…
I've a small app running on a raspberry Pi. Has been for over 3 years now. It suddently stopped working and I narrowed down the issue to MySQL. Attempting to start the service seemingly fails. Even when I've set the…
I am developing REST application using spring boot and I am trying to optimize the performance of the queries. I am currently using findById from the repositories which is causing performance issues. Code is given below: User Entity @AllArgsConstructor @NoArgsConstructor…
I have a huge table with over 10M rows. I need to update the following rows: select * from customers_card_psp where status="not_added" and psp_id = 2 order by id limit 50000 Since I have a composite index on customers_card_psp(psp_id, status),…