Basic PHP Programming Question:

Download Job Interview Questions and Answers PDF

How can we change the name of a column of a table?

PHP Interview Question
PHP Interview Question

Answers:

Answer #1
This will change the name of column:

ALTER TABLE table_name CHANGE old_colm_name new_colm_name

Answer #2
Alter table tablename change column oldcolumnname, new columnname datatype(size);

Download PHP Interview Questions And Answers PDF

Previous QuestionNext Question
What is the functionality of MD5 function in PHP?How can we know the number of days between two given dates using MySQL?