i have two table table1: id | time | value ---------------------------------------- 1 | 2024-01-09 22:24:14 | 100 ---------------------------------------- 2 | 2024-01-10 22:25:14 | 200 ---------------------------------------- 3 | 2024-01-11 22:26:14 | 300 ---------------------------------------- table2: id | last_value ---------------------- 1 | ---…
here are 5 rows of my column Genres in my table data Classics, Fiction, Historical Fiction, School, Literature, Young Adult, Historical Fantasy, Fiction, Young Adult, Magic, Childrens, Middle Grade, Classics Classics, Fiction, Romance, Historical Fiction, Literature, Historical, Audiobook Classics, Nonfiction,…
I am attempting to make a web application (LAMP stack - MySQL version: 8.0.36-0ubuntu0.22.04.1) that is vulnerable to a SQL UNION Injection attack (or some type of SQL injection attack). The code takes the user's input via POST parameters to…
I created a new column named garagem_coberta in my table. I can´t create the trigger because mysql says: unknown system variable 'garagem_coberta'. Can someone help me? delimiter // create trigger update_garagem_coberta before update on apartamento for each row begin if…
Creating a Auto Generation ID with Prefix in MySQL Without Using Trigger I need Creating a Employee Id with Prefix and Without Using Trigger in MySQL.
I use Maria DB. Where can I set the innodb_buffer_pool_size parameter. I looked in /etc/mysql/mariadb.conf.d/50-server.cnf and /etc/mysql/my.cnf, but I can't find the parameter there. But anywhere the parameter must be set, because I get a result, if I use: show…
I'm currently working on optimizing a MySQL query, and I'm wondering if there's a way to retrieve both the count of the results and the actual result set in a single query. I'm aware that I can achieve this using…
I am trying to implement image upload in my project. If I add single image it is working properly. But In multiple image fields getting error as { "message": "Unexpected field", "error": "Bad Request", "statusCode": 400 } @Post('personal-details') @UseInterceptors( FileInterceptor('image_front',…
I have a problem with MySQL and/or DBforge. I would like to import a schema using an .sql file that DBforge generated for me by comparing 2 databases. The file DBforge created for me contains characters with accents (éèêàâ...), so…
I have the below SQL query, where I want to return all rows of the table if -1 is passed as the value for @statusParam. And rows that matches the @statusParam value if something passed other than -1. The status…