Hello all how can get two same name column from two different table as single result in two different column as combine result. Eg: customer table have column customerid custmerId customerName 1 row 2 row Order Table it has also…
let's say i have this id center right 1 Two NULL 1 NULL Three and want to be like this id center right 1 Two Three my first table is just a representation of what actually I am encountering, everything…
I'm trying to sort a MySQL table data based on a column values. id record_number created_at updated_at 1 ent/4/2022 2022-10-24 20:34:25 2022-10-24 20:34:25 3 ent/6/2021 2022-10-24 20:35:03 2022-10-24 20:35:03 The column is named record_number and the values of column follow…
Before I state the issue I'll mention I'm using PHP and laravel 9, and my database is mysql with the following charset and collation: 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', I am working with ADIDs and a table called devices…
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…