Warning: file_put_contents(sites/nerkn/cache/containers/queryList/select_s_from_pages_where_pageTypeproject1.file.php): failed to open stream: No such file or directory in /home/erkintek/nerkl/inc/classBasic.php on line 247

Warning: file_put_contents(sites/nerkn/cache/containers/queryList/select_s_from_pages_where_pageTypeproject1.file.php): failed to open stream: No such file or directory in /home/erkintek/nerkl/inc/classBasic.php on line 247

Warning: file_put_contents(sites/nerkn/cache/containers/queryList/select_s_from_pages_where_pageTypeknowlagebase1.file.php): failed to open stream: No such file or directory in /home/erkintek/nerkl/inc/classBasic.php on line 247

Warning: Cannot modify header information - headers already sent by (output started at /home/erkintek/nerkl/inc/classBasic.php:247) in /home/erkintek/nerkl/inc/layout.php on line 227
multiple ON DUPLICATE KEY UPDATE

Nerkn

Php developer, drupal, html, css, jquery, ajax, javascript
s:147:"

multiple ON DUPLICATE KEY UPDATE

Here is an example of how to update multiple columns using values supplied in the INSERT statement. This assumes that column 'a' is the unique key. INSERT INTO table (a,b,c,d,e) VALUES (1,2,3,4,5) ON DUPLICATE KEY UPDATE b=VALUES(b), c=VALUES(c), d=VALUES(d), e=VALUES(e); This also works for multiple rows: INSERT INTO table (a,b,c,d,e) VALUES (1,2,3,4,5), (6,7,8,9,10) ON DUPLICATE KEY UPDATE b=VALUES(b), c=VALUES(c), d=VALUES(d), e=VALUES(e); If you have a lot of columns it would be nice if you could use the following syntax: INSERT INTO table (a,b,c,d,e) VALUES (1,2,3,4,5) ON DUPLICATE KEY UPDATE VALUES(b,c,d,e); and it would match the columns you want to update with the values in the INSERT. Unfortunately, this does not work. You MUST explicitly provide each column assignment.";