QUIZGUM

Coding Class

Quizgum : Project 1-2 : Create Table

Create Table

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

  1. CREATE TABLE `member`(
  2.   `memberID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  3.   `userId` varchar(20) NOT NULL COMMENT 'ID',
  4.   `name` varchar(20) NOT NULL COMMENT 'name',
  5.   `nickname` varchar(20) NOT NULL COMMENT 'nickname',
  6.   `password` varchar(50) NOT NULL COMMENT 'password',
  7.   `email` varchar(40) NOT NULL COMMENT 'email address',
  8.   `birthday` char(10) NOT NULL COMMENT 'birthday',
  9.   PRIMARY KEY(`memberID`),
  10.   UNIQUE KEY `userId`(`userId`)
  11. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

terminal

php image

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