Lab Sql

I've noticed an error during an insert query in my database. mysql> insert into users (name)… Read more Mysql Insert Query Returns Error 1062 (23000): Duplicate Entry '2147483647' For Key 'primary'

I have two different query (having same no. of columns in result). I want to put both in one table.… Read more Add Two Different Queries Result Into One Table

I have a program that I use to read CSV file and insert the data into a database. I am having troub… Read more Insertion Efficiency Of A Large Amount Of Data With Sql

I have read the other questions and all of the posted comments/answers to questions that are simila… Read more Place An Insert Statement Into A Select Statement

I've been searching for a couple of hours now and cannot find a solution. I am inserting some s… Read more C# & Sql Server : How To Insert Dbnull.value In Command Parameter If String Value Is Empty?

I'm building a system for updating large amounts of data through various CSV feeds. Normally I … Read more Best Practices For Inserting/updating Large Amount Of Data In Sql Server 2008

The error When I have a new record, I don't have a problem. When I have an existing record I… Read more Rails: Attempting Save An Existiing Row But Rails Generates Sql Insert Instead Of Update

I have table T1 in database DB1 and table T2 in database DB2, those tables have almost identical se… Read more Postgresql Insert From Select With Additional Column

We have a user table, every user has an unique email and username. We try to do this within our cod… Read more Adding A Constraint To Prevent Duplicates In Sql Update Trigger

I have 2 tables: Empleados(**numEmpl**, nombre, apellido, sexo, telefono, salario, numDept) Departa… Read more Insert In Tables With Circular References Sql

There's this scenario which involves inserting into a table by copying some columns from anothe… Read more Alternative To Returning With Insert...select

declare @us table(name nvarchar(100),lastname nvarchar(100),UID bigint,available bit); decl… Read more Insert Statement Cannot Contain A Select Statement -sql Server2012

I am trying to create a writers table that contains the author ID, last name, first name, and ISBN … Read more How Do I Create A Table With Constraints While Pulling Data From Another Table

I'm trying to store a picture in sqlite3 table. I'm using python and sqlite3. Please let me… Read more How Do I Store A Picture In A Table With Python-sqlite3?

I'm experiencing a strange issue when importing data into postgres. I have an import script tha… Read more Postgres 9.6: Inserts Very Slow After Reboot

First I am really new to pl/pgsql. Need it for a project. I am stuck with this (simplified) problem… Read more Passing A Record As Function Argument Pl/pgsql

I am using following method for inserting multiple rows using a single INSERT statement, that is th… Read more Sql Server – Inserting Multiple Rows With Single (ansi Style) Statement

I have a question in hand where i need to restrict the number of projects assigned to a manager to … Read more Allow Only 3 Rows To Be Added To A Table For A Specific Value

I am trying to implement a rating system where I keep the following two fields in my db table: rati… Read more Mysql How To Insert New Record Or Update A Field Depending On Whether It Exists?

create table employee ( employee_id number (5), first_name varchar2(100), last_name v… Read more Inserting Multiple Rows Into Table - Getting Error Ora-00933: Sql Command Not Properly Ended