What types of MYSQL function available for affecting columns
- 1 Answers
- 1044 Views
- I also Faced
- E-Mail Answers
Answer / Alok Kumar Gautam
In MySQL, there are several functions to manipulate column properties. Here are a few examples:
1. ALTER TABLE - Modifies the structure of a table by adding or removing columns.n Example: `ALTER TABLE employees ADD COLUMN salary DECIMAL(8,2);`
2. CHANGE - Renames a column while changing its data type if needed.n Example: `CHANGE old_column new_column DECIMAL(8,2);`
3. MODIFY - Alters the data type or properties of an existing column without renaming it.n Example: `MODIFY old_column DECIMAL(8,2);`
| Is This Answer Correct ? | 0 Yes | 0 No |
What is full form of PHP?
What is mvc in php?
How do you compare strings in java?
Can we use session in mvc?
Is strcmp case sensitive?
what is the url rewriting?how to rewrite the url? give any example
What are the benefits of composer?
What is cakephp framework?
What is the use of addslashes in php?
Is php is dying?
Hello Friends,I am seeking for a job in php having 9 months. exp.Please suggest any company openings.
Explain me what is the use of header() function in php?
PHP 
