Hello folks
Can I use or implement database relations in sql as some do in databases
in accecss..?
tommie
--
___
msc. tomas alberto ramirez.andujar
webmaster - cejisoft - +5332 262451 /261410
universidad pedagogica jose marti. camaguey
circunvalacion norte
niversidad pedagogica jose marti. camaguey
circunvalacion norte km 51/2 cp 74670. cuba
email : [EMAIL PROTECTED]
url: http://www.esicm.cu/cejisoft
-Mensaje original-
De: tommie ramirez.andujar [mailto:[EMAIL PROTECTED]
Enviado el: Saturday, May 29, 2004 12:14 PM
Para: [EMAIL PROTECTED]
Asunto
from National to World events, is it
possible?
Yours
tommie
___
msc. tomas alberto ramirez.andujar
webmaster - cejisoft - +5332 262451 /261410 universidad pedagogica jose
marti. camaguey circunvalacion norte km 51/2 cp 74670. cuba
[EMAIL PROTECTED] - www.esi
>From what I understand. Move the volunteer_id from the contributor table.
put the contributor_id inside the volunteer table.
This way you can have a 1-to-many relationship between the two.
---
Get inside Atlanta's Tech Scene - http://www.atlantageek.com
'Business Intell
=t2.f1 group by t1.f1;
+--+---+
| f1 | count(distinct t2.f2) |
+--+---+
|1 | 1 |
+--+---+
1 row in set (0.01 sec)
regards,
tommie
-
Before posting, please check:
If I am not mistaken I think you are trying to do a nested select.
This is not possible in Mysql. I've had similar problems.
You will have to use some sort of recursive algorithm in your perl code
(if you are using perl)
to accomplish this.
Phil Latio wrote:
>
> I hope somebody may of come acro
'varchar(16) binary' works in 3.22 and tinyblob works in 3.23.
by work I mean I can insert hexidecimal numbers into the field.
I am basically treating it as an integer field. I can store 16 byte
numbers in the field and in the case of varchar(16) binary on mysql 3.22
I could store a 32 character
gt; You are trying to insert a hex value of 0x1, right? I think this is an
> > > illegal value and those two entries are set to NULL. MySQL behaves
> > > differently from standard in that it inserts default values instead, if
> > > there is an error, which in your cas
is is an
> illegal value and those two entries are set to NULL. MySQL behaves
> differently from standard in that it inserts default values instead, if
> there is an error, which in your case, would be NULL. What you want instead
> is an integer column.
>
> - Original Message
In the process of converting over to 3.23.30-gamma from 3.22
whenever I set the field to a binary field to a value it stores it in
the database as zero.
Does anyone have any suggestions.
I am having a problem with the binary data type... Here is the log to
demonstrate.
---
In the process of converting over to 3.23.30-gamma from 3.22
It appears that a table with field 'key varchar(16) binary' as a
primary key.
Whenever I write a record to this table and then do a select the value
of the field seems to be zero.
I do a 'select * from table where key=0x0' I get all t
11 matches
Mail list logo
