DATA TYPES IN SQL
There are a lot of data types in SQL:
But let's look into some important ones:
INT
A normal-sized integer that can be signed or unsigned. Range 0 to 4294967295.
VARCHAR
A variable length string between 1 and 255 characters in length. Length must be defined.
DATE
The date is written in YYYY-MM-DD format.
SIMPLE QUERIES IN SQL:
Show database
To list all databases on a MySQL server host you use the SHOW DATABASES command.
Create database
To create a database we use CREATE DATABASE command.
Drop database
To delete a database from the server we use the DROP DATABASE command.
To Create Table
For creating a table we write a simple query having the syntax:
CREATE TABLE <table_name> (column1 datatype, column2 datatype,column3 datatype,.........);
To insert values
For inserting values in the table we created we write a query having the syntax:
INSERT INTO <table_name> VALUES(value1,value2,value3,......);