create SQL table from existing table using pyodbc/turbodc in python

Question

I would like to create a SQL table from an existing table. I'm using the turbodbc module (which is very similar to pyodbc).

# connect to database
conn = turbodbc.connect(connection_string="my_connection_string")
cursor = conn.cursor()
# execute SQL code
cursor.execute((" create table Test_Puts as"
                " select * from OptionValue"
                " where call_put = 'P'"))

However, I get the error message:

ODBC error
state: 42000
native error code: 156
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'select'.

Try to put your select code in brackets () start before select and end after 'P' — VBoka
– VBoka, Commented Mar 4, 2020 at 7:18
@VBoka I get "Incorrect syntax near '('" , native error code 102 — thomas.mac
– thomas.mac, Commented Mar 4, 2020 at 7:21

VBoka · Accepted Answer · 2020-03-04 07:23:58Z

2

Try to use this syntax:

select * into Test_Puts from  OptionValue where call_put = 'P'

So, instead of this:

" create table Test_Puts as"
" select * from OptionValue"
" where call_put = 'P'"

use this:

" select * into Test_Puts"
" from  OptionValue"
" where call_put = 'P'"

answered Mar 4, 2020 at 7:23

VBoka

9,0933 gold badges19 silver badges27 bronze badges

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

4 Comments

VBoka Over a year ago

Hi @thomas.mac , so, does this helps ? Thanks for the feedback.

thomas.mac Over a year ago

thanks for the answer, the upside is it does not get an error, but the downside is it takes a very long time to run, so not sure what end result looks like. Is there more an efficient way to run the code?

VBoka Over a year ago

Hi @thomas.mac what is the number of rows you are selecting ?

thomas.mac Over a year ago

670 million rows !

Collectives™ on Stack Overflow

create SQL table from existing table using pyodbc/turbodc in python

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related