Sql Problem (java Program)

keikun_naruchan · 06-03-2004, 07:42 PM

Let s say I hava a Microsoft Access database saved as employee.mdb
In the employee database I have a table name Employee with fields such as emp_id, emp_name, emp_title and so on..

Lets say i have this ff data stored:

Record 1:

emp_id = 123
emp_name = johann
emp_title = trainee

Record 2:

emp_id = 234
emp_name = johann
emp_title = trainee

NOTE: my emp_id is always unique, it is my primary key..
All the data is saved only in one table named Employee

If i want to delete record 1. what should be my SQL?

I think it should be..
(Delete * where emp_id = 123

but im not sure.. HOPE YOU GUYS OUT THERE COULD HELP ME..
TNANKS FOR ANY SUGGESTION YOU COULD GIVE ME

eric.r.turner · 06-03-2004, 10:19 PM

Close. It should be:

Code:

DELETE FROM Employee WHERE emp_id=123;

If you want to delete all rows from the table, just do:

Code:

DELETE FROM Employee;