i have a table which has 5 fields one of them is integer(id) .i wanted to assign values to it automatically in sequence using
java as i'm entering other values using sql query in java
PreparedStatement st=con.prepareStatement("insert into spotlight(ID IN SEQUENCE,req_name,req_desc,status,start_date) values(?,?,?,?) ");