Connect, Share, Discuss, Discover, Grow™
The non-profit Social network & Search engine - Est 2004
Fardoush
My Interest:
Software Development
Member Since:
2013-12-04
My Trust Level:
170
= Sage
View My Profile
Like Me
25
Follow Me
10
Lets Video Chat
Private Message Me
Goto My Book
See My Conversations
Question By Fardoush
Viewed: 1,819
9 years 11 months ago
9 years 11 months ago
What happens when MySQL UPDATE is done on record that does not exist?
Topics:
, , SQL | MySQL
To be exact, what we want to do is to UPDATE a Table and if that record that we are UPDATing does not exist then get a MySQL error message about that and then INSERT that record.
So that we do not have to before hand check to see via a SELECT that this record exists so as to avoid 10s of 1000s of SELECTS per Hour.

Can this be done?
What sort of Error message will MySQL throw that we need to look for?
Thanks.
Read Whole Article - 86 Words
9
Share
😀
😂
😋
😎
😍
😪
😜
🤑
😤
😭
😰
😱
😡
🤮
😇
🤥
💀
👽
💩
😺
👻
👏
👍
👎
✌️
👌
🖖
🙏
👄
💋
👅
👩🏻‍⚕️
👨🏻‍⚕️
🤷🏻‍♂️
👨‍🚀
1000
Advertising
Place Your Ad Here
Reach Millions of potential Customers
SAVE 50 to 90% on Cost of Advertising
Only non-profit Social Search network
Start My Advertising
Ad
Lake Norman Real Estate |
https://www.lakerealty.co
Are you buying Lake Norman real estate. You need a trusted advisor by your side
Ad
Margaret River, Pemberton
https://luxuryoutbacktour
Visit Busselton Jetty, Margaret River, Wineries, Tall Karri forests, Tree Top W
Ad
The ERC Experts
https://ercadvocates.com
Focused solely on maximizing your refundable claims for the Employee Retention
Ad
Join Best IPTV Service in
http://splashiptv.com
At Splash IPTV we offer over 25,000 LIVE channels ~ 121,000 VOD movies ~ 18,000
↟ Back to Top
Donate
Ok - Thanks