Home > Archive > PHP Programming > August 2005 > mysql strange behaviour
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
mysql strange behaviour
|
|
| Bob Bedford 2005-08-30, 7:55 am |
| I've no access to mysql NG, so I ask here.
I've a strange behaviour with mysql.
when I do a select from a simple table, then I get a result for a certain
field
when I then put a "union" and create a query that return no result, I get an
other result for that field. All other fields seems ok.
the field's type are different (one is a mediumint(8) and the other is a
char(13)) it is a problem ?
| |
| Obvious 2005-08-30, 7:55 am |
| On Tue, 30 Aug 2005 11:58:37 +0200, Bob Bedford wrote:
> I've no access to mysql NG, so I ask here.
Then subscribe to the MySQL mailing list it's free and details can be found
at the MySQL site.
| |
| Darkstar 3D 2005-08-30, 7:55 am |
| I concur with the Obvious. Also when asking questions like that
anywhere, putting "union" instead of your actual code hampers anyone
from helping. Sometimes when you type out your query to post you see
the error of your ways as well. At least, I do!
| |
| Andy Hassall 2005-08-30, 6:56 pm |
| On Tue, 30 Aug 2005 11:58:37 +0200, "Bob Bedford"
<bedford1@notforspammershotmail.com> wrote:
>I've no access to mysql NG
That's because there isn't one yet. But see:
http://www.uvv.org/cgi-bin/getmsg/3750 ... for how to vote if you want one.
In the meantime, there's MySQL mailing lists you can use.
>when I do a select from a simple table, then I get a result for a certain
>field
>when I then put a "union" and create a query that return no result, I get an
>other result for that field. All other fields seems ok.
This is all very vague. You'll need to post a runnable example.
--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
|
|
|
|
|