hello,
SingleStore DB stores data almost blunders experienced amid each Stack Information operation, but the number of blunders is restricted to 1000 by default. When this constrain is come to, the stack comes up short. This anticipates out-of-memory issues when inadvertently stacking expansive records with off base organize or an off base Stack Information articulation. Utilize MAX_ERRORS at the conclusion of the explanation to alter this restrain. To indicate no restrain, set MAX_ERRORS to 0.
Writing to multiple databases in a transaction is not supported.
CSV LOAD DATA
Syntax
LOAD DATA [LOCAL] INFILE ‘<file_name>’
[REPLACE | IGNORE | SKIP { ALL | CONSTRAINT | DUPLICATE KEY | PARSER } ERRORS]
INTO TABLE <table_name>
[CHARACTER SET <character_set_name>]
[{FIELDS | COLUMNS}
[TERMINATED BY ‘’]
[[OPTIONALLY] ENCLOSED BY ‘’]
[ESCAPED BY ‘’]
]
[LINES
[STARTING BY ‘’]
[TERMINATED BY ‘’]
]
[TRAILING NULLCOLS]
[NULL DEFINED BY [OPTIONALLY ENCLOSED]]
[IGNORE LINES]
[ ({<column_name> | @<variable_name>}, …) ]
[SET <column_name> = ,…]
[WHERE ,…]
[MAX_ERRORS ]
[ERRORS HANDLE ]