Loading

i want one table multiple operation at same time using mysql c#

supriya nikam

it is necessary to check whether multiple operation on a table take place in the same time.ex 20 query at time execute in one table

eg.test db-> in test db -> temparary table->in this table i want multple operation insert ,update at same time (in timer function)in c# window application .

i don't know any idea please tell me how to possible .

thank you for advance

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta5y ago
If you have been shared the reason to use timer and threading, we should be able to provide optimized solution.

However, you can divide your statements into 2-3 parts then use TPL to execute it, if the query is short then there is no need to use, it will complete within seconds
+3
supriya nikam5y ago
yes i understand but i want call timer function & multi thread function
+2
Amit Gupta5y ago
Seperate your statements with a semi colon and then execute. Select * from table1; select * from table2;
+2