Tap on a Finish button to reflect changes at the table ‘student’. Hit on Apply button to proceed with the update.Īnother below window will be opened. To drop a column from the table, you have to select that column, right-click on it and press the ‘Delete Selected’ option.Ī new window will be popped up, having a query written on it to drop a column. We might see a list of columns and their definitions. Hit it off to carry on.Ī new window will be opened in the workbench as below. While hovering over it, you will discover a representation of the setting icon, as shown below. Inside the database ‘data’, we have a list of tables, e.g., student and teacher. If you want to drop a column from an existing table ‘student’, you have to sail across in the direction of the Schemas beneath the Navigator. The table ‘student’ has the following records in it as below. Within the database ‘data’, we have added a table ‘student’. Under the workbench’s Navigation bar, we have a list of different databases that we have created already. We have to make sure to connect our MySQL workbench with the database from the main menu of the workbench under the ‘Database’ tab. You have to open the newly installed MySQL workbench from the start button of your desktop. Make sure you have MySQL installed on your windows system. For that, you have to use more than one DROP COlUMN clause in your query. Note: You can have more than one columns to be deleted.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |