Python sqlite - quotes usage in execute() method

Question

While reading through python sqlite3 DB-API, the first example of creating table uses thee single quotes:

c.execute('''CREATE TABLE stocks
             (date text, trans text, symbol text, qty real, price real)''')

But in other examples there are double quotes:

cur.execute("create table people (name_last, age)")

So I've got 2 questions:

1. It this really any difference? How can it affect create table command?

2. Which one is better to use with parameters? ex.:

   c.execute('''CREATE TABLE %s(date text, trans text, symbol text, qty real, price real)''' % table_name)

VS.

 cur.execute("create table %s (name_last, age)" % table_name)

Thanks

Answer 1

There is basically no rule for double or single quotes.

But three consecutive quotes start multiline quoted values.

Answer 2

Is this really any difference? How can it affect create table command?

Using single/double quoted string or a triple-quoted string doesn't affect the create command in any way. They are ultimately just string arguments to the create command.

Which one is better to use with parameters?

Double quotes are the norm in most of the python programs. Triple quotes are used mostly when you have a big multi-line string copy-pasted from somewhere else and you want to embed them in your program. In the link that you gave above, we can see one such example in the usage in cursor.executescript(), where an sql script (which probably existed before) is used within the program.