I'm working on a project with mySQL(8.0.19) The task requires the creation of various tables, with appropriate referential constraints and then filling them with large amounts of data to perform queries and other functions. I've got 2 large CSV files…
How do I get multiple data with same user id from a table in nestjs? suppose I have a user table. How can I get user id matched data? import { Injectable } from '@nestjs/common'; import { InjectRepository } from…
I've got a big table (~500m rows) in mysql RDS and I need to export specific columns from it to csv, to enable import into questDb. Normally I'd use into outfile but this isn't supported on RDS as there is…
I do have one table with 2 columns and another with 2 columns employee(id, transaction_date), employee_1(id, transaction_date) Below is the query i tried, but it's returning an error SELECT COUNT(DISTINCT id) / COUNT(DISTINCT id) FROM employee, employee_1 Error is SQL…
I have a sales table, where it shows the information below ID_sale sales_person sale_date 7 50 19/10/2022 6 43 17/9/2022 5 50 15/3/2022 4 43 13/2/2022 2 50 22/1/2022 3 10 05/2/2022 1 12 07/1/2022 and I want to create…
What's the best approach to store multiple images in database? Upon browsing and searching for solution and approaches I found 2 options first one is take the file name and concatenate and separate them using either comma or | but…
What I am trying to do is to get the same column result twice with a single query. SELECT appellation FROM persona WHERE character_id IN (853,12,853) ORDER BY FIELD(character_id,853,12,853) This returns the result: character_id | appellation --------------------------- 853 | John…
I have a table with integer ID as primary key--auto increment. Because of frequent delete/insert, the ID values are like 1 1000 2340 5420 .... I want it always to be 1 2 3 4 .... So is there a…
I have two tables that have the same columns; AgencyA & AgencyB. Columns; Subject, Event_Combined and License_Fee. How can I combine the columns for each table? IE Subject column will have all the data from AgencyA and AgencyB. Ive tried…
I've built a simple website with authorization and registration system. So I have user accounts and I wonder where to store profile pictures for every user. I tried to store them in MYSQL in BLOB, but I don't think it…