What types of MYSQL function available for affecting columns
- 1 Answers
- 1045 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is trait in php?
How to calculate the difference between two dates using php?
Write a program using while loop?
What is the current stable version of php?
List some features of php that are deprecated in php7?
What sized websites have you worked on in the past?
sort term descripttion form, report and uery
What is the current stable version of php? What advance thing in php7?
What does $_files means?
how to detect a mobile device using php
hello all, I need some sample placement papers in lion bridge.. can anyone help me?
What is difference between static and final in php?
if you run the app program all vendor open items are cleared but is it possible to reverse the again again open items please tell me the answer
Name and explain five of the PHP error constants?
How can we extract string "pcds.co.in" from a string "https://info@pcds.co.in" using regular expression of php? More on reg can you explain
