Re: updating multi row after fetch

[Michael Stassen]

Aji Andri wrote:
my table properties
`STY_REPORT_200501` (
  `std_nis` int(10) NOT NULL default '0',
  `std_class` varchar(10) default NULL,
  `std_item` int(2) default NULL,
  `std_value` float default NULL,
  `std_letter` char(2) default NULL,
  `std_entusr` varchar(10) NOT NULL default '',
  KEY `std_class` (`std_class`),
  KEY `std_item` (`std_item`),
  KEY `std_value` (`std_value`),
  KEY `std_letter` (`std_letter`),
  KEY `std_entusr` (`std_entusr`)
) TYPE=MyISAM;
I'm doing this query 
SELECT * 
FROM `STY_REPORT_200501` 
WHERE 1  LIMIT 0 , 30 

when I how do I make multi row update based on my
fetch result ?
We need more information.  Do you want to update those rows, or use the 
data in those rows to update another table?

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