I'm creating a Python script to insert some records in a table, but have the following problem: INSERT INTO orders VALUES (7656940929251, "ADIDAS | KID'S STAN
I'm trying to get the row number of records in my database table, I'm using a variable and am executing the query, I get no errors, but get a null column for nu
Employee_table Id FirstName LastName Division 1 John Smith A 2 Emily Jones B 3 John Smith B 4 John Snow A 5 John Smith C I want to move all duplicate names fr
I have a table like this, id date start end product result 10 2022-06-10 2022-02-10 2022-06-12 183 TRUE
Using SQL I have | Message_From | Message_To |Message| Message_Time(Current TimeStamp)| | -------------| ------------|------ | -------------------------------|
I'm looking for a solution where the database schema and data are maintained in xml or in some file format, so that the db schema and the data
There is a mysql query, and I need to implement it in a postgresql query. create table objects( object_id int NOT NULL PRIMARY KEY , city_id int not null , p
I have this kind of date table: I want to find/detect all blank dates between them, or showing how many days it skipped. I tried: SELECT date FROM tbl_attenda
I am trying to insert a data frame row in a mysql table, but I have NA values in character and numeric columns. I'm getting this error: Error in .local(conn, st
When I passing parameters a1 as "a1", a2 as ["a21","a22"] @Query(value = "select * from a where if(:a1 !='', a1=:a1,1=1)" + "and if(:a2 !='',a2 in (
I have 2 tables with entries as: Transition table: From_Status_Id To_Status_Id PU_Id 5 1 868 5
SQL Noob here. I'm struggling with a (hopefully) simple SQL query and would appreciate if someone could help me understand if what I'm trying to do is even poss
I have one query result as: Wname NewCases Mon 2 Tues 1 Sat 3 Second query result as: Wname FollowUp Tues 3 Wed 4 Frid
I have data like this Id Revision_Id A_Id A_Name A_Info ================================================ 1 0 111 A1 A
I have a table like this I would like to select the Itemid that occurs more than once with a different Rate with group by Masterid The output should be somethi
I am working on an App connecting to the Snowflake database. I stumbled upon an issue while loading CSV files. I was using the NULL_IF condition in copy command
I have a .bat file that contains two commands: SQLCMD -S . -d "databaseName" -E -i "path_to_query1.sql" -y0 -s "|" -f o:65001 > outputPath1.json SQLCMD -S
we have an SP where the SP executes and returns multiple result set with change in column number as below: create proc test ab as select 1 as num1 select 1 as
how to move the datagridview record value column to another record column and then save it into the database in the vb.net. What I mean as follows is move the r
I found this picture in a document. It shows the queries running on a given SQL database. It looks similar to DBeaver software. However, I couldn't find a way t