i had a table named xyz in mysql Aurora DB, which has Table_Name, Table_ID,QuerySeq,sql_query,view_name. Now i need to read the table in pyspark, run the sql queries(using spark.sql) present in sql_query according to QuerySeq and create a view for the…
Mysql stored procedure is not returning any out put wnen execute as a stored procedure. but when i execute as separate sql statement for every out parameter its returning output . can u please help me the reason as i…
Let's assume below table orders_daily_data in which we store number of orders made for a given product across the time: ID ProductType Orders OrderDate 1 sugar 5 2023-01-04 2 flour 0 2023-01-04 3 pepper 7 2023-01-04 4 sugar 1 2023-01-05…
I have a table for managing items in a warehouse with the following schema: CREATE TABLE `item` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `barcode` varchar(45) DEFAULT NULL, `sku` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `barcode_UNIQUE` (`barcode`) )…
I have a mysql column(name) with some text like this "firstname middlename surname lastname". How can i select that row with a query like SELECT name FROM client WHERE name like %firstname lastname% . The where clause comes from a…
I have a table as follows; RECORDREF SHIFTREF DATECREATED 1 3 2023/09/19 2 3 2023/09/19 3 3 2023/09/19 4 3 2023/09/20 5 4 2023/09/20 6 4 2023/09/20 7 4 2023/09/20 8 4 2023/09/20 9 5 2023/09/20 10 5 2023/09/20 11…
Created a table with some columns of type TIME(3) Loaded from a CSV file 0:07.763 0:07.783 0:07.276 0:07.484 0:07.127 Running select * from some_table yields the following: 00:00:07.763 00:00:07.783 00:00:07.276 00:00:07.484 00:00:07.127 My question is: How can I get this…
I am trying to fetch unique aocDetailIds in spring boot should I use distinct keyword(Code Block 1) or should I create a SET of strings(Code Block 2) , which will be more optimised ? @Query(value = "SELECT DISTINCT a.aocDetailId FROM…
I am learning SQL and have created the following dataset in MySQL: Create table Departments (DepartmentID int primary key, Name text); insert into Departments values (1001,'SRO'), (2001,'Drs'), (3001,'Accounting'); Create table Employees ( EmployeeID int not null, DepartmentID int not null,…
how can I store large decimal values in MYSQL? I have tried to use the decimal(10,9) but the value ends up being transformed to: 99999999.99 Example: 2110624448.26533720 Expected save value: 2110624448.26533720 Thanks in advance