mysql Questions

How to use nginx (intsalled on Docker) to reverse proxy MySQL (installed on Docker too)

January 29, 2023
StupidPz
2 Answers

Here is docker-compose.yaml services: nginx: image: nginx:1.23.3 container_name: nginx volumes: - /lnmpg/nginx/conf.d:/etc/nginx/conf.d:ro,cached - /lnmpg/nginx/nginx.conf:/etc/nginx/nginx.conf :ro - /lnmpg/nginx/log:/var/log/nginx - /lnmpg/nginx/html:/usr/share/nginx/html ports: - "80:80" - "443:443" - "33060:3306" environment: - TZ=Asia/Shanghai restart: always networks: - nginx-mysql mysql: image: mysql:5.7.41 # ports: #…

VIEW QUESTION

Django multiple table query – convert MySQL to Django (Python) query

January 29, 2023
APorto
2 Answers

I need to figure out how to translate MySQL query into Django (Python) language. Any help? Basically I need to get the total from each table plus the remain total after spend. class Trip(models.Model): name = models.CharField('Name', max_length=254) class Account(models.Model):…

VIEW QUESTION

Count Number of a Specific Day(s) Between Two Dates – Mysql

January 29, 2023
pty
4 Answers

I have a single line in MySQL table: volunteers user_id | start_date | end_date 11122 | 2017-04-20 | 2018-02-17 How can I find how many times the 3rd day or 24th day of a month appears? (i.e. 2017-05-03, 2017-06-03, 2017-12-24,…

VIEW QUESTION

Python MySQL – best practises. Create & connect

January 29, 2023
Majesty
2 Answers

could you advise me on best practices on how to deal with MySQL class in Python application? class DBClient: def __init__(self, db_name=None): self.conn = None self.db_name = db_name self.__create_connection() def __create_connection(self): try: self.conn = mysql.connector.connect( host="127.0.0.1", port=3306, user="root", password="password", database=self.db_name…

VIEW QUESTION

concat type int for 2 col in presto sql – Mysql

January 29, 2023
jonhatan_schilino
2 Answers

I have 2 columns of type int and I want to make a concat to two columns in presto syntax. it is possible? for example: id: 345 997 age: 23 55 new_col: 34523 99755 I was trying to use the…

VIEW QUESTION

Calling several SQL procedures at once with Python – Mysql

January 29, 2023
Mihael Manolov
2 Answers

I have made a stored procedure in MySQL which accepts several arguments and does its things. And while I have no problem to execute the following query in MySQL CALL my_pr(var1, var2, var3); CALL my_pr(var4, var5, var6); When I try…

VIEW QUESTION

Calculate active users by day, week and month – Mysql

January 29, 2023
Prabuddha Dasgupta
3 Answers

I have a temp_table with user_id and date and I want to find the DAU , WAU and MAU and I am querying this for that where: DAU - Count of active users for that day WAU - Count of…

VIEW QUESTION

How to modify a column to insert consequtive numbers? – Mysql

January 29, 2023
PPN
5 Answers

So I have a table where a column that was given an auto_increment value accidentally got started form 300 instead of 1,2,3,4......i'm a beginner and i do not know how to change it back to 1,2,3,4......screenshot of table how to…

VIEW QUESTION

MySQL: How can I optimize delete operation based on time?

January 29, 2023
Volatil3
2 Answers

So my colleague created this query which will run every hour on a table with 500K+ records. Delete from table where timestamp> now() - interval 24 hour I am having a feeling that this would be slower as it is…

VIEW QUESTION

Why do dot notation is required here in SQL query? – Mysql

January 29, 2023
ader
3 Answers

You are given a table, BST, containing two columns: N and P, where N represents the value of a node in Binary Tree, and P is the parent of N. Question - Write a query to find the node type…

VIEW QUESTION