Update using multiple JOINs in MySQL/Python
The first set of questions were deemed too similar to another post (it wasn't) and were closed... so I've made another attempt here, hopefully better worded this time. Some background: We have a relationship here. Securities (coins) + currencies (base coins) form a pair. A pair and a broker form an ...
P粉512526720 2023-09-12 21:19:12 0 1 311
Is it wise to create different tables for the same data for each date?
I have a MYSQLInnoDB table with the following columns (table and column names changed): date (PK, date) var_a (PK, FK, INT) var_b (PK, FK, INT) rel_ab (decimal) where rel_ab is the description Column of relationship between 2 variables var_a and var_b given date. (var_a and var_b refer to different ...
P粉665679053 2023-09-09 17:40:44 0 2 195