User ID Scripts

User ID Scripts

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.

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.


Share the Post: