You can use INSERT…SELECT syntax. Note that you can quote ‘1’ directly in the SELECT part. INSERT INTO mt_magazine_subscription ( magazine_subscription_id, subscription_name, magazine_id, status ) SELECT magazine_subscription_id, subscription_name, magazine_id, ‘1’ FROM tbl_magazine_subscription ORDER BY magazine_subscription_id ASC
You use it like this: SELECT age, name FROM users UNION SELECT 25 AS age, ‘Betty’ AS name Use UNION ALL to allow duplicates: if there is a 25-years old Betty among your users, the second query will not select her again with mere UNION.
You can use INSERT… IGNORE syntax if you want to take no action when there’s a duplicate record. You can use REPLACE INTO syntax if you want to overwrite an old record with a new one with the same key. Or, you can use INSERT… ON DUPLICATE KEY UPDATE syntax if you want to perform … Read more
numpy has an insert function that’s accesible via np.insert with documentation. You’ll want to use it in this case like so: X = np.insert(X, 0, 6., axis=0) the first argument X specifies the object to be inserted into. The second argument 0 specifies where. The third argument 6. specifies what is to be inserted. The … Read more
As simple as this : INSERT INTO config (id, customer_id, domain) SELECT DISTINCT id, customer_id, domain FROM config; If you want “www.example.com” as the domain, you can do : INSERT INTO config (id, customer_id, domain) SELECT DISTINCT id, customer_id, ‘www.example.com’ FROM config;
You just need to add a RETURNING id to your INSERT … SELECT: WITH rows AS (…) INSERT INTO dealer (user_id) SELECT id FROM rows RETURNING id; Demo: http://sqlfiddle.com/#!12/75008/1
INSERT INTO table1 ( column1 ) SELECT col1 FROM table2 Like: insert into property.portfolio_property_xref ( portfolio_id , building_id , created_date , last_modified_date ) select 34, building_id, getdate(), null from #temp_buildings
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.
I would not recomend you to use document.write as others suggest, because if you will open such window twice your HTML will be duplicated 2 times (or more). Use innerHTML instead var win = window.open(“”, “Title”, “toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,width=780,height=200,top=”+(screen.height-400)+”,left=”+(screen.width-840)); win.document.body.innerHTML = “HTML”;
You should do batch inserts. Pseudocode: db.beginTransaction(); for (entry : listOfEntries) { db.insert(entry); } db.setTransactionSuccessful(); db.endTransaction(); That increased the speed of inserts in my apps extremely. Update: @Yuku provided a very interesting blog post: Android using inserthelper for faster insertions into sqlite database