Create Table

Now that we have created the database, let's create a table that contains member information.

CREATE TABLE `member`(
  `memberID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userId` varchar(20) NOT NULL COMMENT 'ID',
  `name` varchar(20) NOT NULL COMMENT 'name',
  `nickname` varchar(20) NOT NULL COMMENT 'nickname',
  `password` varchar(50) NOT NULL COMMENT 'password',
  `email` varchar(40) NOT NULL COMMENT 'email address',
  `birthday` char(10) NOT NULL COMMENT 'birthday',
  PRIMARY KEY(`memberID`),
  UNIQUE KEY `userId`(`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

terminal

So let's finish this course and write the next one.