Comments - ALTER TABLE

3 years, 5 months ago lubos dz

Hi, could you please add an example on altering the table with table option? I cannot figure out how to drop "page_checksum" after changing from engine aria to myisam. Nothing seems working, always receiving "You have SQL error in your SQL syntax near .." - tried variations like:

ALTER TABLE 'tbl' PAGE_CHECKSUM = 0 ALTER TABLE 'tbl' PAGE_CHECKSUM 0 ALTER TABLE 'tbl' table_option PAGE_CHECKSUM 0

Using Mariadb 10.3 / centos7. When I execute "Show table status" it shows under "Create_options" : "page_checksum=1". Current engine is myISAM. This option causes table crash during import into another DB. Should be automatically dropped when egine changed from "aria" to "myisam". Thank you.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.