I want to insert a value into a (one) field of all records in a table.

I tried:
INSERT INTO models (makeID) Values (1)

But that adds a new record, with the value filled in. I don't want a new record, I want that value inserted into all the records of table 'models' 'makeID' field.

Thanks in Advance,
Ted Rogers


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to