Activity Outcome : Use START TRANSACTION AND COMMIT statement. Note: You have to activate xampp in order to execute the command. Procedure: code example

Example: how to edit saved data on xampp

//open your table and click on edit and then click update

UPDATE `books` //where books is table name
SET `bookid`=newvalue,//write what you want to change and new value
`bookname`=newvalue1//write only those value what you want to change 
WHERE 
bookid='oldvalue' //write any value so that xamp found what row want to chnage
//.........OR..........//
authorsname='oldvalue' //write any value so that xamp found what row want to chnage
    
  
  //And press Go

Tags:

Sql Example