For the field to be able to store unicode characters, you have to use the type nvarchar (or other similar like ntext, nchar). To insert the unicode characters in the database you have to send the text as unicode by using a parameter type like nvarchar / SqlDbType.NVarChar. (For completeness: if you are creating SQL … Read more
Sure, you can use slice indexing: a_list[1:1] = b_list Just to demonstrate the general algorithm, if you were to implement the my_extend function in a hypothetical custom list class, it would look like this: def my_extend(self, other_list, index): self[index:index] = other_list But don’t actually make that a function, just use the slice notation when you … Read more
You can use the INSERT … SELECT statement to get the MAX()+1 value and insert at the same time: INSERT INTO customers( customer_id, firstname, surname ) SELECT MAX( customer_id ) + 1, ‘jim’, ‘sock’ FROM customers; Note: You need to drop the VALUES from your INSERT and make sure the SELECT selected fields match the … Read more
I dont know exactly if this fits the requirement for a “random description”, and it’s not clear if you want to generate the full data: but, for example, this generates 10 records with consecutive ids and random texts: test=# SELECT generate_series(1,10) AS id, md5(random()::text) AS descr; id | descr —-+———————————- 1 | 65c141ee1fdeb269d2e393cb1d3e1c09 2 | … Read more
You use a move_iterator with insert: v1.insert(v1.end(), make_move_iterator(v2.begin()), make_move_iterator(v2.end())); The example in 24.5.3 is almost exactly this. You’ll get the optimization you want if (a) vector::insert uses iterator-tag dispatch to detect the random-access iterator and precalculate the size (which you’ve assumed it does in your example that copies), and (b) move_iterator preserves the iterator category … Read more
Unfortunately not. You can get half-way there by not having to repeat the value: INSERT INTO `tableName` (`a`,`b`,`c`) VALUES (1,2,3) ON DUPLICATE KEY UPDATE `a`=VALUES(`a`), `b`=VALUES(`b`), `c`=VALUES(`c`); But you still have to list the columns.
Import data COPY everything to a temporary staging table and insert only new titles into your target table. CREATE TEMP TABLE tmp(title text); COPY tmp FROM ‘path/to/file.csv’; ANALYZE tmp; INSERT INTO tbl SELECT DISTINCT tmp.title FROM tmp LEFT JOIN tbl USING (title) WHERE tbl.title IS NULL; IDs should be generated automatically with a serial column … Read more
As it was stated, chunks won’t really help you in this case if it is a time execution problem. I think that bulk insert you are trying to use cannot handle that amount of data , so I see 2 options: 1 – Reorganise your code to properly use chunks, this will look something like … Read more
The easiest way is to simply use the stmt.setString(position, xml); methods (for “small” strings which can be easily kept in Java memory), or try { java.sql.Clob clob = oracle.sql.CLOB.createTemporary( connection, false, oracle.sql.CLOB.DURATION_SESSION); clob.setString(1, xml); stmt.setClob(position, clob); stmt.execute(); } // Important! finally { clob.free(); }
Your solution: INSERT INTO Words (Word) SELECT @Word WHERE NOT EXISTS (SELECT WordID FROM Words WHERE Word = @Word) …is about as good as it gets. You could simplify it to this: INSERT INTO Words (Word) SELECT @Word WHERE NOT EXISTS (SELECT * FROM Words WHERE Word = @Word) …because EXISTS doesn’t actually need to … Read more