Create a field in table1

[Philosophaie]

I can create a database and a table in MySQL but I do not know how to create a field in table1.

When creating it (in MySQL) also how do you insert it after a certain field already programmed in?

Also how to rename a field already existing?

[r937]

@Philosophaie

… I do not know how to create a field in table1.

ALTER TABLE… ADD COLUMN …

@Philosophaie

When creating it (in MySQL) also how do you insert it after a certain field already programmed in?

ALTER TABLE … ADD COLUMN … AFTER …

@Philosophaie

Also how to rename a field already existing?

ALTER TABLE … CHANGE COLUMN …