Hi,
we just migrated from 5.0 to 5.5. Nearly everything went well. But we can't
access one particular table.
Automysqlback 3.0 says: mysqldump: Got error: 1142: SELECT,LOCK TABL command
denied to user 'backup'@'localhost' for table 'cond_instances' when using LOCK
TABLES.
root has these
Hi:
I tried to get a S-lock using following SQL:
1. start transaction;
SELECT * FROM test.t1 where id=1;
But I found this way does not work. I changed it as following:
2. start transaction;
SELECT * FROM test.t1 where id=1 lock in share mode;
I am wondering why the
- Original Message -
From: Bernd Lentes bernd.len...@helmholtz-muenchen.de
To: mysql@lists.mysql.com
Sent: Wednesday, 28 May, 2014 10:10:33 AM
Subject: access problem for a particular table
we just migrated from 5.0 to 5.5. Nearly everything went well. But we can't
access one
Gurus,
I am going to have a big table with lot of records, to expedite searching i
wanted to index on a key field (which is numeric value). BUT, there will be
records which will have same value for the key field (other columns will be
different).
so how can i do this? right now, i am getting
Am 28.05.2014 21:43, schrieb Rajeev Prasad:
I am going to have a big table with lot of records, to expedite searching i
wanted to index on a key field (which is numeric value). BUT, there will be
records which will have same value for the key field (other columns will be
different).
so
Am 28.05.2014 22:29, schrieb Rajeev Prasad:
I am using phpMyAdmin, i looked closely and found index is this index you
are talking about? (earlier i used Primary).
surely
primary is a uniqe key, honestly consider to read some manuals
My further question is: the index key here is going to
(re-sending, i got err from yahoo)
thx Reindl,
I am using phpMyAdmin, i looked closely and found index is this index you are
talking about? (earlier i used Primary).
My further question is: the index key here is going to be epoch system time. I
currently have it as integer 10. The table will
Am 28.05.2014 22:39, schrieb Rajeev Prasad:
(re-sending, i got err from yahoo)
your previous message made it off-list to me
*don't use reply-all on mailing lists*
signature.asc
Description: OpenPGP digital signature