I am trying to use a single select request to retrieve data from database based on the search term "name" and populate my input fields using select2 so that i d
Say I have a table logins with just the bigint id ,a date_login of type datetime, and fk_user of type bigint. I need to select the first and last logins for eac
I read this post and I wish to fix it the same way as the answers but I can't find the backup folder in my CentOS. Where is C:\xampp\mysql\backup\ located in Li
I've been using Laravel Datatables for awhile in some of the Laravel applications and I really love that, and probably using a fraction of the features. I also
So my question is : How does hashing algorithms actually check if passwords match because they generate a new password every time. Let's suppose I have a passwo
Have anyone deployed Spring Boot app to DigitalOcean droplet? I have previously created app on Heroku.com, where I also ordered MySQL Database and deployed my W
I am trying to figure out what part is wrong? I get this error: ERROR----- var pwdCompare = await bcrypt.compare(password, pwdCompare[0].password); TypeError: C
I cannot open the local instance in MySQL Workbench in Ubuntu 20.04 after installing the MySQL server. I searched for some similar topics here but these did no
I keep getting this error when trying to open my python in the browser in my terminal.the code reads... (auth_book_demo-xzfPnOIq) C:\Users\thego\Desktop\CodingD
If the column has already the index "INDEX_VALUE" in DB MySQL. Do I still need to add in hiberante Entity? @NamedQuery(name = "", query = "SELECT e FROM Entity
I have tried to show sql query result on click a button in node js Like on click a button, it show the result of sql query below that button
I have tried to show sql query result on click a button in node js Like on click a button, it show the result of sql query below that button
I have MariaDB on my server with 16/32 CPU cores, Everything seems to be ok when running mysqltuner except InnoDB Write Log efficiency, taking 1953.15%, wonderi
I'm learning about sharding approaches. How to achieve good horizontal scalability with a large number of shards in an IO-heavy application. Below I describe a
I'm trying to do is fetching the data according to timestamp from DB once (call it origin) and wait for 30sec fetch it again with same query(call it recent) in
how would i make multiple MySQL querys in NodeJS, in the following code con = mysql.createConnection(...) con.query(`SELECT * FROM BRUGERE WHERE username = ${us
I have to generate 'yearquarter' combinations within a specific date. example: start_date = '2021-01-30' end_date = '2022-05-01' Output: result = [ '2021Q1',
SQLSTATE[HY000] [1049] Unknown database 'laravel' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and ta
Samantha was tasked with calculating the average monthly salaries for all employees in the EMPLOYEES table, but did not realize her keyboard's key was broken un
I have a question in term of my database courses, hope that you can help me. The table bellow is an exemple: +------------------------------------+ |ID_EMPLOYEE