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
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
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;
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
\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
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
