Welcome to collectivesolver - Programming & Software Q&A. A website you can trust. All programs tested and works. Contact: aviboots(AT)netvision.net.il
BlueHost Web Hosting

Bonsai Boy of New York Bonsai Trees and Accessories

Liquid Web iThemes WordPress Hosting

Ecommerce Software - Best Ecommerce Platform Made for You - Free Trial

DreamHost Web Hosting


getResponse autofunnels

Liquid Web Cloud VPS Hosting

Disclosure We are a professional Information website that receives compensation from some of the links whose we show you with Information. It means that my content may contain affiliate links.

12,090 questions

16,473 answers

573 users

How to create a table with SQL

9 Answers

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

 




answered Sep 22, 2015 by avibootz
0 votes
CREATE TABLE Workers
(
     WorkerID int PRIMARY KEY,
     FirstName varchar(255),
     LastName varchar(255)
)

 




answered Sep 23, 2015 by avibootz
0 votes
CREATE TABLE Workers
(
     WorkerID int PRIMARY KEY,
     FirstName varchar(255),
     LastName varchar(255),
     URL varchar(255) UNIQUE 
)

 




answered Sep 23, 2015 by avibootz
0 votes
CREATE TABLE Workers
(
     WorkerID int PRIMARY KEY,
     FirstName varchar(255) NOT NULL,
     LastName varchar(255) NOT NULL,
     URL varchar(255) UNIQUE 
)

 




answered Sep 23, 2015 by avibootz
0 votes
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
)

 




answered Sep 23, 2015 by avibootz
0 votes
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
)

 




answered Sep 23, 2015 by avibootz
0 votes
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
)

 




answered Sep 24, 2015 by avibootz
0 votes
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)
)

 




answered Sep 25, 2015 by avibootz
0 votes
CREATE TABLE test (
  keyword text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

 




answered Sep 17, 2019 by avibootz
...