I just looked at your table syntax. you've got two auto_increment pk
columns. do you always have a 1:1 correspondence between the name and
gene tables? would it not be better to have a gene_id column in name,
put an index on it, and then issue:
"alter table name add foreign key(gene_id) references
Aaron,
It sounds like the join has duplicates on both sides. If you join a->b
where a is unique (like a primary key) then you will get count(b)
records (where b is the rows that match a). Or if b is unique then you
will get count(a) records. However if neither a or b is unique you get
count(a) * co
Redhat 7.3
Kernel linux-2.4.18-3
Rgds
Terence
- Original Message -
From: "Richard Gabriel" <[EMAIL PROTECTED]>
To: "Terence" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, August 12, 2003 2:02 AM
Subject: Re: Error 127, some questions
What OS/kernel are you running? Thanks.
Can any 1 tell me whats the up level commands are well u might know what i
mean i know windows servers uses this type of way to go back a level such as
..\root-folder\ but whats Linux ? on my linux server how could i go back a
level to go to another folder ? i already tried using ..\ but it want u
Something to ask yourself in all this is, how fast can I change out a
piece of hardware? If I needed a high availability system, on the cheap
(ie, not a million dollars US worth of Sun hardware) I'd probably go
with a bunch of SuperMicro 2U rack mount servers with the hot swap SCSI
drives. You
David,
> Gah. That's what I was hoping to avoid. It's like writing BASIC and
> having to leave yourself room...
Yes, but unlike a basic program of 1 lines (heh, remember that!) you
only need to leave room for n questions. If n is small - no problem,
even if you have to 'renumber'. If n is lar
Hi
Can someone please tell me howto update a field (which is auto_increment)
for a range from say 4000 - 8000?
I only want to change info for listings in that range, if my database has
about 75000 listings
Kind Regards
Rudi Ahlers
Océ Software Support
+27 (11) 661-9000
"The basic difference be
setup a dsn in odbc and you could import via a tool called sqlyog
??
> Hi all,
>
> Does anyone have any suggestion for converting a Sequel database to
> MYSQL? I just want to copy a Sequel database data to a Mysql one.
>
> Thanks in advance for any suggestion,
>
> Mike
>
> --
> MySQL General Mailin
> -Original Message-
> From: Tomasz Korycki [mailto:[EMAIL PROTECTED]
> Sent: 11 August 2003 05:26
> To: [EMAIL PROTECTED]
> Subject: OT: Re: MySQL field data type for ISBN numbers
>
>
> At 21:08 2003-08-10, you wrote:
> >On Sun, Aug 10, 2003 at 05:25:05PM -0700, James Johnson wrote:
>
[snip]
But here's where I'm stuck: for each film, I need to pull the movie info
in
'movies', plus any related data from other tables, like this:
The Lord of the Rings | Peter Jackson | 3 comments
Episode II| George Lucas | 0 comments
Indiana Jones | Steven
Hi,
>> mysql> select * from Log_Forums where Date="2003080611";
>> mysql> insert into Log_Forums (pseudo,date,Type_Message) values
>> > ("doss08",2003080611,"0");
>
> insert into Log_Forums (pseudo,date,Type_Message) values
> ("doss08","2003080611","0");
>
Same thing here.
But i "sol
On 6 Aug 2003 at 12:04, Zach wrote:
> I'm trying to use a select statement for a table that uses numbers for
> the field names. Here is the query I've been trying. Please help!
>
> SELECT * FROM table_name WHERE '18'=1; (18 is the field name, 1
> obviously is the value I'm looking for.)
If it's
try the PHP function htmlspecialchars()
see the following article:-
http://www.yellowmarker.co.uk/articles/unicode/index.php
- Original Message -
From: "Steffen Gebert" <[EMAIL PROTECTED]>
To: "MySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Saturday, August 09, 2003 11:48 AM
Subject: Fi
Hello programmers,
I think something is wrong with my administration,
Basically I get these messages,
ERROR 1005 at line 9: Can't create table '.\company\department.frm'
(errno: 150)
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
ERROR 1133: Can't find any matchin
14 matches
Mail list logo