insert

mysql multiple insert - what happens on error?

What happens in mysql multiple records insert during an error. I have a table: id | value 2 | 100 UNIQUE(id) Now i try to execute the query: INSERT INTO table(id, value) VALUES (1,10),(2,20),(3,30) I will get a duplicate-key error for the (2,20) BUT... Will the (1,10) get into the database? Will the (3,30) get into the database?...

SQL Server insert performance

I have an insert query that gets generated like this INSERT INTO InvoiceDetail (LegacyId,InvoiceId,DetailTypeId,Fee,FeeTax,Investigatorid,SalespersonId,CreateDate,CreatedById,IsChargeBack,Expense,RepoAgentId,PayeeName,ExpensePaymentId,AdjustDetailId) VALUES(1,1,2,1500.0000,0.0000,163,1002,'11/30/2001 12:00:00 AM',1116,0,550.0000,850,NU...

Select and Insert across dblink

I am having a bit of trouble with a select into insert across a dblink in oracle 10. I am using the following statement: INSERT INTO LOCAL.TABLE_1 ( COL1, COL2) SELECT COL1, COL2 FROM REMOTE.TABLE1@dblink s WHERE COL1 IN ( SELECT COL1 FROM WORKING_TABLE) When I run the statement the following is what gets run against the remote ser...

ignore some values in insert into select from sql stament

Suppose that I have a Table Symbols(Symbol, Value) and a Table SymbolValues (Symbol, Value) which contains a list of values for the symbol. How to choose maximum values fromt he SymbolValues table and insert into Symbols table. For Example, The SymbolValues Table has following values A 1 A 2 A 3 B 6 B 7 Then only A 3 and B 7 should b...

How can I execute an insert with data from a repeater-generated form whose data source is SQL?

I'm storing multilingual data in a database whose model is language normalized (like this). For this particular problem the key for the table in question consists of a value entered by the user and a language from the language table. I'd like to dynamically generate a form with input fields for all available languages. The user inputs...

Insert ADO.Net DataTable into an SQL table

The current solution i implemented is awful! I use a for... loop for inserting records from an ADO.NET data-table into an SQL table. I would like to insert at once the data-table into the SQL table, without iterating... Is that possible, or am i asking too much? ...

How can I perform an idempotent insert row using subsonic with a SQL 2008 backend?

How can I perform an idempotent insert row using subsonic with a SQL 2008 backend? e.g. I have a table "Colors" where name is the primary key. Color c = new Color; c.name = "red"; c.Save; Color c2 = new Color; c2.name = "red"; c2.Save; // throws duplicate key error; I know I can just trap the error but I would prefer to do somethi...

Insert rows into MySQL table while changing one value

Hey all- I have a MySQL table that defines values for a specific customer type. | CustomerType | Key Field 1 | Key Field 2 | Value | Each customer type has 10 values associated with it (based on the other two key fields). I am creating a new customer type (TypeB) that is exactly the same as another customer type (TypeA). I w...

How to insert data into database using jsonreader in JSP

Hai can u please tell me how to insert, delete data into and from table using jsonReader in jsp ...

Is the time cost constant when bulk inserting data into an indexed table?

I have created an archive table which will store data for selecting only. Daily there will be a program to transfer a batch of records into the archive table. There are several columns which are indexed; while others are not. I am concerned with time cost per batch insertion: - 1st batch insertion: N1 - 2nd batch insertion: N2 - 3rd b...

Access Insert Query

I am using C# to write/read to an Access 2007 Database. The table is ID - AutoNumber [pkey] Fname - Text Lname - Text Address - Text The query string I Use is "Insert into TblMain (Fname,Lname,Address) Values ('"+fname+"','"+lname+"','"+adrs+"')" No errors are returned, the query executes but data is not added to the db. Inserti...

Problem with PHP & SQL Query

I have a problem in php code inserting values into database (I use PHPMyAdmin). My DATABASE has 3 tables: Member with this fields: MemberID, MemberName Room with this fields: RoomID, RoomName Join with this fields: MemberID, RoomID The idea is to join the member in the room. My query was mysql_query("INSERT INTO join (RoomID, Mem...

SQL statement to split a table based on a join

I have a primary table for Articles that is linked by a join table Info to a table Tags that has only a small number of entries. I want to split the Articles table, by either deleting rows or creating a new table with only the entries I want, based on the absence of a link to a certain tag. There are a few million articles. How can I do ...

How do I initialize the controls in an InsertItemTemplate?

I have - for instance - an asp:FormView which supports Read, Insert, Update, Delete and is bound to a DataSource: <asp:FormView ID="FormView1" runat="server" DataSourceID="ObjectDataSource1" > <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Bind("MyText") %>' /> </ItemTemplate> <EditItemTemplate> ...

SqlDateTime overflow on INSERT when date is correct using a Linq to SQL DataContext

Dear Linq experts, I get an SqlDateTime overflow error (Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.) when doing an INSERT using an Linq DataContext connected to SQL Server database when I do the SubmitChanges(). When I use the debugger the date value is correct. Even if I temporary update the code to set the date ...

Insert XML with more than 4000 characters into a Oracle XMLTYPE column

Hi, I have an oracle table with a column from type "SYS.XMLTYPE" and a storage procudure which is doing the insert: (Short version): PROCEDURE InsertXML ( pXMLData IN LONG ) IS BEGIN INSERT INTO MY_TABLE (XML_DATA) VALUES(pXMLData); END InsertXML; I call this sp from my C# code with type "OracleType.LongVarChar". Now t...

C# TableAdapter.Update() is using UPDATE rather than INSERT

SELECT WO_BreakerRail.ID, indRailType.RailType, indRailType.RailCode, WO_BreakerRail.CreatedPieces, WO_BreakerRail.OutsideSource, WO_BreakerRail.Charged, WO_BreakerRail.Rejected, WO_BreakerRail.RejectedToCrop, COALESCE (WO_BreakerRail.Date, @date) AS Date FROM indRailType LEFT OUTER JOIN ...

php/mysql - PDO prepared insert, does not work, and no error messages.

I really have NO idea of what to do with this now, i have been staring at it for hours, and reqritten it.. i can't get it to work!. require_once("Abstracts/DBManager.php"); require_once("UI/UI.Package.php"); class BlogDBM extends DBManager { private $table = "blog_records"; function saveRecord($title,$url,$desc,$feedId,$pubDat...

entity framework insert bug

I found a previous question which seemed related but there's no resolution and it's 5 months old so I've opened my own version. http://stackoverflow.com/questions/1545583/entity-framework-inserting-new-entity-via-objectcontext-does-not-use-existing-e When I insert records into my database with the following it works fine for a while ...

python MySQLdb got invalid syntax when trying to INSERT INTO table

COMMENT OUT below just for reference "" cursor.execute (""" CREATE TABLE yellowpages ( business_id BIGINT(20) NOT NULL AUTO_INCREMENT, categories_name VARCHAR(255), business_name VARCHAR(500) NOT NULL, business_address1 VARCHAR(500), business_city VARCHAR(255), business_state...