I was reading MySQL document when I found that it said SELECT * FROM test WHERE last_name='Jones' AND first_name='John'; will use index, while SELECT * FROM test WHERE last_name='Jones' OR first_name='John'; will not. Could somebody tell me the reason why…
I'm working on a project with a MySQL database. I have some CTEs that summarize features of the users (each CTE summarizes one feature). Then I have a last query that joins all other CTEs on a column named user_id.…
I have a database in mysql called newdb, inside that database there are 2 tables, Track and User. When I run my springboot application, it creates 2 new tables called track and user and the application uses those tables instead…
Im trying to make an leave application in springboot and got the error that leave table cannot be created. Error : org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table leave (id bigint not null auto_increment, end_date date, start_date date, status smallint, employee_id…
Basicly I have a table for persons data- tb_person (name,date&time,person_id etc) and other table for meals- tb_meals(meal_id,meal type etc) , I want to insert a value in meal in tb_meals where person_id(from tb_person)= 1 the problem is that it is…
On my MySQL server, in the general log I see a ton of logs that look like: 2023-03-31T09:31:23.208-07:00 2023-03-31T16:31:23.208345Z37028 Query SET autocommit=0 2023-03-31T09:31:23.211-07:00 2023-03-31T16:31:23.211201Z36956 Query set session transaction read write 2023-03-31T09:31:23.211-07:00 2023-03-31T16:31:23.211807Z36957 Query /* dynamic native SQL query */ select…
i have table conversation conversation_id name is_group 1 Global chat 1 2 private chat 0 and i have table messages message_id conversation_id sender_id text created_at 1 1 1 hello 06-04-2023 14:00:00 2 1 1 whatsup 06-04-2023 14:01:00 3 2 1…
I'm trying to fetch data from database and this is my prisma model: model instant_reports { id BigInt @id @default(autoincrement()) @db.UnsignedBigInt created_at DateTime? updated_at DateTime? deleted_at DateTime? timestamp BigInt? client_id BigInt? uniq_users BigInt? } So when i fetch data like…
I have table with changelog, every row give me specify inormation about actions. Example: Ticket closed on 2022-06-26 14:12:07.000 Ticket reopened on 2022-06-28 08:35:59.000 Ticket closed on 2022-06-28 12:55:11.000 Ticket reopened on 2022-06-30 17:04:34.000 In other table I have information…
I read about MySQL EXPLAIN safety in the StackOverflow question about it, and one of the later commenters (@tye) said: people figuring out how to make updates via "explain" It's a question that I've been thinking about today -- is…