How to insert values into table by using inner query as select statement using Python Flask and PyOdbc? Input of Inner queries fetched from HTML form

Question

Environment Details. Windows 10 - Python3.5 - Flask - SQL SERVER - PyOdbc.

cur.execute("insert into T1 (ID_CUSTOMER, ID_ENVIRONMENT) values (?, ?)",
                    select id from CUSTOMER where name = form['customerId'],
                    select id from ENVIRONMENT where name = form['environmentId'],
                    )

Shikhar Arora · Accepted Answer · 2019-12-25 07:52:35Z

2

Remove the values, you can directly use INSERT SELECT.

INSERT INTO T1 
            (ID_CUSTOMER, 
             ID_ENVIRONMENT) 
SELECT ID_CUSTOMER =(SELECT Max(id) 
                     FROM   customer 
                     WHERE  NAME = 'abc'), 
       ID_ENVIRONMENT = (SELECT Max(id) 
                         FROM   environment 
                         WHERE  NAME = 'xyz')

The Max(id) here is to make sure the inner query returns a single value

answered Dec 25, 2019 at 7:52

Shikhar Arora

8861 gold badge9 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to insert values into table by using inner query as select statement using Python Flask and PyOdbc? Input of Inner queries fetched from HTML form

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related