View Single Post
Join Date: Aug 2008
Posts: 1,158
Reputation: dickersonka will become famous soon enough dickersonka will become famous soon enough 
Solved Threads: 136
dickersonka dickersonka is offline Offline
Veteran Poster

Re: Database update error help

 
0
  #4
Nov 18th, 2008
an insert is a new row, an update is making changes to an existing row

example
  1. INSERT INTO Users (USER_ID, USERNAME, PASSWORD) values (1, 'myusername', 'mypassword')

  1. UPDATE Users set PASSWORD = 'newpassword' WHERE USER_ID = 1
Custom Application & Software Development
www.houseshark.net
Reply With Quote