Step1 : Firstly you have to take backup current table .
create table tb_old like tb_new
insert into tb_new select * from tb_old
Step2:
# rename table tb_old to tb_new ;
Step3: alter table tbl_new drop KEY tbl_UNQ_KEY_ID (drop key from table)
Subscribe to:
Post Comments (Atom)
-
Index : 1. Available metadata access methods (2). Structures of information_ schema (3) . Using available commands to view metadata (... -
#Install and Configure Samba : Find the package install or not [root@-86 ~]# rpm -qa samba [root@-86 ~]# yum install samba samba-client s...
-
We are taking backup only function & store procedure from mysql database. [root@VMs]# mysqldump -u db_user -p -h 192.168.101.51 --ro...
How to Find the Third highest salary in mysql
set @b:=0; set @b1:=3; # #select distinct salary,@b:=@b+1 as Row_no from emp select * from emp where salary=( select salary from ( sele...
No comments:
Post a Comment