Answers for "insert into mysql subquery"

insert into mysql subquery

INSERT INTO qa_costpriceslog (item_code, invoice_code, item_costprice)
  SELECT
    /* Literal number values with column aliases */
    1 AS item_code,
    2 AS invoice_code,
    item_costprice
  FROM qa_items 
  WHERE item_code = 1;

Posted by: Guest on October-09-2020

Code answers related to "insert into mysql subquery"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "insert into mysql subquery"

Code answers related to "insert into mysql subquery"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "insert into mysql subquery"

Code answers related to "insert into mysql subquery"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us