mysql(5.1)插入语法> col_name =值? [英] mysql (5.1) insert syntax > col_name=value?

问题描述

mysql中是否有一种方法可以插入一个 new 行，从而更直接地将一个值与其列关联(而不是table(col_name) values(value))?一次插入很多值时，将它们内联列出会造成相当混乱，并导致错误/错误.

Is there a way in mysql to insert a new row in a way that more directly associates a value with its column (rather than table(col_name) values(value))? When inserting a lot of values at one time, listing them in-line gets rather confusing and leads to errors/mistakes.

我正在寻找更像UPDATE的SET col_name='value'语法.

I'm looking for something more like UPDATE's syntax of SET col_name='value'.

我在用于INSERT的mysql文档中看到以下:

INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
    [INTO] tbl_name
    SET col_name={expr | DEFAULT}, ...
    [ ON DUPLICATE KEY UPDATE
      col_name=expr
        [, col_name=expr] ... ]

但这仅是重复项:/

推荐答案

在MySQL文档中，[text]表示"text是可选的".因此，这是完全有效的:

In the MySQL docs, [text] means "text is optional". So this is perfectly valid:

INSERT INTO table
SET col1='value1', col2='value2'...

这篇关于mysql(5.1)插入语法> col_name =值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！