insert data if not exist in MySql C#

Question

I already found the MySQL query that I want to use

INSERT INTO tbl_time_in (studentID, studentDAY, studentDATE, studentTIME_IN, temp_schedule_ID)
SELECT *  
FROM (SELECT 'rupert', 'Tuesday', 'June 29, 2016' ,'23:20', '59') AS tmp
WHERE NOT EXISTS (SELECT studentID 
                  FROM tbl_time_in 
                  WHERE studentID = 'rupert' and studentDATE = 'June 29, 2016' and temp_schedule_ID = '59')

but I also want to know how could I implement this in C# correctly.

I tried to use ExecuteNonQuery and ExecuteReader but it always gives an empty result.

What do you want to return?

Jeroen Heier
– Jeroen Heier

2016-06-29 04:23:56 +00:00
Commented Jun 29, 2016 at 4:23 — Jeroen Heier
– Jeroen Heier, Commented Jun 29, 2016 at 4:23

eyeshield21 · Accepted Answer · 2016-06-29 03:58:46Z

1

In MySQL database you can use the ON DUPLICATE KEY UPDATE function this will lessen using of sub query. Check this link for further references.

answered Jun 29, 2016 at 3:58

eyeshield21

1868 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Feelbad Soussi Wolfgun DZ · Accepted Answer · 2016-06-29 04:05:07Z

0

well, you can implement this in if else statement, using a integer counter to check is the data exists or not, 1st fire the count statement and store the result in an integer, 2nd compare the the result with a 0 value - if result > 0 then the data exists in the database, else (it means result = 0) do insert Query

answered Jun 29, 2016 at 4:05

Feelbad Soussi Wolfgun DZ

851 silver badge3 bronze badges

Collectives™ on Stack Overflow

insert data if not exist in MySql C#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related