Hello, I'm having some problems to figure out how I could handle my
problem with innodb.
my table is innodb engine:
CREATE TABLE `videos_innodb` (
`video_id` int(10) unsigned NOT NULL auto_increment,
`client_id` int(10) unsigned default NULL,
`client_id_upload` int(11) NOT NULL default '0',
On Feb 12, 2008 12:28 PM, Frederic Belleudy [EMAIL PROTECTED] wrote:
select video_id from videos_innodb where state='QUEUE' limit 10 FOR UPDATE;
= it's waiting for the first to session to commit, so I cannot get
other videos with the same state!!
commit;
= I get 10 video_id