At 10:42 AM +1100 2000-03-14, Greg wrote:
>that produces an error in both the mysql client and using the
>mysql_query() function from the C program I'm working on.
>
>However, I can lock one table
What version of MySQL are you running, and let's see your
exact statement.
>
>> -----Original Message-----
>> From: Quentin Bennett [mailto:quentin.bennett@stripped]
>> Sent: Tuesday, 14 March 2000 10:26 AM
>> To: 'Greg'; mysql@stripped
>> Subject: RE: locking multiple tables
>>
>>
>> Hi,
>>
>> RTFM
>>
>> LOCK TABLES tblname ..., tblname ..., ...
>>
>> > -----Original Message-----
>> > From: Greg [SMTP:greg@stripped]
>> > Sent: Tuesday, March 14, 2000 12:16 PM
>> > To: mysql@stripped
>> > Subject: locking multiple tables
>> >
>> > I want to lock two tables at the same time
>> > Is that possible ?
> > > How ?
--
Paul DuBois, paul@stripped