How to inserti if only some non key attributes of table do not match in mysql

Asked Apr 14 '22 at 15:56

Active Apr 14 '22 at 15:56

Viewed 11 times

I want to insert data in mysql Db only if 2 non key attribute are not matching for example if I am fetching tweets from twitter and i want to check if the user name and tweet matches in Db then do not insert in Db else Insert and I dont want to keep user name and tweet as key attribute now I am using IF exist but not working


   IF EXISTS (SELECT * FROM twitter WHERE usernaem = 'someuser' and tweet='some tweet')
   BEGIN
       insert data in Db if not exists
   END

but getting error in IF EXISTS, I am using mysql.

asked Apr 14 '22 at 15:56

AnonymousKing

You can only use `IF` statements in a stored procedure, not a query. – Barmar Apr 14 '22 at 16:16
so what is solution for this? – AnonymousKing Apr 14 '22 at 16:17
Why don't you want to make a unique key for username and tweet? – Barmar Apr 14 '22 at 16:18
I already have autoincrement id as unique – AnonymousKing Apr 15 '22 at 05:57
and a user name can have many tweets so cannot be unique – AnonymousKing Apr 15 '22 at 05:57
The unique key would be the combination `(username, tweet)`. This allows a user to have many tweets, just not duplicates of the same tweet. And you can have multiple unique indexes in a table. – Barmar Apr 15 '22 at 14:37

How to inserti if only some non key attributes of table do not match in mysql

0 Answers0