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
(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 wi
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 goin
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).
>
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 er
- Original Message -
> From: "Bernd Lentes"
> 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 particular table.
> Automysqlb
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 fi
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 rights
