Hi Ted, I believe you are looking for UPDATE ..... (no WHERE clause).
Warning: This will update ALL fields within a column. INSERT... will insert a single datarecord, while UPDATE... will change a value of a single field usually, but without WHERE clause it will update ALL fields in a column. Be careful with UPDATE .. when not using a WHERE clause. I suggest you try this on a test database as otherwise you may want to blame me for the advice given ;-). Best regards Nils Valentin Tokyo/Japan 2003年 6月 26日 木曜日 13:[EMAIL PROTECTED] さんは書きました: > 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 -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]