Is there a way whereby immediately this password table is updated, a trigger will be created on the password column on the employee table managed by the HR to be updated too? only the column of the employee table in the database. I think of creating a small window where only his password and confirmation of the password fields would display for him to type in his new password and for this password to be stored in another table (password table) or somehow connected to the employee table through trigger When the employee accesses his record page, he would be eligible to update ONLY the field for password, other fields (attributes or columns) would be "uneditable" by him. The HR personnel gives the employees their username (userID) and password, instructing them to change their password so they would be the only ones who know their password without the knowledge of the HR personnel. Username and password are created in the course of filling the table and creating the records for each employee. They get the record from employees on paper and then fill it into the database table. This table can only be accessed by the HR personnel. There may be many shortcomings, please advise. the purpose of answering questions, errors, examples in the programming process. There is a table containing employees records (let me call it Employees table). Our website specializes in programming languages. Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. If the answer is helpful, please click " Accept Answer" and upvote it. What is UPDATE statement in SQLite Use the statement UPDATE to modify the table Replace the tablename with the name of a table in which modifications are. Output: userid oldpassword newpassword updatetime Update testusers set password='password22' where userid=2 Update testusers set password='password111' where userid=1 update testusers set password='password11' where userid=1 Inner join deleted c on a.userid=c.useridįire this trigger. Inner join testusers b on a.userid=b.userid Select a.userid,c.password,a.password,getdate() from inserted a create table testusersĬreate one trigger on PARTICULAR column. Please refer below example and check whether it is helpful to you.
0 kommentar(er)
