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