I am using mysql-connector-java-8.0.15.jar in my code to connect to a remote database using com.mysql.cj.jdbc.Driver. When I deploy my code on the server the connection is refused. I tried firewall settings (is correct), directly connectin…
I’m trying to return columns that don’t have the same names in each row or don’t match in SQL. I have tried finding things but I can’t find the right solutions because anything similar is looking for results that don’t match from the same …
This is kinda like a groupwise maximum question but bit different.
For a table like below, I need to get one row per ID but row contents need to be in specified lang, and if it not exists, it should return the row in another specified lang…
I migrated from MySQL 5.7 to 8.0 and the same application now throws this error:
msg="query error" logger=tsdb.mysql err="Error 1370: execute command denied to user ‘myuser’@’localhost’ for routine ‘mydatabase.SUM’"
T…
I migrated from MySQL 5.7 to 8.0 and the same application now throws this error:
msg="query error" logger=tsdb.mysql err="Error 1370: execute command denied to user ‘myuser’@’localhost’ for routine ‘mydatabase.SUM’"
T…
Illuminate\Database\QueryException
SQLSTATE[HY000] [1045] Access denied for user ‘forge’@’localhost’ (using password: NO) (SQL: select * from information_schema.tables where table_schema = forge and table_name = migrations and table_type =…
I working on maintenance of a WordPress website and i want to disable IP blocker functionality of WordPress.I am using Wp Mail smtp plugin.
I want to extract column A with all elements in C are in B.
T1:
+—–+—–+
| A | B |
+—–+—–+
| a | 1 |
| a | 2 |
| a | 3 |
| b | 1 |
| b | 2 |
| b | 4 |
| c | 2 |
| c | 3 |
| c | 4 |
+—–+…
i’m beginner at Spring and can’t find information how i can will do this. I have MySQL tables 1)Customer with Fields Id,FName,LName,DOB,Nationality and verified (tinyint(1)) and etc. 2)MyResponses with Fields id AI PK ,customer_id, respon…
I’m trying to create a table in MySQL using python-flask. The table name is the ‘id’ parameter, which I pull from my server. I want this id to be the name of the table that I’m creating, but when I try to do so, I get the following error:
…
The following query:
SELECT * FROM table WHERE id IN (1,2,3);
will return three records.
SELECT * FROM table WHERE id IN (1,2,1);
will return just two records (for Ids 1 and 2)
Is there a way for the result set to contain two records for…
I’m using MySQL 5.7 and PHP 7.4.
The following select statement runs perfectly fine in phpMyAdmin and returns a row, as I would expect.
select b.price,sum(ifnull(i.itemamount,0)) totalpaid,b.loyaltypoints
from bookings b
left join pay…
I’m really new using JPA and still dont get how to achieve this, I would be glad to any suggestion or solution.
Mysql tables:
CREATE TABLE REAL_STATE_TYPES (
real_state_type_id INT(6) NOT NULL,
real_state_type VARCHAR(50) NOT NULL,
PRIMARY…
I am using WordPress and have a table with Name and Price data.
I want a link, in a third column called "Add to my portfolio", and by clicking this link the Name and Price data should be added to the table user_portfolio.
This is…
Here in this code three conditions are working well separately, but when I am going to work it out at the same time it won’t work.
I have JSON data where I have made three conditions age-wise, and I want to send the data to that group of p…
I have two tables
profile
——–
id
name
Profile_dates
————–
id
profile_id
entry_date
The tables have 1 to many relationships
I want to get min and max entry_date for each profile like
id
name
profile_dates.first_date
profile…
so i have 2 databases one called comments and users but in a query i need to get username from users
INSERT INTO comments SELECT (text, post_id, user_id, created, username ) FROM comments INNER JOIN users values (:text, :post_id, :user…
In my database there are 2 tables relating to posts the users make: tblPosts – which contains the information about a post a user has made. And tblComments which contains the comments made by users.
tblPosts:
tblComments:
My goal is to s…
I’m working on a PHP script that uses delete and I only want to delete 1 row. But everytime I tried to delete 1 row, the SQL executes but deletes the entire rows in the table.
The following is my PHP script
<table>
<tr>
…
According to doc
if options.raw
If set to true, field and virtual setters will be ignored
But what is the meaning of field and virtual setters?
I have watched lots of sites but seem no examples for the format of query result when the val…