All Questions
69 questions
1
vote
0
answers
464
views
Use 2 columns of a table as foreign key in an other table to avoid circular-reference
I have two tables:
ObjectContainer
containerID INT NOT NULL PRIMARY KEY
mainObjectID INT NOT NULL FOREIGN KEY REFERENCES Object (objectID)
Object
objectID INT NOT ...
- 11
2
votes
1
answer
2k
views
Optimize the number of connections of the connection pool and MySQL
We are using Oracle Cloud's Ampere A1 instance consisting of 4 OCPUs (equivalent to 4 vCPUs) and 24GB of usable memory on Oracle Linux 7.9.
On the server is running an java game server and a web ...
- 23
0
votes
1
answer
77
views
NDB Cluster Read and Write Process multiple Access
When using the MySQL NDB Cluster distributed database, the following general problem has arisen: To insert a new Record / Row, the last row in the database should be read, see if it is compatible with ...
1
vote
0
answers
466
views
SSL connection error when connecting to MySQL, using JDBC
The problem that we are facing is well documented in https://stackoverflow.com/questions/34189756/warning-about-ssl-connection-when-connecting-to-mysql-database.
We started facing this issue upon ...
- 265
1
vote
2
answers
3k
views
I cannot create a table in mysql
create table Statistics_tbl with (
SELECT Todo_tbl.person, SUM(Todo_tbl.duration) FROM Todo_tbl JOIN Statistics_tbl
on Todo_tbl.person = Statistics_tbl.person GROUP BY person;
);
The issue is that ...
1
vote
1
answer
133
views
How can I join two tables in mysql, so that whenever I add data to table 1, table 2 updates as well?
This is the code creating my first table
create table Todo_tbl (
id INT auto_increment,
person VARCHAR(45) ,
task VARCHAR(45) ,
duration INT(4),
deadline_day VARCHAR(2),
deadline_month VARCHAR(2),
...
0
votes
1
answer
3k
views
How to automatically update table, whenever data added to another table?
I have created two tables in MySQL. One (Todo_tbl) holds the data while the other (Statistics_tbl) hold the sums one of the variables from Todo_tbl.
Following the definitions of these tables:
create ...
0
votes
0
answers
34
views
Optimal way of running hundreds of thousands of DDL/DML statements MySQL
I have about 500k DDL/DML statements that need to be run against a MySQL 5.7 INNODB RDS instance from scratch. A significant portion of these are created table statements.
I'm currently employing a ...
David
0
votes
1
answer
678
views
Queries of MySQL from Java are executed serially from multiple threads
I have REST API developed in spring + java and hosted on Tomcat server. I have a MySQL database where i store all my data. API makes just simple select from db as descripted below. I failed ...
0
votes
0
answers
53
views
Update table_name set column1 from where column2 (column2 mutiple diffirent value)?
Hi I'm working with this Query to update all the row in the table using a String of multiple values.
I'm trying some Query but i get an error
the error is "Truncated incorrect DOUBLE value"
this is ...
- 13
0
votes
1
answer
358
views
how to get data from two tables in mysql query with where Pk of one table is set as foreign key on PK column for other table?
The query I am using to retrieve data is as
"select sum(totalbill) as tbdb, sum(discinamount) as tddb, sum (billafterdisc) as tbaddb,"
+ " sum(totalqt) as tqdb,"
+ " sum(payed) as tpdb,"
+ " sum(...
0
votes
1
answer
133
views
Accessing mysql database without logging in (from android java application) (using php server side) [closed]
Just like all e-commerce applications (like amazon) let you access the database and browse items without logging in or signing up, how can i do this with mysql database (without logging in with ...
- 1
0
votes
1
answer
1k
views
MySQL MONTH Clause: Want to get Month Name instead of number
My query is
SELECT MONTH(`hire_date`) AS month FROM `emp_tbl`
I'm getting output in Java fx
if(resultSet.next()){
int month = resultset.getInt('month'); // output is like 11
}
Then I ...
1
vote
1
answer
700
views
Is it overkill to encrypt an already hashed BCrypt password?
I'm using BCrypt to hash my passwords on the server side. Before I store it in my MySQL database, would it be overkill to encrypt my hashed-BCrypt password or would storing the hash directly in the ...
- 39
-2
votes
1
answer
858
views
Database design for a timesheet app?
I'm designing the database schema for a time tracking application and I need a little piece of advice. The application must permit the user:
To enter for each day of the week the amount of time he ...
