Question:
I need to write a script that tells me the last user_id entered on a table and then another script in order to allow me (or a user) to enter the next user ID, username, and the department.
I wonder if you have some sample scripts that I can take a look at in order to do. What am I supposed to do?
I am new at this so I do not know how to start.
Answer:
For your first task, does this work for you?
SELECT MAX(user_id) from MYTABLE?
For the second task, does this work for you?
INSERT INTO MYTABLE (ID, USERNAME, DEPARTMENT) VALUES(1,"Drew", "Department of Redundancy Department")
Hope this helps.