User ID Scripts

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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: