If Exists Update else Insert Matlab/SQL
2 views (last 30 days)
Show older comments
Hi,
What is the correct syntax for updating an "existing" field in an SQL Table.
If Exist Update Else Insert
At the moment I am fetching the entire table from the Database and loop through all the rows and compare to the new data, which I would imagine will eventually slow down the application as database grows.
Thanks,
Aris
1 Comment
Oleg Komarov
on 13 May 2012
This is NOT a MATLAB related question. You have to check SQL syntax: http://www.w3schools.com/sql/sql_update.asp
Answers (0)
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!