Versions Compared

Version Old Version 1 New Version Current
Changes made by

Ryan Park (Unlicensed)

Grey Shim

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Section


Column
width75%1024px

INSERT

insert_stmt:

insert_column_list:

value_list:


set_list:


Code Block
insert_stmt ::= 'INSERT INTO' table_name ( '(' insert_column_list ')' )? 'METADATA'? 'VALUES' '(' value_list ')' ( 'ON DUPLICATE KEY UPDATE' ( 'SET' set_list )? )?
insert_column_list ::= column_name ( ',' column_name )*
value_list ::= value ( ',' value )*
set_list ::= column_name '=' value ( ',' column_name '=' value )*


Code Block
create table test (number int,name varchar(20));
Created successfully.
insert into test values (1,"test");
1 row(s) inserted.
insert into test(name,number) values ("test",2);
1 row(s) inserted.


This is the syntax for entering values ​​into a specific table. One unusual thing is that columns not specified in Column_List are all filled with NULL values. This is a policy considering the characteristics of log files adopted for convenience of input and efficiency of storage space.
METADATA is only available for tag tables.


ui-text-box
Column

Index

Table of Contents
maxLevel3
indent30px
exclude목차
classtoc



INSERT ON DUPLICATE KEY UPDATE

...

Code Block
sql
sql
create table t1 (i1 integer, i2 varchar(60), i3 varchar(5));
Created successfully.

insert into t1 values (1, 'a', 'ddd' );
1 row(s) inserted.
insert into t1 values (2, 'kkkkkkkkkkkkkkkkkkkkk', 'c');
1 row(s) inserted.

insert into t1 select * from t1;
2 row(s) inserted.
create table t2 (i1 integer, i2 varchar(60), i3 varchar(5));

insert into t2 (_arrival_time, i1, i2, i3) select _arrival_time, * from t1;
4 row(s) inserted.


UPDATE

...

Ui text box
typetip
Info

This function is available from 5.5.


Image Addedupdate_stmt:

Image Removed

update_expr_list:


update_expr:

...

type
Code Block
sql
sql
UPDATE TAG METADATA SET ...
Ui text box

 Note
The metadata of the TAGDATA table can not be entered/modified through INSERT ON DUPLICATE KEY UPDATE.
...