I installed XAMPP on Ubuntu. MySql-server fails to run properly. I tried many solutions, as suggested by google "/opt/lampp/bin/mysql.server 264 kill no such
There is the schema of my db : And I've got this error message when I try to delete a picture : SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot de
I have a table with: Id (id of rider) Time (is the time that he has done) Session (number session where the time was done) idlap idRider session time 1
Using PHP, I want to generate custom MySQL dump file (due to cannot use exec and a few other reasons). I found these 2 similar solutions: https://www.kvcodes.co
I have downloaded Mysql.data , Mysql.data.entityframework , mysqlconnector and additionally downloaded mysql installer.But Mysql not showing in Visual studio 20
I have a datagridview which I populated thru mysql query Using command As New MySqlCommand("SELECT p_code as 'Prodcut Code', p_name as 'Product Name', filter "
I am looking to get row count to check if same email is already in database or not. i have tried couple of mechanism but no success. when i run my query directl
I want to delete the rows with null values in the column How can i delete it? SELECT employee.Name, `department`.NUM, SALARY FROM employee LE
how can I update multi specific rows in mysql and php ? in the example there are tow rows 50 , 51 I need to update "quantity" and "note" . SN | Medication | Qya
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'