YES it is important to provide the where condition with an update statement else the entire column will have the same updated value.Ģ3. Is it important to provide where condition with update statement in MYSQL? Show tables command displays all the tables of a particular database.Ģ2. It displays all the tables of a particular database.Īnswer: B) It displays all the tables of a particular database.It displays all the tables of all the databases in the machine.ALTER TABLE table_name DROP COLUMN column_name Īnswer: B) ALTER TABLE table_name DROP COLUMN column_name ĪLTER TABLE table_name DROP COLUMN column_name Ģ1.ALTER table_name TABLE DROP COLUMN column_name.Suppose you are asked to drop a column using alter statement then which syntax you will follow? ALTER TABLE test CHANGE 'cgpa 'total_percentage’ int Īnswer: A) ALTER TABLE test CHANGE COLUMN 'cgpa’ 'total_percentage’ int ĪLTER TABLE test CHANGE COLUMN 'cgpa' 'total_percentage' int Ģ0.ALTER test table CHANGE 'cgpa’ ,'total_percentage’ int. ALTER TABLE test CHANGE COLUMN 'cgpa’ 'total_percentage’ int.Suppose you have a table named to test and inside this table you have a column named CGPA now if you are asked to change the column named CGPA to total percentage, using alter command then which of the following statement you will write? Yes, we can easily change the column name using alter command.ġ9. Can you change the column name using alter command? To add a field using alter statement following syntax should be followed:ĪLTER TABLE table_name ADD field_name data type ġ8.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |