469,610 Members | 2,101 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,610 developers. It's quick & easy.

DECLARE SYNTAX

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 5699

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
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.