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!
https://bit.ly/32hPbjd
https://tinyurl.com/CTTUTORIAL2020
PLAYLIST:
EXCEL VBA MACRO:https://tinyurl.com/ctexcelvbamacro
Facebook: / arka09
Email:[email protected]
Telegram Channel:t.me/ct_tutorial
sql server,sql,microsoft sql server,rename column,change column datatype,
