![]() ![]() 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. SQLite Operators: SELECT INTO CREATE TABLE AS SELECT Problem: You would like to create a new table with data copied from another table. 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 is a table containing employees records (let me call it Employees table). 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. 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 There may be many shortcomings, please advise. the purpose of answering questions, errors, examples in the programming process. Inner join deleted c on a.userid=c.useridįire this trigger. Our website specializes in programming languages. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |