Yogesh Chauhan's Blog

How to CREATE TABLE in SQL with and without using Another Table?

in SQL/MySQL on April 29, 2020

The SQL CREATE TABLE Statement

Creates a new table in a database.

Syntax


CREATE TABLE table_name (
    column1_name datatype,
    column2_name datatype,
    column3_name datatype,
   ....
);

Where the datatype parameter specifies the type of data the column can hold for e.g. varchar, integer, date, binary, text, longtext etc.

SQL CREATE TABLE Example


CREATE TABLE Users (
    UserID int,
    LastName varchar(255),
    FirstName varchar(255),
    Email varchar(255),
    Address varchar(255)
);

Whenever we add varchar as datatype, we are required to specify length of the field. It can take up to 255 characters.

Create Table Using Another Table

We can create a copy of an existing table using CREATE TABLE.

The new table gets the same column definitions. We can select all columns or some if we want.

Note: If you create a new table using an existing table, the new table will be filled with the existing values from the old table.

Syntax


CREATE TABLE new_table AS
    SELECT column1_name, column2_name,...
    FROM current_table
    WHERE <add condition>;

Example


CREATE TABLE marketing AS
SELECT username, email
FROM customers;

Most Read

#1 How to add Read More Read Less Button using JavaScript? #2 How to check if radio button is checked or not using JavaScript? #3 Solution to the error “Visual Studio Code can’t be opened because Apple cannot check it for malicious software” #4 Solution to “TypeError: ‘x’ is not iterable” in Angular 9 #5 How to uninstall Cocoapods from the Mac OS? #6 PHP Login System using PDO Part 1: Create User Registration Page

Recently Posted

#Apr 8 JSON.stringify() in JavaScript #Apr 7 Middleware in NextJS #Jan 17 4 advanced ways to search Colleague #Jan 16 Colleague UI Basics: The Search Area #Jan 16 Colleague UI Basics: The Context Area #Jan 16 Colleague UI Basics: Accessing the user interface
You might also like these
When you don’t want to @forward every member in SCSS (Sass)SCSSJavaScript String Properties and MethodsJavaScriptKilling A Project Part 2: Who should make the decision to kill a project?MiscellaneousHow to add and remove capabilities from a role in WordPress?WordPressFor In Loop in Swift for BeginnersSwiftSQL ANY OperatorSQL/MySQLHow to create a circle that follows a cursor using JavaScript and CSS?CSSAdd animated hamburgers menu using Hamburgers collection on GitHubCSSHow to apply style to the first-child using jQuery?jQueryHow to overwrite file contents with new content in PHP?PHPActions vs. Filters: hooks in WordPressWordPressCheck if any column has NULL values in PostgresPostgres