How to make a column bigger and delete unique from table.



How to make a column bigger and delete unique from table...

Answer / 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

More MySQL Interview Questions

What is the maximum length of a table name, a database name, or a field name in MySQL?

4 Answers  


Is mysql a odbc?

1 Answers  


Where the database is stored in mysql?

1 Answers  


How do I transfer data from one database to another in mysql?

1 Answers  


How many values can the SET function of MySQL take?

2 Answers   Creative Informatics,


Is mariadb faster than mysql?

1 Answers  


How do I install mysql on windows 7?

1 Answers  


What is back end and front end?

1 Answers  


How do I rename a procedure?

1 Answers  


Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?

1 Answers  


Where does mysql store data?

1 Answers  


Write a program using the select statement, while loop.

1 Answers  


Categories