1.2.2.2.Creating a Table - CREATE TABLE

• 建立table

  • 欄位:

    • id: Type, 長度, auto increment, primary key

    • 其他欄位: not null

      create table StudentsDetails (id INT(11) auto_increment primary key, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, email VARCHAR(100), mobile VARCHAR(100), enrolled_date TIMESTAMP);