When I write an add statement, I usually don't report an error, but some sql statements keep reporting an error and disconnection. After I take out the sql, it executes normally on the client side. I don't know what caused it. Here are some of my sql cases. Insert into test(a,b,c,.....) values as normal (1, 2, 3, 4, 'xxx',....), (1, 2, 3, 4, 'xxx' ,....), error commit insert into test(a,b,c,.....) values (1, 2, 3, 4, 'xxx',....), (1, 2, 3, 4, 'xxx',....), what is even more amazing is that the correct statement is changed to insert into test(a,b,c,.....) values (1, 2, 3, 4 , 'ttt',....), (1, 2, 3, 4, 'ttt',.,...), execute normally on the client side, but report an error in the program
When I write an add statement, I usually don't report an error, but some sql statements keep reporting an error and disconnection. After I take out the sql, it executes normally on the client side. I don't know what caused it. Here are some of my sql cases. Insert into test(a,b,c,.....) values as normal (1, 2, 3, 4, 'xxx',....), (1, 2, 3, 4, 'xxx' ,....), error commit insert into test(a,b,c,.....) values (1, 2, 3, 4, 'xxx',....), (1, 2, 3, 4, 'xxx',....), what is even more amazing is that the correct statement is changed to insert into test(a,b,c,.....) values (1, 2, 3, 4 , 'ttt',....), (1, 2, 3, 4, 'ttt',.,...), execute normally on the client side, but report an error in the program