Anyone know SQL queries?

[sdsumike619]

Can someone here tell me the SQL command to delete data from a certain field of a table, in all rows of that table?

In other words, say there are 100 rows/records in a table and there's a column/field in that table called Name. I want to delete the Name from every row. But I don't want to remove the field itself....

[RabidDog]

Delete(rec=1,200: field=name,all)

[Gramps]

The DELETE command in SQL would delete the entire row, which is not what you want. If you want to just clear the values in the field without deleting the entire row, then you should use the UPDATE SQL command.

Let's say your table is called MYTABLE, with the field called Name in it. While syntax can vary between flavors of SQL, generally the following should work. The syntax to empty the field values is:

UPDATE "MYTABLE"
SET "Name" = NULL

If that command generates an error because of the NULL keyword, try:

UPDATE "MYTABLE"
SET "Name" = '' (This last '' is two single quotes. The others are double quotes.)

[sdsumike619]

Thank you