![]() ![]() And we want to change this column name as account_no and its data type as int to varchar. In this image, we can see that the data type of column name account_num is int. In that case, we first check the structure of the table using the DESCRIBE statement as follows: Suppose we have a table named balance that contains the data as follows:ĭue to some reason, we need to change the column name account_num along with its data type. Let us understand how the CHANGE statement works in MySQL to rename a column through the various examples.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |