I used Xampp yesterday to create some simple Web-based utility tool. Today I wanted to continue working on it but xampp control panel gave me some weir errors.
I was looking for a good way to manage a lot of background tasks, and i found out AWS SQS. My software is coded in PHP. To complete a background task, the wor
Confused why getting this issue while trying to connect to my DB. Connection failed: No route to host <?php $servername = "HOST"; $username = "USERNAME
Laravel 8. I have two tables(models) 'employees' and 'positions'. In a model 'employees' I have a casts: protected $casts = [ 'academic_post' => 'array'
I have a website on Heroku that uses JawsDB MySQL. The app is crashing with "ConnectionRefused." When I try to log into the database directly through MySQL Wo
I need to create a frequency table that displays the revenue per bin. The bin has a range of 500. The code shown below almost do the work except it is displayin
Using MYSQL I am trying to get the avg amount spent by all the customers after determining the sum of what each customer spent. select customernumber, round(sum
According to MariaDB's website, you can simply replace MySQL with MariaDB. Great, I thought, however after installing MariaDB (10.5.7), some of my InnoDB tables
I am trying to code a website to work with ReactJS, NodeJs and MySQL. I have been using Sequelize and it works but i realised that it allows all usernames even
I try to import a CSV file in my database, I don't have any error but no rows are insert I checked my field name My table structure is: CREATE TABLE IF NOT E
I'm trying to create a linked server from my SQL Server to a MySQL db. No matter what I do, I get the following error: Cannot initialize the data source object
please help to solve one problem - I need to create after insert in table row with incremented value id number 1 inc1 2 inc2 I need to insert inc3 in number c
I am beginner in web dev and trying to create a Full stack project using Mysql Express React Node js. Facing this TypeError issue while using Sequalize with nod
Database Tables: The below tables contain the information about users and their licenses. Note: One user can have multiple licenses. users table Users( 'user_id
Here is my code. I am trying to use JUnit to test the deleteUsers() method, but everytime I write my test, it deletes all the users that I have in the database.
I'm working with MySQL for a while and also built an API in NodeJS including mySQL for work Basically i need a query like "SELECT * FROM table WHERE fieldA=varA
I know there are tons of question that includes that error, but I haven't seen one that incldues a subquery with row_numbers. Ok so I have this raw query which
I am using Laravel 8 and MySQL8. I have these tables: products id - integer name - string factories id - integer name - string factory_product
I have different tables like profiles, tournaments, tournamentdate, tournamentresult and pigeons. Profiles columns > ProfileId, Name, Address, etc. Tournamen
I'm working on a graph with a Satisfaction form with a database with jpgraph and I've encountered some issues with an handler error. This is my program: <?