Create a field in table1

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?

Quote:

---

Originally Posted by Philosophaie

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

---

ALTER TABLE... ADD COLUMN ...

Quote:

---

Originally Posted by Philosophaie

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

---

ALTER TABLE ... ADD COLUMN ... AFTER ...

Quote:

---

Originally Posted by Philosophaie

Also how to rename a field already existing?

---

ALTER TABLE ... CHANGE COLUMN ...