kopia:
CREATE TABLE `tab2` AS SELECT * FROM `tab`;
dodanie klucza:
ALTER TABLE `tab2`  ADD PRIMARY KEY (`id`)
dodanie autoincrement:
ALTER TABLE tab2 CHANGE COLUMN `id` `id` int(11) NOT NULL auto_increment;