18 questions from the last 30 days
-2
votes
0
answers
19
views
How to test the database security - phpmyadmin [closed]
I created and hosted a dynamic website .
I created /phpmyadmin also to it so i can access database easily .
How to test the domain/phpmyadmin security vulnerability ?
i dont have credentials to it . i ...
0
votes
2
answers
97
views
MySQL query fetchall() result
I am currently trying to make a nested MySQL query using Python. But I am a bit confused about how the respond to a query that comes in a weird format with "()" and "," rather than ...
- 53
Tooling
0
votes
6
replies
87
views
PostgreSQL to MySQL Data Migration -Need a Reliable Converter
I am developing something related to db so what actually happened is I want to import the database data to my database but I am unable to import it from PostgreSQL to MySQL I need a converter is there ...
-1
votes
0
answers
70
views
Flyway is not creating the tables when the application starts [closed]
I configured my spring application to interact with flyway for a data migration but flyway seems not to be working. My application.properties file is in the resources package
spring.application.name=...
- 41
Advice
0
votes
12
replies
107
views
Update start/stop time of state table and insert if state changes
I have a table that looks something like:
| Device id | Starttime | Stoptime | State |
|-----------|-----------|----------|-------|
Is it possible to make a MySQL request where, if the latest "...
- 23
0
votes
0
answers
51
views
Transpose a table and concatenate value into single var [duplicate]
NAME
Instance
Date
val
John
1
2019
12Y
John
2
2019
32dd
John
3
2019
23F
John
1
2020
43s
John
1
2022
23G
Mary
...
...
...
How do I convert the table into below?
Basically transpose by NAME and DATE and ...
- 13
Best practices
0
votes
4
replies
96
views
How to manage data state between MySQL and Clickhouse?
I have MySQL and Clickhouse running for my system. Here MySQL is the source of truth and I store analytical data such as metrics (count, avg etc..) in Clickhouse. I have aggregated tables in ...
Tooling
0
votes
22
replies
185
views
Which services are typically required to scale a LAMP stack for high-traffic production environments?
I am designing a LAMP-based application (Linux, Apache, MySQL, PHP) expected to handle increasing concurrent traffic (e.g., thousands of requests per minute).
From research and feedback, it seems that ...
Advice
0
votes
6
replies
92
views
Multi Vendor Insurance system best db design
I am building a module in which I have to integrate multi-vendor insurance using the nestjs and mysql. Mainly our purpose is to do insurance for new E-rickshaws. So, what is the best tables schemas I ...
1
vote
2
answers
132
views
SQL Sum on the most recent previous valuer
I am trying to find the running sum of quantities across accounts over time. Ideally I want to sum the quantities of the current row and the most recent row for each account.
Given the following as ...
- 775
-2
votes
0
answers
25
views
Deleted user Name root for local site. Common solutions haven't worked. ERROR 1045 (28000): Access denied for user 'root'@'localhost' [migrated]
Sorry if this is a silly question.
I'm running a local Wordpress website through WP engine with a MySQL database through AdminNEO on my browser and made a terrible mistake of deleting "root" ...
Advice
0
votes
6
replies
105
views
MySQL set the default unix time
Earlier, I set the time field, int type, to the default time value in unix format.
When adding an entry, the time field accepts the time since 1970 in unix format.
I'm trying to do the same with the ...
-1
votes
0
answers
103
views
How do I get a trigger to only delete an associated row in another table in SQL?
I currently have 3 tables:
CREATE TABLE IF NOT EXISTS customers(
ID int unsigned NOT NULL AUTO_INCREMENT primary key,
first_name varchar(50),
last_name varchar(50),
email_address ...
- 1
-11
votes
0
answers
144
views
Does parser_name stored somewhere in information_schema in MySQL
Or this index parameter is "fire and forget" one?
If I create a table in MySQL and then assign the FULLTEXT index to it its possible to assign a parser to such index.
One can use WITH PARSER ...
- 6,468
0
votes
0
answers
133
views
SQL JOIN returning duplicate rows instead of expected results [duplicate]
I am trying to combine data from two tables using a JOIN, but I am getting duplicate rows in the result instead of the expected output.
Here are my tables:
Customers
CustomerID
CustomerName
Orders
...
