Thread

insert using select with limit

Theo Kramer <theo@flame.co.za> — 1999-12-10T10:57:17Z

Hi

Just noticed that limit is ignored when using a select to insert
into a table.

Eg. insert into mytable (f1, f2) select f1, f2 from myothertable limit 10;

selects all records from myothertable.

Using the select with limit on it's own works fine.

Version 6.5.2 on RH6

--------
Regards
Theo