o Change DataType of Column: Sy: Alter Table <Table Name> Modify <

How can we change the name and data type of a column of a
table?

Question Posted / ashish

Answer Posted / ashish

o Change DataType of Column:
Sy: Alter Table <Table Name> Modify <ColumnName> <DataType>;
Ex: Alter Table Test Modify EmpId varchar(5);

Is This Answer Correct ?

10 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How to enter Characters as HEX Numbers?

952

Can we store videos in mysql database?

876

how can you test for null values in a database? : Mysql dba

892

Is mysql a server?

838

What are the mysql database files stored in system ?

985

Which is faster innodb or myisam?

915

What is a string in mysql?

852

Does mysql support nosql?

845

What are the different types of triggers in mysql?

912

What is triggers and how it can be used in mysql?

892

What are the functions of commit and rollback statements?

941

What is mysql primary key?

908

What is a user defined variable?

844

What is heap table in mysql?

908

Can't connect mysql server on localhost?

997