Hi Gilles!
Just use `dec` and it will work fine. DEC is as you suspected a reserved
word and can only be used as column namne if you put it in
``-syntax.
Example:
create table astronomicalvskeywords (
`dec` float not null,
`ra` float not null
);
...will create:
desc astronomicalvskeywords;
Not sure what you're aming for here and how your data is structured but
why not use a join and alias and fetch all info in one select and then
solve what you need in your code?
Something in the line of:
select t2.col2 from_t2, t3.col2 from_t3
from table1 t1, table2 t2, table3 t3
where t1.id = t
fre 2006-06-23 klockan 01:52 -0400 skrev Michael Stassen:
> Thomas Lundström wrote:
> > Not sure what you're aming for here and how your data is structured but
> > why not use a join and alias and fetch all info in one select and then
> > solve what you need in your
\mysql\bin\winmysqladmin.exe tool.
Regards,
Thomas Lundström
----
Thomas Lundström
mailto:[EMAIL PROTECTED]
-Original Message-
From: Roberto Maisenhelder [mailto:[EMAIL PROTECTED]
Sent: den 16 december 2004 12:48
To: [EMAIL PROTECTED]
Subject: A Begi
pc net is a good idea. Put a
firewall in between (maybe controlled by your IT-department so they can
sleep at night?) and make sure it only allows database traffic. Then you
have a solution in the right line of thinking by my book.
Regard,
Thomas
Thomas
nt of dirty data between different systems.
Be careful when not including NOT NULL columns in your inserts...
To get around the problem and get more background info, read:
http://dev.mysql.com/doc/mysql/en/constraint_NOT_NULL.html
Regards,
Thomas Lundström, Ongame E-Solutions AB
-Ori
