...

View Full Version : How empty Filed froma Tabel



ajloun
01-06-2010, 10:53 PM
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.

tomws
01-06-2010, 11:23 PM
That's a MySQL issue, not PHP. And you can't have an "empty" field because you've defined it as NOT NULL.

ajloun
01-06-2010, 11:38 PM
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.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum