I have a model with char field with values like this: "Justin Roseman" (one single whitespace betwen words) "Justin Roseman" (two whitespaces betwen words) " J
I have created a MySQL join between two tables in two different databases on our account. The query works fine on my local server, but the hos
i have table schema in mysql for my project. this project build with laravel and as you can see in the below image i want to fillter all row with the same store
I am currently scraping tweets via Tweepy into a mySQL database. I am new to routing data into a server, so I am having trouble adjusting my code to get the ext
I'm trying to build an app in nextjs and I've stumbled upon some issues. I'd like to do a query call inside my getServerSideProps() but I get the error: error -
I have a problem selecting the data from a table. I'm sure the answer is staring me in the face, but my brain is mush. We're trying to find out which customers
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