![]() This is also true for non-transactional tables. If another connection is using the table, a metadata lock is active, and this statement will wait until the lock is released. You can also change the comment for the table and the storage engine of the | EXCHANGE PARTITION partition_name WITH TABLE tbl_nameĪLTER TABLE enables you to change the structure of an existing table.įor example, you can add or delete columns, create or destroy indexes,Ĭhange the type of existing columns, or rename columns or the table | partition_options | CONVERT TABLE normal_table TO partition_definition | CONVERT PARTITION partition_name TO TABLE tbl_name First, indicate the table that you want to update in the UPDATE clause.ALTER TABLE tbl_nameĪlter_specification.Second, specify the columns that you want to modify in the SET clause.The columns that are not listed in the SET clause will retain their original values. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |