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)
-
Step1 : Firstly you have to take backup current table . create table tb_old like tb_new insert into tb_new select * from tb_old ...
-
I have one table Student .So i want to fetch data according to percentage and give remark according to position . set @no=0 ; select @n... -
Step 1: rpm -Uvh https://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm Step 2: sed -i 's/enabled=1/enabled=0/' /etc/y...
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