insert

insert then update inside loop

Hi Guys, I have a php script, I use it to be run in as cron job. When this script running it takes about 13 minutes on 16000 user records. Please advice me to make this script running with the best performance. I need to know that if there is any problem if i put update then insert inside a loop, or insert then update inside a loop. ...

In PHP, when using PDO with pgSQL how to get the value of "RETURNING" clause in the original INSERT sql query.

In PHP, I am using PDO with the pgSQL drivers. I wanted to know how to get the value of the "RETURNING" clause given in the INSERT sql query. My current code looks like this, $query = 'INSERT INTO "TEST" (firstname, lastname) VALUES ('John', 'Doe') RETURNING user_id'; $queryHandle = $connection->prepare($query); $queryHandle->execute();...

sqlite python insert with where condition

from this post http://stackoverflow.com/questions/2130641/sqlite-python-insert I learned inserting into tables but now I need to use where something like cursor.execute("insert into table1(id) values (?) where ip=? and address=?",(id,),(ip,),(addr,)); ...

MySQL insert into when number of columns don't match number of values

Hi, I have an insert sql statement, e.g. INSERT INTO table_a (col_a, col_b, col_c, col_d) VALUES (1, 2, 3, 4), (2, 1, 6, 9), (3, 1, 4, 5) I want to insert this into another table, however the table I want to insert it into has a different structure to that of the sql statement (it has fewer fields) e.g. table_b has columns 'col_a', ...

Inserting into database with stmt and mysqli

Hi there i'm playing with stmt for the first time (looking at converting my code over after previously using standard mysqli functions through an extension class. However I can't seem to get it working. I'm using PHP 5.2.11 and mysql 4.1.22. I've got a table structure like so: CREATE TABLE IF NOT EXISTS `tags` ( `tag_id` smallint(3...

What should be returned when inserting into SQL?

A few months back, I started using a CRUD script generator for SQL Server. The default insert statement that this generator produces, SELECTs the inserted row at the end of the stored procedure. It does the same for the UPDATE too. The previous way (and the only other way I have seen online) is to just return the newly inserted Id back ...

Syntax for INSERTing into a table with no values?

I have a table created with the following schema: CREATE TABLE [dbo].[Visualizations] ( VisualizationID int identity (1,1) NOT NULL ) Since the table has no settable fields, I'm not sure how to insert a record. I tried: INSERT INTO [Visualizations]; INSERT INTO [Visualizations] () VALUES (); Neither work. What is the p...

saving checkbox values in vb.net

i have 50 checkboxes for 50 american states. The user can choose all 50 or only 1( so basically any number he wants). Based on his choice, I want to insert or update the table in sql server 2008. e.g- Color = blue and chk1=check, chk2= check and chk3 = check (chk = checkbox). now the user wants to ad 10 more states to this or remove the...

Inserting very many rows in to SQL 2005

I have a project where I need to build a two tables in sql 2005 and fill them with data (they are look-up tables for weather a name is a male's name or a female's name) I have 7354 male names to insert and 7776 female names to insert. currently I do it CREATE TABLE #NamesMale ( [FirstName] [varchar](50) NOT NULL, [MaxRank] [smallint...

How to insert form data into MySQL database table

So I have this registration script: The HTML: <form action="register.php" method="POST"> <label>Username:</label> <input type="text" name="username" /><br /> <label>Password:</label> <input type="text" name="password" /><br /> <label>Gender:</label> <select name="gender"> <optgroup label="genderset"> <opt...

MySQL Insert on Duplicate Key.

I am building a rating system, and i want to insert a new row, if the name field does not already contain the name i want to insert, and if it does exist, i want to increase the count field by 1 For example, if i have a row the the name 'Tom' and i try to insert another row with the name 'Tom, then i want to +1 for the field count on th...

When is a database table locked?

Is a table locked every time I insert sth. in it? Because I want to insert thousands of rows each second so I want to know if having more than one thread for inserting helps effectively or not. If each insert locks the table just one thread is almost as efficient as for example 10 threads. If it depends on the Database engine, I use SQL ...

Inserting email headers into mysql field quotes and slashes issue

I am trying to insert email headers read from impap in to a mysql text field. Problem is the headers are full of slashes, commas, quotes, line feeds. mysql_escape doesnt come near it. The different mail server responses can lead to quite different headers. Do i have to do some weird voodoo before storage? ...

please help me to create multi insert query.

i have got two table create table t1(cid int, isnews int) create table t2(nid int,cid int, isnews int) situations is like this: if t2 contain t2.cid = t1.cid then the t2.isnews = t1.news and if t2 not contain cid of t1 then new record should be inserted in t2 and that t1.cid, t1.isnews should be inserted in t2.. and complete ta...

SQL Server (T-SQL) Insert if Don't Exist.

Question How can I alter the SQL code below to ensure that the inserts into "dbo.tblBootStrapperInstruments" only occur if they don't already exist? Code INSERT INTO dbo.tblBootStrapperInstruments (CCY, Instrument, Tenor) SELECT CCY,Instrument,Gridpoint FROM dbo.Feed_Murex_Intraday_DF mx WHERE NOT EXISTS (SELECT * FROM dbo.tblBootStr...

ignore insert of rows that violate duplicate key index

I perform an insert as follows: INSERT INTO foo (a,b,c) SELECT x,y,z FROM fubar WHERE ... However, if some of the rows that are being inserted violate the duplicate key index on foo, I want the database to ignore those rows, and not insert them and continue inserting the other rows. The DB in question is Informix 11.5. Curre...

How can I copy all fields of one table to another, wider table in SQL Server 2005 Express?

I know my title isn't exactly worded well, so let me clarify. I'm using SQL Server 2005 Express. I have a table that basically stores a "template," if you will. Using a car as an example, the fields would be something like: TemplateID Color Make Model Now, I have another table that represents an "instance" of the template. It cont...

For loop only inserts one filename

for($i = 0; $i < $uploadsNeeded; $i++){ $file_name = $_FILES['uploadFile'. $i]['name']; $file_name = stripslashes($file_name); $file_name = str_replace("'","",$file_name); $uploaddir = "media/files/".$_FILES['uploadFile'. $i]['name']; $copy = move_uploaded_file($_FILES['uploadFile'. $i]['tmp_name'], $uploaddir); if($copy){ ...

nHibernate batch insert doesn't work with associations?

I'm trying to find more information about how nHibernate decides how to batch multiple inserts together. Apparently it just works if you have a simple list of objects of the same type, with no children objects. In my application, I have a one-to-many relation between three tables A, B, and C: A has many B, B has many C. I'm using a nati...

How to useOffice Insert Symbol dialog and insert the selected symbol at desired place in vb.net app?

I am developing a Windows app, where i have a infragistic grid. Inside that grid their is a column having dropdwn from which i have to invoke Words , Insert Symbol Dialog. I somehow managed to open the dialog but when i choose the symbol from the dialog , it pastes the symbol on the new word doc, instead i want it on the cell from where ...