delete

first I insert new row to table

INSERT INTO books (bookid, title, author, isbn, price, instock)
VALUES (6, 'bookname', 'author name', '1010101', 1.00, FALSE);

DELETE FROM books
WHERE bookid=6