Basic PHP Programming Question:
Download Questions PDF

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

Answer:

This will change the data type of a column:

ALTER TABLE table_name CHANGE colm_name same_colm_name [new data type]

Download PHP Interview Questions And Answers PDF

Previous QuestionNext Question
How can we know the number of days between two given dates using MySQL?What is meant by MIME?