How do we create a table in SQL and how do we insert values in those tables?

[board-infinity]

Sql Question

[ruble-joseph]

The CREATE TABLE statement is used to create a new table in a database and INSERTing values in tables by Insert into.

(insert into is used by two types: The first way specifies both the column names and the values to be inserted and second, you do not need to specify the column names in the SQL query.)

[chirag-garg]

just follow the basic syntax to create a table which is as follow:

CREATE TABLE table_name (column1 datatype,column2 datatype,column3 datatype);

for eg:

CREATE TABLE student (roll int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255));