--- arunmohan kamalakannan <[EMAIL PROTECTED]> wrote: > Question: > 1.What are all the ways to optimize query? > 2.Can we able to implement commit,rollback transaction in php,mysql > connection like oracle database? If yes how? can u able to give the > guidelines or sample scripts... If no.. Then there is no security for > transaction. Is it? > 3.Can I able to lock or unlock a record in a mysql table through php > interface? If can't it is also another drawback. > > Normally I donot using commit,rollback transaction and lock concepts when I > program using php mysql. I believe it is not good. How do I make it good? > > Regards, > Arun
MySQL can handle several table types. The default is MyISAM and it does not permit the use of transactions. However, another type, InnoDB, does. You should look for information on this table type. James ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12h6stukb/M=362335.6886445.7839731.1510227/D=groups/S=1705005703:TM/Y=YAHOO/EXP=1123744099/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</a>.</font> --------------------------------------------------------------------~-> Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
