How to make a column bigger and delete unique from table.
- 1 Answers
- 1092 Views
- I also Faced
- E-Mail Answers
Answer Posted / Pankaj Kumar Dagar
To make a column bigger in MySQL, you can alter the column using the ALTER TABLE command with CHANGE keyword. Here's an example: `ALTER TABLE your_table_name MODIFY column_name TYPE new_data_type NEW_COLUMN_NAME;` To delete unique values from a table, use the DELETE command with the DISTINCT keyword and WHERE clause. Here's an example: `DELETE FROM your_table_name WHERE column_name IN (SELECT DISTINCT column_name FROM your_table_name);`
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
