Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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 ?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement