472,127 Members | 1,608 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,127 software developers and data experts.


I am trying to convert a declare syntax from SQL to MySQL
the syntax is as follows:
declare @x int;
set @x = (SELECT max(ixBugEvent) FROM bugevent);

UPDATE bugevent
SET ixAttachment = (SELECT max(ixAttachment) FROM attachment),
ixBug = (SELECT max(ixBug) FROM bug)
WHERE ixBugEvent = @x;

but it is giving me an error. can anyone help.
thanks for your time in advance...

Jun 26 '06 #1
0 5781

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Not Me | last post: by
6 posts views Thread by Dylan Nicholson | last post: by
1 post views Thread by Jeff Magouirk | last post: by
15 posts views Thread by Geoff Cox | last post: by
23 posts views Thread by mark.moore | last post: by
2 posts views Thread by Sam Waller | last post: by
6 posts views Thread by John Bailo | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.