Chris Dietzler wrote:
I am trying to pull cst_SiteID from a query result to use in another query:
SELECT cst_Name,cst_SiteID FROM customers WHERE cst_Name LIKE 'st%'
+------------------------------------------+------------+ | cst_Name | cst_SiteID | +------------------------------------------+------------+ | Stanley Associates | 8182 | | Starbucks Coffee Holdings | 9261 | | State Farm Mutual Automobile Insurance C | 9523 | | State of New York -NYMTC | 7356 | | State Street Bank and Trust Company | 8305 | | Staubach Company | 8240 | | Staveley Services | 8502 | | Stellar Internet Monitoring, LLC | 8665 | | Stonewall Kitchens | 8221 | | Strategic de Mexico | 4401 | +------------------------------------------+------------+
Can anyone help me figure out how to assign a new variable to the cst_SiteID for each row? Sincerely, Chris Dietzler
Well, if cst_SiteID is autoincrement, try: update customers set cst_SiteID=0 where cst_Name LIKE 'st%';
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
