Hello Binay.
Friday, December 19, 2003, 2:04:51 PM, you wrote:
B> Hi Andrey,
B> many thanks for quick response. plz find my further query below.
>> AFAIR, you usu. do that with:
>> LOCK TABLE mytbl WRITE;
>> // do smth. here
>> UNLOCK TABLE mytbl;
B> ++
B> How can i achieve the
Hello Binay.
Friday, December 19, 2003, 1:53:01 PM, you wrote:
B> I want to put write lock on a(set of) table(s), so that only i
B> can insert into it and no body else unless i remove the write lock.
B> How can i achieve it??
AFAIR, you usu. do that with:
LOCK TABLE mytbl WRITE;
// do smth. her
Hello noel.
Wednesday, December 10, 2003, 5:09:30 PM, you wrote:
nkmdi> If not is there anyway to automatically generate primary keys for
nkmdi> tables in MySQL.
CREATE TABLE ttt (
id int not null auto_increment primary key,
name varchar(100) not null
);
Please note "auto_incremen
Hello Lemasson.
Monday, December 8, 2003, 8:16:18 PM, you wrote:
LS> I have a table witch has a column of type VARCHAR(10)
LS> BINARY. When I tried to insert white spaces in it (insert into
LS> mytable (mycolumn) values('')), an empty String is stored. Why?
This is a documented behavior:
