Hi Mohammad,
I am sorry I am not usre what exactly you are after, but you could use, HAVING or LIMIT to restrict an UPDATE statement. Best regards Nils Valentin Tokyo/Japan 2003年 7月 24日 木曜日 05:29、Mohammad Khan さんは書きました: > Is there any way to restrict UPDATE without a WHERE clause? > > > Mohammad Khan > Software Engineer > Legal Computer Solutions, Inc. > 107 Union Wharf > Boston, MA 02109 > http://www.lextranet.com > (617) 227-4469 x 212 -- --- 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]