[alecoder]

hey all
i want delete one field in mysql table
for example Delete one field where id = "5"
see picture

Attached image(s)

• 

[Nayana]

What do you mean? You can't delete a field.

Are you trying to delete

• One record?
  
• The contents of a field within a record?

Thanks. And you better give us your attempt as well.

This post has been edited by Nayana: 09 February 2008 - 01:52 AM

[alecoder]

no i want delete field value
for example
we have table
-------------------------------------------
id name name2 name3 name4
-------------------------------------------
1 john pavel george abbye
-------------------------------------------
2 alex lilian nick jefry
-------------------------------------------

and i want delete value where id = 1 and if name || name2 || name3|| name4 value john delete then
i want delete one record ya

This post has been edited by alecoder: 09 February 2008 - 02:16 AM

[chuck87]

If you are trying to delete a row with ID= 1 you should do it like this

delete from tableName where ID=1;

[PsychoCoder]

Here is the mySQL Reference Manual that will help you tons in the future. For a delete the syntax is

Quote

DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name
[WHERE where_condition]
[ORDER BY ...]
[LIMIT row_count]

So all you would need for your questions would be a statement similar to

DELETE from table_name where id=1

[alecoder]

this deleting all where id = count
i want delete one element in table where id = count
for example we have id and img name
$id = 5;
$img_name = "img1000";

and we have table where writen meny img names
img1 img2 img3 img4 img5
and i want delete one element in tablename where id = $id and if some
img1 or img2 or img3 or img4 or img5 = $img_name delete this imgname

[Nayana]

Why don't you just read a tutorial on SQL?

Anyway. What you are trying to do is change the value of the cell to nothing. You can't just delete a cell leaving a hole in the table. Just use the UPDATE statement.

UPDATE table_name SET imagename = NULL WHERE id = 1

This post has been edited by Nayana: 10 February 2008 - 11:48 AM