In this post about SQLite , aaronasterling told me that cmd = "attach \"%s\" as toMerge" % "b.db" : is wrong cmd = 'attach "{0}" as toMerge'.format("b.db") : is correct cmd = "attach ? as toMerge"; cursor.execute(cmd, ('b.db', )) : is right thing But, I've thought the first and second are the same. What are the differences between those three?

"%s" % format vs "{0}".format() vs "?" format

In this post about SQLite, aaronasterling told me that

But, I've thought the first and second are the same. What are the differences between those three?