I have the following SQL table called 'content': language contentId text en 1 Hello de 1 Hallo en 2 World My goal is to query all rows which match language='de'. But if a row with language='en' exists which has no…
I wrote this query to display the "estado" rows if they don't have the values "entregado" or "cancelado" everything works fine The problem is that if a status row "estado" has the NULL value, it is not displayed, why? How…
I'm new to this website and using Mysql and phpMyAdmin. I need help with one of my table and I would really appreciate it. So, I created a table that has an Integer column I want to be able to…
I need some help with the query below - I am trying to pull information regarding price and multiply with the quantity & insert the sum into the table. So far I have, update passenger_baggage SET passenger_baggage.total_baggage_cost=passenger_baggage.passenger_baggage_quantity*baggage_type.baggage_type_cost FROM passenger_baggage INNER…
I have a model TestDirectory in laravel and test-directory table in mysql. After i manually importing a CSV file in to the mysql table via phpmyadmin, calling TestDirectory::all() is not fetching any data. But previously it was working fine. Any…
So I have a table in my SQL and it saves ServerID from discord, now like 500 users verified and on the table it says like ServerID: 123 User: Test Now I accidentally I have deleted the server on dashboard…
I am new to mysql and phpmyadmin so excuse my question if it's basic. I need a query to replace the 15$ to 10$ on all posts and pages post_title, post_excerpt and post_content using the insert method not update method.…
I'm not sure what is happening or why this is happening so hopefully someone can give me tips on how to debug or where to look. I have 2 docker containers, 1 for phpmyadmin and another for mysql. The phpmyadmin…
My client gave me access to his hosting account in order to create a new user for his Wordpress site since he forgot the credentials for the old one. I got the FTP account and opened wp-config.php and normally i…
How can I write query for below table in Laravel. Like In my app logged user id is 109 So I need whose user match with logged user in BlindDate and PaidDate table to user id. This is User table…