Tables: table is collection of related data. We will store data in database using table format(columns and rows).
Query to create table in database
CREATE TABLE tablename(
Create Table Example
We already created code_calculate database. we are going to create tables in the code_calculate database.Before create table just check which database you are using
CREATE TABLE employees(
Table with name 'employees' is created in the code_calculate database
empId, empName, department are the column names
INT, VARACHAR are data types, we will learn what are data types in sql in next page
I have written query in 5 lines for readability purpose only, you can create whole query in one line.
CREATE TABLE employees( empId INT, empName VARCHAR(20), department VARCHAR(3) );