CREATE TABLE Persons (
    ID int NOT NULL AUTO_INCREMENT,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int,
    PRIMARY KEY (ID)
); 


CREATE TABLE IF NOT EXISTS gestion (
  id int(11) NOT NULL AUTO_INCREMENT,
  annee varchar(30) NOT NULL,
  mois varchar(30) NOT NULL,
  jour varchar(30) NOT NULL,
  date_inscription varchar(30) NOT NULL,
  client varchar(30) NOT NULL,
  mode varchar(30) NOT NULL,
  formule varchar(30) NOT NULL,
  seance varchar(30) NOT NULL,
  compteur varchar(30) NOT NULL,
  montant varchar(30) NOT NULL,
  statut varchar(30) NOT NULL,
  cheque varchar(30) NOT NULL,
  banque varchar(30) NOT NULL,
  PRIMARY KEY (id)
) 

DROP TABLE gestion

This first statement will add the email column to the end of the table. To insert the new column after a specific column, such as name, use this statement:

ALTER TABLE contacts ADD email VARCHAR(60) AFTER name;