How do I add a column in mysql using python by taking the input of the user of what the column name should be

Question

How do I add a column or multiple columns by asking the user for input and adding the columns based on that in mysql using python?

I tried using the for loop and %s but that doesn't seem to work here