Many new MySQL columns with one form

Question

I want to put a form on my website to let users add events to their private calendar. For that, I would like to create a new column in MySQL each time the user add an event (always with the same form, one column for each event title, for example...)

Is it possible?

Answer 1

It is possible using ALTER TABLE

However, would it not be better to have a table called 'events' that holds all of them, with a column called 'userid' which contains the ID of the user the event belongs to.

Then you would know that every event exists in that table, and to get a users events you simply query that one table for rows that contain the users ID in the userid column.