CREATE TABLE users (
id int(100) NOT NULL,
name varchar(100) NOT NULL,
email varchar(100) NOT NULL,
password varchar(100) NOT NULL,
dob date DEFAULT NULL,
blood varchar(5) DEFAULT NULL,
alergies varchar(100) DEFAULT NULL,
weight int(11) DEFAULT NULL,
image varchar(100) NOT NULL
);
ALTER TABLE users
ADD PRIMARY KEY (id);
ALTER TABLE users
MODIFY id int(100) NOT NULL AUTO_INCREMENT;
COMMIT;
- Enjoy coding...
- Thank you...