Gentlemen,
I'm having some problems generating inserts (ParseSchema method) with null attributes (MySQL).
Example:
table columns: column1, column2, column3, column4, column5 values: 1, NULL, NULL, NULL, 2
In this scenario the insert string is built using the columns sequentially and the fields that are not null.
INSERT INTO table (column1, column2) VALUES (1,2);
Did anyone notice that?
Regards
André
Log in to post a comment.
Gentlemen,
I'm having some problems generating inserts (ParseSchema method) with null attributes (MySQL).
Example:
table
columns: column1, column2, column3, column4, column5
values: 1, NULL, NULL, NULL, 2
In this scenario the insert string is built using the columns sequentially and the fields that are not null.
INSERT INTO table (column1, column2) VALUES (1,2);
Did anyone notice that?
Regards
André