Learn SQL
  • SQL Tutorial
  • Untitled
  • Table Structure
    • Create Table
    • Alter Table
    • Drop Table
Powered by GitBook
On this page
  1. Table Structure

Create Table

Create table

create table - students
CREATE TABLE `u367669158_tutor`.`students` ( 
    `id` INT NOT NULL AUTO_INCREMENT , 
    `name` VARCHAR(20) NOT NULL , 
    `age` INT(3) NOT NULL , 
    `addr` INT(30) NOT NULL , 
    PRIMARY KEY (`id`));

PreviousUntitledNextAlter Table

Last updated 6 years ago