SQL; UPDATE and INSERT

[Hero192]

Hey all,

can anyone explain to me when should I use UPDATE and when should I use INSERT ?

[tosfera]

INSERT is when you want to add a new record to your database, the UPDATE is only used to manipulate data. Lets say;

A user registers a new account on your server => insert

Someone changes their password => update

You create a new vehicle and save it in your database => insert

The vehicle changed from color => update

[Hero192]

Thank you for the clear informations & for your examples.

By the way,

I start doing a login system I want to store password in should I use the value as TEXT or INTEGER?

because as you know, Passwords can't be controlled it can be numbers and words in same time

dbExec (connection, "CREATE TABLE IF NOT EXISTS  data (account TEXT, password TEXT)" ) 

Thanks in advance.

[tosfera]

There is your answer, not even a single has is only numbers. Therefore it should be a text or varchar(45), since the hash from these days isn't longer than that.