home
I have data in the form of CSV of 19GB, I want to try to import it into the database. maybe to...
I have 3 Database Tables: OpenROHeader OpenROData OpenRONotes Header & Data are updated...
I am trying to count rows which have a distinct combination of 2 columns in Amazon redshift. The...
I'm looking for feedback on my use of natural vs surrogate keys. Below are some examples coupled...
I am using sequelize js with nodejs in the backend server for a rest api. When I try to...
The grp column should be represent a block partitioned by GroupId, RouteId and ordered LengthStart...
I am trying to add several condition. I'd like to update base2 with sum of itself with an...
I have a table which have many column. One column has json value like { "RequiredForCompany":1,...
I am using SQLite. I create a table called MyTable, with 3 columns MyID, MyOrder, MyValue, all are...
I have problem on laravel. I want to showing percentage on with eloquent, but return null...
I am using a postgreSQL DB on my Rails app. I have established m-to-n relationships between Slots...
I have 3 employees in my table. I'm using this stored procedure to try and loop through and display...
Id Number Value ------------------ 1 6 1 2 6 2 3 9 2 I have a...
There is a PL SQL package which has been called by a job. I have run the job and I was monitoring...
Well, as the title states, it doesn't submit to the database if it's autocompleted, but does if it...
The management of the elasticsearch store is handled in-application. Suppose the application...
6 hours ago

#sql #bulkinsert

I have a text file like the image attached. I need to insert that data to sql table. with |APFSFE ...
I have this table called myTable and I would like to select all rows in which B = DFW, and also all...
This question already has an answer here: Oracle: not a valid month ...
create table Company(cname varchar(30) primary key, country varchar(30)); insert into Company...
I have researched this for two days now and cannot find anything that works for me, it may be my...
So I'm trying to create a table 'Prerequisite_to', which is basically a relation that shows what...
By unique, I mean if there is some value that has a duplicate, don't show either of...
So, I am using SQLite(Jupyter notebook) to solve a problem related to Pearson correlation...
How do we tackle this sort of question? I am stuck on the idea of 50% number of students enrolled...
I have to use a subquery in order to find all the orders that didn't have at least one item in...
Say,I have two tables T1 and T2(in sql). I only want to keep the rows in T1 which have same value...
I am trying to find the string start with D or K and end with 2 or 3 in Oracle SQL using...
I have a table called XMLData that stores an XML file in the Data column. The structure of the XML...
I'm getting array value from cart table and I want to insert cart array value into my order table...