Blog Bustle 04/03/2020
alter query in sql is used to do some changes in table like add column, drop column, modify column, change column name and many more. Remember that before running alter query in sql, first we have to select database.
We can add one or more columns in table using single alter query in sql.
ALTER TABLE table_name
ADD column_name column_datatype;
You can also write "ADD column column_name column_datatype" in place of "ADD column_name column_datatype". Both are correct.
ALTER TABLE table_name
ADD column1_name column1_datatype,
ADD column2_name column2_datatype,
ADD column3_name column3_datatype,
.....
ADD columnN_name columnN_datatype;
We can drop one or more columns in table using single alter query in sql.
ALTER TABLE table_name
DROP COLUMN column_name;
You can also write "DROP column column_name" in place of "DROP column_name". Both are correct.
ALTER TABLE table_name
DROP column1_name,
DROP column2_name,
DROP column3_name,
.....
DROP columnN_name;
We can modify one or more columns in table using single alter query in sql.
ALTER TABLE table_name
MODIFY column_name new_datatype;
You can also write "Modify column column_name new_datatype" in place of "MODIFY column_name new_datatype". Both are correct.
ALTER TABLE table_name
MODIFY column1_name new_datatype,
MODIFY column2_name new_datatype,
MODIFY column3_name new_datatype,
.....
MODIFY columnN_name new_datatype;
ALTER TABLE table_name CHANGE column_name column_new_name new_datatype;
Alter query in sql (add, drop, modify & change column) searches:
Sql Insert Query
Sql Update Query
Sql & Mysql difference
Sql Delete Query
Sql Select Query
Mysql no database selected error 1046
Sql Create Table
Sql Drop Table
Sql Alter Query(add, drop, modify & change column)
Sql Truncate Table
Sql Insert Into Query
Sql Rename Table
Sql DISTINCT Keyword
Sql WHERE Clause
Sql Like operator
Sql AND operator
Sql OR operator
Sql NOT operator
Combining Sql AND, OR & NOT operator
Sql IN operator
Sql NOT IN operator
Sql Count, Sum, Avg, Min, Max
Sql Order By clause
Sql Limit clause
Sql BETWEEN operator
Sql Group By clause
Sql Aliases
Sql Inner Join
Sql Left Join
Sql Right Join
Mysql Create Database
Mysql Create Database Command Line
Mysql Delete Database
Mysql Delete Database Command Line
Mysql Show Databases
Mysql Show Databases Command Line
Mysql Select Database
Mysql Select Database Command Line
Mysql Backup Database
Mysql Import Database
Mysql Copy Database
Mysql Rename Database
Truncate Database Mysql