Multiple SQL statements in pandas.read_sql

Question

So I have a SQL query with has the following structure:

CREATE TEMPORARY TABLE a
Select id, time
from t1 ;

CREATE TEMPORARY TABLE b
Select id, views
from t2 ;

Select a.id, a.time, b.views from a join b on a.id=b.id;

Which is saved in a .sql file that I want to read in pd.read_sql()

However, since there are multiple SQL statements it does not seem to work.

Any clues on where to look at?

Thanks

Different problem: my final query is the result of the merge of two temp tables — mcpj
– mcpj, Commented Nov 12, 2018 at 17:47

Developer · Accepted Answer · 2019-07-12 15:43:01Z

0

You need a "SET NOCOUNT ON" at the top of your script. This will avoid returning the empty result set for number of rows inserted by first 2 inserts.

answered Jul 12, 2019 at 15:43

Developer

1257 bronze badges

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

Collectives™ on Stack Overflow

Multiple SQL statements in pandas.read_sql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related