How to delete table rows data

[innocentumesh]

I have used the following commands, 

DELETE From Movie;

SELECT * FROM Movie;

TRUNCATE TABLE Movie;

i need to clear all the data from the table "Movie" but i can't help as soon as possible.........................

[Dhiraj Kumar Jha]

Dear Umesh,

we are yet to see update and delete queries,

 

DELETE FROM movie WHERE movie_id = 5  now the standard queries requires WHRE clause in UPDATE and DELETE.

 

TRUNCATE <table_name>    ;

 

is the command . Hhope your issue is solved.

 

Warm Regards,

Dhiraj Kumar Jha

Sr.  Web Developer, IT Trainer and Freelancer

http://www.softstuff4u.com.np

--