This is a strange one. In my ECS Fargate task, I have a Docker container running PHP code that calls mysqli_connect to connect to an RDS MySQL database. Works g
I am looking for a function which is equivalent to ORA_HASH() function in MySQL Server Can you please help me in proving the equivalent function to ORA_HASH in
Getting below error when tried to start the server I'm using apache 7.0.57 and SQLJDBC 8.2, can't use mssql-jdbc-9.2.0.jre8.jar as that is not supported by my p
MySQL 8.0 Command Line Client crashes right after entering the correct password. I have also checked in services and there is no problem there. I'm using window
I want to create UserRole table, but mariaDB complains with the following error: Error Code: 1005. Can't create table `testdb`.`userrole` (errno: 150 "Foreign k
I have a table very similar to that below. I need to sort the end_time into ascending order and then select the start_time that are say within plus or minus 2
I have an SQL table containing fields with date and time with columns start and end as DateTime. What I want is a query that will select the row where the curr
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