Hannes Niedner writes:
> I just checked upon the following query which was already running for 3+
> hours. The sequence field is a non-indexed text field (is for once only
> join).
>
> mysql> create table genpept_sequence_protein
> -> select sequence_id, genpept_20010726_113345.* from sequence_protein,
> -> genpept_20010726_113345
> -> where sequence_protein.sequence=genpept_20010726_113345.sequence
> -> order by sequence_id;
> ERROR 2013: Lost connection to MySQL server during query
>
> Although I got this error message the table was created. My question is, is
> the table complete?
>
> Thanks in advance for you input
>
> Hannes
>
>
Rather hard to tell.
Run : select * from table and see for yourself.
The above should not happen with our latest binaries.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php