Mysql复制行与新id

代码示例

mysql复制行与新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;

MySQL复制排*

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;

类似页面

带有示例的类似页面

mysql复制行与新id

其他语言

此页面有其他语言版本

empty row

Русский

..................................................................................................................

Ссылка

English

..................................................................................................................

Link

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

受欢迎的此类别

标籤的相关热门网页

empty row

SQL创建独特的指标为唯一值

从。进口_mysql ImportError:libmariadb.此。3:不能打开共同目的文件：没有这样的文件或录linux