I have a problem as follows; Let's say I have 3 tables like this: tableA ID_name Name Email 1 Alice xx 2 Betty xx 3 Chris xx tableB Id_task id_name Tasks_submitted 1 1 1 2 2 1 3 1 1…
Having the following tables CREATE TABLE contacts ( Id INT NOT NULL AUTO_INCREMENT, Name varchar(255) NOT NULL, PRIMARY KEY(Id) ); CREATE TABLE contacts_cstm ( Id INT NOT NULL AUTO_INCREMENT, Id_c INT NOT NULL, Department_c varchar(255) NOT NULL, PRIMARY KEY(Id) );…
$mysqli = new mysqli('localhost', 'root', '789456','ai'); I write this and turn on the xampp mysql have aipharm name , it's host is local(127.0.0.1),username is just root, password is same too and port is 3310. At the left side, mysql icon…
I don't have any index applied for the deleted_at column. The "rows" stays the same and everything else except for the "filtered" column which drops from 100 (without checking deleted_at) to 10 (with deleted_at check) is this a cause for…
In the database migrations section, on Laravel Bootcamp's Build Chirper with Inertia, after I entered the command: $ php artisan migrate it threw an error: IlluminateDatabaseQueryException SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: select * from information_schema.tables where table_schema =…
can you give me an example request showing how I can combine two duplicate lines merge one? id name no 123 aaa 1,2,3 124 aaa 4,5,6 125 aaa 7,8,9 i want this id name no 123 aaa 1,2,3,4,5,6,7,8,9 I researched…
I made a windows desktop application using electron. I connected my program to mysql. However, in order to connect to the database, I had to specify the account credentials such as username, password, host, port, and database name. I read…
I am trying to build an app, get the location of the user and find the nearest shop to the current location. The data exists on a wordpress backend. I have successfully created the custom end point and ran the…
I want to rank the students based on the subject, and their total overall for that particular subject. Query works for all subjects but when I specify the where clause, I only get the rank of the user specified in…
I try to run my server in NodeJS and a MySQL database using Docker , when I run sudo docker-compose up I get this error in nodejs server: Access denied for user 'Pedro'@'172.19.0.4' (using password: YES) backend_container | at Packet.asError…