Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
FLUSH TABLES
Message
 
 
À
14/10/2009 10:18:18
Hee Lim Wang
Fantasy Software Enterprise
Malaisie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
01429299
Message ID:
01429335
Vues:
55
I'm not familiar with mysql.

>I'm using mysql
>how about backup ?
>
>
>What SQL tables are you referring to? If you're talking about MS SQL Server and such, than any changes will be visible to other connections as soon as transaction is committed.
>
>>We always have to flush force after replace table fields with variables in VFP
>>in order to retrieve data immediately from other pc
>>
>>Do we also need to FLUSH TABLES after insert or update in SQL tables ?
>>Which is one better FLUSH TABLES; or FLUSH TABLES WITH READ LOCK; ?
>>Or do we need to sqldisconnect() to close everything and reconnect again ?
>>
>>Can we set auto backup data with Windows Scheduled Tasks for every 3 hours ?
>>Do we always need to lock tables during backup data ?
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform