ajor%idA\rS\rALTER TABLE ADD CONSTRAINT K PRIMARY KEY %[\A §KK\rXS\rALTER TABLE MODIFY COLUMN[ \ w x PREPARE KEYA z§K\r\rALTER drop PRIMARY KEY;.\r
\rALTER TABLE DROP INDEX
K;\r8>g\r/*\r¨©XystªXyaulo_increment\r¨©X«key®3T« gx®3i¤¥¯ª\ro°±¤¥¨©X\rDROP TABLE if EXISTS tab_identity;\rCREATE table tab identity(\rid int PRIMARY KEY auto_increment,\rNAME VARCHAR(20)\r)A\rµo¶·±°±X\rALTER TABLE MODIFY COLUMN ¸ key H[\wx auto_increment;\rALTER TABLE tab_identity MODIFY COLUMN id int auto_increment;.\rhs>g\rALTER TABLE tab_identity MODIFY COLUMN _ key ? , b c ;\rALTER TABLE tab_identity MODIFY COLUMN id int ;
全文预览
