Hi. On Thu, Oct 04, 2001 at 02:43:34PM +0000, [EMAIL PROTECTED] wrote: > how can i to work with mysql without transactions > and foreign keys with same security, keeping the > integrity of data ?
MySQL has transaction support. You can find a try to answer your questions at: http://www.mysql.com/doc/M/i/Missing_functions.html > and i want to have in my university different host > update insert beetwent its, without transactios, > how can i do?, if not is possible stop never one > server Sorry, but I am not able to parse what you wrote here. Could you please rephrase what you asked? Thank you. > i know some for you documentation: make replication is > necesary stop the machines > is possible update with sql, without stop machines? It's not necessary to stop the machines, but only the MySQL server. And only for a second to reload the config file. Then you can use LOAD TABLE ... FROM MASTER to initialiaze the replication afterwards. > with atomic operations there is same data integrity? Yes. If you take care of the paradigm. > i have one model i used foreign keys, how can i do > to work good with your sistem? > > where is more information samples of the > atomic operations In the manual section I cited above. > thanks some information ..... samples o links in the > web Well, if the work-arounds for missing functionality get to troublesome for you, it could be that MySQL's preferences (first speed) is not what you need and you may want to look at postgre SQL. Bye, Benjamin. -- [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
