I have a database with 2 tables like this:
cg_resp
id | name | email
1 | George | george@yahoo.com
and
equip_info
id | description | cg_resp_id
1 | Caliper | 1
In the application form I have 2 edit boxes with named edit_resp_name
and edit_resp_email
If user insert a new responsible name John
with the email john@yahoo.com
then during saving I would like to insert
a new responsible into cg_resp
table
If the user maintain the name George
but it's updating the email like george01@gmail.com
then I would like to update
the cg_resp.id=1
How can be done this in one Sqlite
sql sequence?
Aucun commentaire:
Enregistrer un commentaire