Using ALTER statement we can do this like:
ALTER TABLE TABLE_NAME ADD COLUMN COLUMN_NAME DATA TYPE SIZE;
What is MySQL?
What is the default port number for MySql ?
What are the Features of MySQL ?
What are the advantage of MySQL ?
What are the disadvantage of MySQL ?
What is the function of myisamchk?
What are the purposes of using ENUM and SET data types?
What is primary Key?
What is Foreign Key?
Difference between Primary key and foreign Key ?
What is the use of CHAR and VARCHAR in MySQL?
Difference between CHAR and VARCHAR in MySQL ?
What is mysql_fetch_array() ?
What is mysql_fetch_object ?
What is the difference between mysql_fetch_array() and mysql_fetch_objec() ?
How can you filter the duplicate data while retrieving records from the table?
What is the difference between NOW() and CURRENT_DATE()?
Which statement is used in a select query for partial matching?
Which MySQL function is used to concatenate string?
How can you change the name of any existing table by using the SQL statement?
How can you retrieve a portion of any column value by using a select query?
What is the purpose of using a HEAP table?
How we can add a new column in the table ?
How we remove column from the table?
Define ALTER commands in MySQL ?
What is an index? How can an index be declared in MySQL?
What is meant by decimal (5,2)?
What is view?
How we can create a View in MySQL?
How we can DROP the View in MySQL ?
What is the function of mysqldump?
How can you change the password of a MySQL user?
In which language MySQL has been written?
What are the technical specifications of MySQL?
first function in MYSQL is done by which function?