Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Lock Table and auto commit

 
   Database Forums (Home) -> PHP SQL RSS
Next:  A blog to lift the fog on Dataphor  
Author Message
robert stearns

External


Since: Oct 08, 2008
Posts: 3



(Msg. 1) Posted: Mon Nov 17, 2008 12:03 am
Post subject: Lock Table and auto commit
Archived from groups: alt>php>sql (more info?)

When I use LOCK TABLE ... COMMIT, must I also use
odbc_autocommit(dbConn, FALSE)? In other words will auto commit
prematurely defeat the LOCK TABLE?

 >> Stay informed about: Lock Table and auto commit 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SQL table - Hi I nead little help. First sorry for my terreble english. I have MySql table on one database server, and i wanna copy (append) her data into another table on other database server. And after that i wanna delete data from first server. Example; ..

How to use a value in table in query? - mysql> select * from G; +------------+-----------+----------------+--------+ | first_name | last_name | modified | offset | +------------+-----------+----------------+--------+ | Mick | White | 20050923102539 | -5 |..

UPDATE ON Table - I have two tables tblLogin and tblTrades I have 3 fields in each table, for thr purpose of this question tblLogin Fields are MemberNo RegNo Country tblTrades fields are MemberNo RegNo Country the Tables

want to create table from old table - old table has place names, say a to z. new table has to list all posssible connections, ie, a-b ,a-c , b -a . can anyone point me in the right direction for how to do this? tia.

Can't create table - Hello all, I have the following query : CREATE TABLE IF NOT EXISTS `pm_tusers` ( `id` INTEGER NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`) ) TYPE=InnoDB AUTO_INCREMENT=1 And I receive the following error: ERROR NR:1005 ERROR :Can't create table...
   Database Forums (Home) -> PHP SQL All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]