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:ct.tutorial2020@gmail.com
Telegram Channel:t.me/ct_tutorial
sql server,sql,microsoft sql server,rename column,change column datatype,
On this page of the site you can watch the video online SQL-How to Change Data Type of Column|SQL-Alter Table|PHPMyADMIN-Change Data Type of Column|SQLBasic with a duration of online in good quality, which was uploaded by the user CT TUTORIAL 01 September 2020, share the link with friends and acquaintances, this video has already been watched 1,013 times on youtube and it was liked by 6 viewers. Enjoy your viewing!
