Re: User Variables doesn't work?
Thanks for your info, I d/l SQLyog and it seems really cool. > MySQLFront 2.5 had so many bugs that I had to leave > it. I prefer SQLyog now. Its FREE !!! and has all the > features ( plus some realy cool extra features ). > > You can try SQLyog at http://www.webyog.com/sqlyog > > Karam > --- Peter Brawley <[EMAIL PROTECTED]> > wrote: > > Not just MySQLFront. PhpMyAdmin chokes on it, too. > > > > - > > - Original Message - > > From: ML > > To: [EMAIL PROTECTED] > > Sent: Tuesday, May 27, 2003 9:08 AM > > Subject: Re: User Variables doesn't work? > > > > > > You are right, I tried from command line and it > > works, the problem occurs > > with MySQL Front v2.5. This is strange because I > > love this software and > > this > > is a strange bug... > > > > Regards. > > > > > > > > I'm using User Variables, I tried it with the > > query found in the mysql > > > > manul: > > > > SELECT @t1:=(@t2:=1)[EMAIL PROTECTED]:=4,@t1,@t2,@t3; > > > > But I receive this error: > > > > You have an error in your SQL syntax. Check > > the manual that > > corresponds > > to > > > > your MySQL server version for the right syntax > > to use near > > > > '(@t2NULL1)[EMAIL PROTECTED],@t1,@t2,@t3' at line 1 > > > > I have MySQL v4.0.12 > > > > > > Worked perfect for me. Did you execute the above > > query from command-line > > client or what client did you use? > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > __ > Do you Yahoo!? > The New Yahoo! Search - Faster. Easier. Bingo. > http://search.yahoo.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: User Variables doesn't work?
MySQLFront 2.5 had so many bugs that I had to leave it. I prefer SQLyog now. Its FREE !!! and has all the features ( plus some realy cool extra features ). You can try SQLyog at http://www.webyog.com/sqlyog Karam --- Peter Brawley <[EMAIL PROTECTED]> wrote: > Not just MySQLFront. PhpMyAdmin chokes on it, too. > > - > - Original Message - > From: ML > To: [EMAIL PROTECTED] > Sent: Tuesday, May 27, 2003 9:08 AM > Subject: Re: User Variables doesn't work? > > > You are right, I tried from command line and it > works, the problem occurs > with MySQL Front v2.5. This is strange because I > love this software and > this > is a strange bug... > > Regards. > > > > > I'm using User Variables, I tried it with the > query found in the mysql > > > manul: > > > SELECT @t1:=(@t2:=1)[EMAIL PROTECTED]:=4,@t1,@t2,@t3; > > > But I receive this error: > > > You have an error in your SQL syntax. Check > the manual that > corresponds > to > > > your MySQL server version for the right syntax > to use near > > > '(@t2NULL1)[EMAIL PROTECTED],@t1,@t2,@t3' at line 1 > > > I have MySQL v4.0.12 > > > > Worked perfect for me. Did you execute the above > query from command-line > client or what client did you use? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > __ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: User Variables doesn't work?
Not just MySQLFront. PhpMyAdmin chokes on it, too. - - Original Message - From: ML To: [EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 9:08 AM Subject: Re: User Variables doesn't work? You are right, I tried from command line and it works, the problem occurs with MySQL Front v2.5. This is strange because I love this software and this is a strange bug... Regards. > > I'm using User Variables, I tried it with the query found in the mysql > > manul: > > SELECT @t1:=(@t2:=1)[EMAIL PROTECTED]:=4,@t1,@t2,@t3; > > But I receive this error: > > You have an error in your SQL syntax. Check the manual that corresponds to > > your MySQL server version for the right syntax to use near > > '(@t2NULL1)[EMAIL PROTECTED],@t1,@t2,@t3' at line 1 > > I have MySQL v4.0.12 > > Worked perfect for me. Did you execute the above query from command-line client or what client did you use? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
