Examples of string formatting

strings.py

command = "SELECT * FROM whatever"
print(command)

fieldname = "age"
command = "SELECT " + fieldname + " from whatever"
print(command)

fieldname = 'age'
fieldname2 = 16
command = "SELECT %s from whatever WHERE %s=%d" % (fieldname, fieldname, fieldname2)
# SELECT age FROM whatever WHERE age=16
print(command)

command = "SELECT {fieldname} FROM whatever WHERE {fieldname}={fieldname2}".format(fieldname='name', fieldname2='Divya')
print(command)