Skip to main content
Database Administrators

Return to Answer

code format, translate text to English
Source Link
ypercubeᵀᴹ
ypercubeᵀᴹ
  • 98.7k
  • 13
  • 215
  • 305

I have such error if iI have system shutdown or network problem. You really don't avhave a duplicate in your db. DATThat is mysql db error...all you need to do is datthat, if uyou do uryour insertion and it is not true, jesjust alter one of d columnthe columns of uryour table you want to insert into either from varchar to text or bigint and den redo the insertion. Dat solve d problem. If(!$insert){ $alter=Mysql_query("alter table table_namevarchar changeto table_nametext or table_namebigint bigint(255) not null"); If($alter){ //youand then redo yourthe insertion. } } That will solve the problem.

If(!$insert){
$alter=Mysql_query("alter table `table_name` 
                    change `table_name` `table_name` bigint(255) not null");
If($alter){
//you then redo your insertion.
}
}

I have such error if i have system shutdown or network problem. You really don't av a duplicate in your db. DAT is mysql db error...all you need to do is dat, if u do ur insertion and it is not true, jes alter one of d column of ur table you want to insert into either from varchar to text or bigint and den redo the insertion. Dat solve d problem. If(!$insert){ $alter=Mysql_query("alter table table_name change table_name table_name bigint(255) not null"); If($alter){ //you then redo your insertion. } }

I have such error if I have system shutdown or network problem. You really don't have a duplicate in your db. That is mysql db error...all you need to do is that, if you do your insertion and it is not true, just alter one of the columns of your table you want to insert into either from varchar to text or bigint and then redo the insertion. That will solve the problem.

If(!$insert){
$alter=Mysql_query("alter table `table_name` 
                    change `table_name` `table_name` bigint(255) not null");
If($alter){
//you then redo your insertion.
}
}
Source Link
Kazeem Olanipekun
Kazeem Olanipekun
  • 1
  • 1

I have such error if i have system shutdown or network problem. You really don't av a duplicate in your db. DAT is mysql db error...all you need to do is dat, if u do ur insertion and it is not true, jes alter one of d column of ur table you want to insert into either from varchar to text or bigint and den redo the insertion. Dat solve d problem. If(!$insert){ $alter=Mysql_query("alter table table_name change table_name table_name bigint(255) not null"); If($alter){ //you then redo your insertion. } }