How empty Filed froma Tabel

Hello

I know how to Empty a Table from Mysql but how to empty a row or the filed from a Table . Example. this is my Table.

CREATE TABLE `txt` (
`id` INT( 25 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`file` VARCHAR( 255 ) NOT NULL ,
`txt` TEXT NOT NULL
)

from that table i need to empty 'file' filed . useing Phpmyadmin Command.

That's a MySQL issue, not PHP. And you can't have an "empty" field because you've defined it as NOT NULL.

That was an Example Table not the actual Table , anyway Somone Just passed the Command to me . its like

UPDATE tblename SET filedname='';

Sorry i did not Pay attention there is Forum for MYsql even i been here long time , lol.. ..thx for point it out.