var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: how to write this insert sql statement
If I have tbl1, tbl2, I want to insert rows into col1 from tbl2, but also another extra column with give value?
Does anybody know how to write this inser sql statement? Thanks a lot
INSERT INTO yourTable (field1, field2, someotherfield)
SELECT col1, col2, 'your-defined-value'
If the third value is going to be unique to each row, you will have to iterate through your source dataset and use the INSERT INTO ... VALUES syntax instead.