This is my current database with MySQL, everything works really well and submitting data to it works really well.
However, I would now like to add an additional column field called username.Code:CREATE DATABASE bril_mx; use test; CREATE TABLE users ( id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY, firstname VARCHAR(30) NOT NULL, email VARCHAR(50) NOT NULL, age INT(3), location VARCHAR(50), date TIMESTAMP );
Is this the correct procedure to add username?
Thank you.Code:ALTER TABLE test ADD UserName varchar(255);




Reply With Quote