Hello Everyone!
I am having a big problem with counting inserting rows.
This is my Query:
SELECT MAX(id) INTO @maxid FROM table1; // @maxid is now 44
INSERT INTO table2 (orderid, someothervars)
SELECT @maxid +1, blahvar FROM table3;
Okay my problem is, how do i increase the maxid?
like that.
table2:
| id | orderid | someothervars
+----+---------+--------------+
|1 |44 | blah |
|2 |45 | blah |
|3 |46 | blah |
|4 |47 | blah |
|5 |48 | blah |
....
And so on.
Anyone has an idea how to do something like that?
I think it works somehow with SET @maxid = @maxid +1
But i fail combining it with INSERT SELECT :/
Any help is greatly appriciated =)
My best wishes
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
