Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

variables don't update in mysql 4.1

Status
Not open for further replies.
tektipdjango

tektipdjango

IS-IT--Management
Jan 28, 2004
188
I've just installed mysql 4.1 on WinXP + easyPHP and I tried a few queries.
When I use variables, it looks like mysql don't update them

eg

Code: 
set @carr='test';
  select codeArt,artDesc,@carr myVar
from articles where 1;
the myVar column is empty!


--------------------------------------------------
[highlight]Django[/highlight] [thumbsup]
bug exterminator
tips'n tricks addict​
 
Sort by date Sort by votes
Strange! It certainly works on v.4.0.13. Looks like a bug report might be in order.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

E
  • Locked
  • Question
MySQL calculator tools
Replies
0
Views
269
EdZzy
E
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
478
lupidol
lupidol
dylim
  • Locked
  • Question
Why MySQL 5.7 is still getting updates
Replies
3
Views
352
spamjim
spamjim
dylim
  • Locked
  • Question
SQL_CALC_FOUND_ROWS still runs in MySQL 8.0.29
Replies
2
Views
497
dylim
dylim
lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
434
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top