How to see certain table in your database

If you want to see all the columns of the table then write the following code.

SELECT * FROM EMPLOYEE;

The output is given below:

Again if you want to see certain columns of the table then write the following code.

SELECT NAME, ADDRESS
FROM EMPLOYEE;

The output is given below:

How to insert data in your table by using SQL

Suppose you have a table name employee and the attributes are id, name, address. So to insert data in your table write the following code.

INSERT INTO EMPLOYEE 
VALUES(1, ' RAKIB' , 'UTTARA');

Now to see your table write the following code.

SELECT * FROM EMPLOYEE;

and the output is given below:

How to Create Table using SQL

To create a table in your database write the following command.

CREATE TABLE employee(
ID INT,
NAME VARCHAR(15),
ADDRESS VARCHAR(50)
);

Here employee is your table name and id, name and address are the attributes of your table.

How to Create database using SQL

To create database just write the following command.

CREATE DATABASE crazy;

Here crazy is your database name.

Notice

SELECT * FROM
Comming soon.......:)