Thank you for your support. In fact the problem was in MySQL Front. I tried using SQLyog and it passed very well. The problem is that SQLyog will not facilitate me in buying since I have no credit card!!! I am in Africa and the best payment method I have access to is by Western Union (http://www.westernunion.com)
Thanks Emery ----- Original Message ----- From: "Petr Vileta" <[EMAIL PROTECTED]> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 03:47 Subject: Re: Using SQL variables In mysql.exe type query and Enter and other query and Enter ... In MySQL-Front type more query on more rows and press F9. Every query runs in sequece from top to bottom as is typed on rows. See MySQL-Front help for using F9, Shift+F9 and Ctrl+F9 function. Other way is using some programming language as a Perl, Visual Basic, PHP and his appropriate libraries/packages. I preffer Perl, because it is very powerfull language, is free and exist for Windows and Linux too. Applications programed in Perl are portabled to Windows and Linux without any changes ;-) Petr Vileta http://www.practisoft.cz Ostatne soudím, ze letní cas musí být zrusen ! ----- Original Message ----- From: "Director General: NEFACOMP" <[EMAIL PROTECTED]> To: "Petr Vileta" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, September 24, 2003 10:01 AM Subject: Re: Using SQL variables > Yes you are right. > I run the query in SQLyog and it came very nicely. > > Thanks for your time and help. > > Another question is: How do I send multiple queries at the same time the > server? > > I mean, two instructions in the same query. > > Like > SET @var = 0; > SELECT (@var := @var + 1) AS Number, AnotherField FROM > any_table_with_records; > > > Thanks > Emery > ----- Original Message ----- > From: "Petr Vileta" <[EMAIL PROTECTED]> > To: "Director General: NEFACOMP" <[EMAIL PROTECTED]> > Sent: Tuesday, September 23, 2003 18:55 > Subject: Re: Using SQL variables > > > > > Can you run this query and tell me if it works on your machine? > > > SELECT (@var := @var + 1) AS Number, * FROM any_table_with_records; > > > As per the manual, this should give something like: > > > +---------------------- > > > Number FieldOne > > > 1 Value > > > 2 Value > > > 3 Value > > > ... > > > But when I run it the error is :You have an error in your SQL syntax > near > > > 'NULL @var + 1) AS Number BLAH BLAH BLAH > > > > Yeah :-) You are using MySQL-Front, is it right? I get the same error in > > mysql-front but the syntax is right, test it using mysql.exe - a native > > mysql client in DOS mode. If you will use this syntax in some program in > > VisualBasic, PHP, Perl or other the command still work ok. > > If you preffer GUI interface for work you can test SQLyog on > www.webyog.com > > > > Petr Vileta, Czech republic > > > > > > > > > > > > -- > 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]
