> What in mysql is like SQL where you can do
>
> update blah
> set blah=2
> where blah=2
>
> if @@ROWCOUNT = 0
That is not SQL but some propietary idiosyncracy. In MySQL you would use ON DUPLICATE KEY UPDATE (which is another propietary idiosyncracy). In SQL you would use MERGE.
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
