Re: genome sequence

[Thomas Spahni]

Hi Liz,

a column of type BLOB takes a maximum of 65535 bytes; try MEDIUMBLOB or
even LONGBLOB.

Regards, Thomas Spahni


On Tue, 20 Apr 2004 [EMAIL PROTECTED] wrote:

 hi,
  I am trying to enter genome sequences of length 170 and more into
 mysql database.

 I have created a table sequence like:

 create table sequence(seq blob);

 i am using python scripts to put the sequence into this field.
 the python GUI gives me this error:

 OperationalError: (2006, 'MySQL server has gone away')

 I am not able to enter the sequence.

 what is wrong???

 Liz




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

genome sequence

[lga2]

hi
   I am trying to enter a genome sequence of length 170 in a table.

I have created the table as

create table sequence(Seq blob);

I am using Python script to enter this sequence into the table.

I am getting an error 

OperationalError: (2006, 'MySQL server has gone away')

I am not able to store this sequence into the table.

what is wrong???

Liz

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

genome sequence

[lga2]

hi, 
 I am trying to enter genome sequences of length 170 and more into 
mysql database.

I have created a table sequence like:

create table sequence(seq blob);

i am using python scripts to put the sequence into this field.
the python GUI gives me this error:

OperationalError: (2006, 'MySQL server has gone away')

I am not able to enter the sequence.

what is wrong???

Liz

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]