Question

How to create a table with SQL

Answer 1

CREATE TABLE Workers
(
     WorkerID int,
     FirstName varchar(255),
     LastName varchar(255)
) 

 

70+ SQL courses for beginners and professionals

Answer 2

CREATE TABLE Workers
(
     WorkerID int PRIMARY KEY,
     FirstName varchar(255),
     LastName varchar(255)
)

 

70+ SQL courses for beginners and professionals

Answer 3

CREATE TABLE Workers
(
     WorkerID int PRIMARY KEY,
     FirstName varchar(255),
     LastName varchar(255),
     URL varchar(255) UNIQUE 
)

 

70+ SQL courses for beginners and professionals

Answer 4

CREATE TABLE Workers
(
     WorkerID int PRIMARY KEY,
     FirstName varchar(255) NOT NULL,
     LastName varchar(255) NOT NULL,
     URL varchar(255) UNIQUE 
)

 

70+ SQL courses for beginners and professionals

Answer 5

CREATE TABLE Workers
(
     WorkerID int PRIMARY KEY,
     FirstName varchar(255) NOT NULL,
     LastName varchar(255) NOT NULL,
     URL varchar(255) UNIQUE,
     Salary float DEFAULT 0
)

 

70+ SQL courses for beginners and professionals

Answer 6

CREATE TABLE Workers
(
     WorkerID int(7) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
     FirstName varchar(255) NOT NULL,
     LastName varchar(255) NOT NULL,
     URL varchar(255) UNIQUE,
     Salary float DEFAULT 0,
     StartWorkingDate TIMESTAMP
)

 

70+ SQL courses for beginners and professionals

Answer 7

CREATE TABLE Workers
(
     WorkerID int(7) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
     FirstName varchar(255) NOT NULL,
     LastName varchar(255) NOT NULL,
     URL varchar(255) NOT NULL UNIQUE,
     Salary float DEFAULT 0,
     StartWorkingDate TIMESTAMP
)

 

70+ SQL courses for beginners and professionals

Answer 8

CREATE TABLE Workers
(
     WorkerID int(7) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
     FirstName varchar(255) NOT NULL,
     LastName varchar(255) NOT NULL,
     URL varchar(255) NOT NULL UNIQUE,
     Salary float DEFAULT 0,
     StartWorkingDate TIMESTAMP,
     CONSTRAINT F_WorkerID UNIQUE (WorkerID, LastName)
)

 

70+ SQL courses for beginners and professionals

Answer 9

CREATE TABLE test (
  keyword text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 

70+ SQL courses for beginners and professionals