Yes, I want to update all row in one query
--- Michael Stassen <[EMAIL PROTECTED]>
wrote:
> 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
>
__________________________________
Do you Yahoo!?
Make Yahoo! your home page
http://www.yahoo.com/r/hs
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
