%%sql vs %sql - Githubissues

catherinedevlin / ipython-sql

%%sql magic for IPython, hopefully evolving into full SQL client

MIT License

1.79k stars 368 forks source link

Open techtonik opened 4 years ago

techtonik commented 4 years ago

Excuse me for probably an obvious question, but still I have to ask.

What is the difference between %sql and %%sql commands?

EminUZUN commented 4 years ago

%sql is line magic. You must finish your statement in this line. %%sql is cell magic. Your query can have multiple lines.