1. Home
  2. SQL

Mysql copy row with new id

Code examples

0
0

mysql copy row with new id 

CREATE TEMPORARY TABLE tmp SELECT * FROM sitelog WHERE 1=1;
ALTER TABLE tmp DROP COLUMN `ID`;
INSERT IGNORE INTO sitelog SELECT 0, tmp.* FROM tmp;
DROP TEMPORARY TABLE tmp;
0
0

MySQL copy row with * 

CREATE TEMPORARY TABLE tmp SELECT * from invoices WHERE ...;
    ALTER TABLE tmp drop ID; # drop autoincrement field
    # UPDATE tmp SET ...; # just needed to change other unique keys
    INSERT IGNORE INTO invoices SELECT 0,tmp.* FROM tmp;
    DROP TABLE tmp;

Similar pages

Similar pages with examples

mysql copy row with new id

In other languages

This page is in other languages

Русский
..................................................................................................................
Ссылка
Italiano
..................................................................................................................
Link
Polski
..................................................................................................................
Link
Română
..................................................................................................................
Legătură
한국어
..................................................................................................................
링크
हिन्दी
..................................................................................................................
लिंक
Français
..................................................................................................................
Lien
Türk
..................................................................................................................
Atıf
Česk
..................................................................................................................
Odka
Português
..................................................................................................................
Referênci
ไทย
..................................................................................................................
เชื่อมโยง
中文
..................................................................................................................
链接
Español
..................................................................................................................
Referencia
Slovenský
..................................................................................................................
Odkaz
Балгарскі
..................................................................................................................
Спасылка
Íslensk
..................................................................................................................
Link

Popular in the category

Popular pages with examples in the category

SQL CREATE UNIQUE INDEX for Unique Values
from . import _mysql ImportError: libmariadb.so.3: cannot open shared object file: No such file or directory linux
convert sql to linq tool
sql query to linq converter
mysql to linq converter online
convert sql to linq using linqad
sql onlineto linq online converter
sql to linq online converter onlie
sql to linq convert onlinr
linq sql to sql converter
convert to linq
online convert linq to sql query
convert sql to linq c# online
convert query syntax to linq
convert linq include sql query
convert query to linq online