Mysql create table

class:Mysql views:109 Author:xiaomo314
Command
use db_name; CREATE TABLE `tb`( `id` INT UNSIGNED AUTO_INCREMENT, `title` VARCHAR(100) NOT NULL, `author` VARCHAR(40) NOT NULL, `date` DATE, PRIMARY KEY ( `id` ) )ENGINE=InnoDB DEFAULT CHARSET=utf8;
Explanation
use db_name : switch to the specified library
The parentheses behind create table are the list of field settings
Operation result
[SQL]CREATE TABLE `tb`(
    `id` INT UNSIGNED AUTO_INCREMENT,
    `title` VARCHAR(100) NOT NULL,
    `author` VARCHAR(40) NOT NULL,
    `date` DATE,
    PRIMARY KEY (`id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
Affected rows: 0
Time: 0.038s

This platform is gradually under construction, more development orders are gradually included, any questions or Suggestions can be Contact Us