SQL-How to Change Data Type of Column|SQL-Alter Table|PHPMyADMIN-Change Data Type of Column|SQLBasic

SQL-How to Change Data Type of Column|SQL-Alter Table|PHPMyADMIN-Change Data Type of Column|SQLBasic

#CTTUTORIAL #CHANGEDATATYPE #SQL #MYSQL #phpMyAdmin
In this tutorial you will learn how to change Data type in an Existing table. You can find different server syntax below:
CODE:
SQL Server / MS Access:
ALTER TABLE table_name
ALTER COLUMN column_name datatype;

My SQL / Oracle (prior version 10G):
ALTER TABLE table_name
MODIFY COLUMN column_name datatype;

Oracle 10G and later:
ALTER TABLE table_name
MODIFY column_name datatype;

phpMyAdmin Code:
ALTER TABLE table_name CHANGE column_name column_name YEAR;

Follow me on :

Subscribe to this Channel!

PLAYLIST:

sql server,sql,microsoft sql server,rename column,change column datatype,