What is SQL? SQL stands for Structured Query Language and is used to communicate with databases. That is , if we want to store , delete , update the data
CREATE TABLE statement is used to create a table in a database. Tables are defined as combination of rows and columns. And each table should have a name. Syntax :
If we want to see the structure of a table we have to use the DESC keyword. Here, structure means column names , column type and each column size of
If we want to remove the table from database, we use DROP command. Once you drop the table all the data along with the table will be deleted permanently. So
In this tutorial we are going to see how to remove the column from table .If we want to remove column from table , we have to use DROP with
In this tutorial we are going to learn how to add column to the existing table . If we want to add a column to table we have to use
In this tutorial we are going to learn how to modify the data type of a column . If we want to Modify the datatype of a column , we
In this tutorial we are going to learn how to increase the size of a column . If we want to increase the size of a column , we have
We use following sytax to rename the column of a table Oracle syntax : ALTER TABLE table_name RENAME COLUMN old_column_name TO new_column_name; MySql syntax : ALTER TABLE table_name Change old_column_name
To insert new records in a table , we have to use INSERT INTO command Syntax : INSERT INTO table_name VALUES (value1,value2,value3,…); If we use above syntax , we have
The most commonly used SQL command is SELECT statement. SELECT statement is used to retrieve data from a table in the database . Syntax 1 : To retrieve all the