Store 1000 values in singlecolumn of single table in MySQL

Question

I am very new to MySQL. I want to store 1000 or more values into a table of single column. After saving 100 values I got this:

mysql 139 storage engine error..

A little more information would be nice. What does your query look like? — Dai
– Dai, Commented Mar 17, 2011 at 11:11
You need to post the SQL you are using to insert the values... — Pablo Santa Cruz
– Pablo Santa Cruz, Commented Mar 17, 2011 at 11:12
i want to enter 1000 values in txt file that stores into database in that i have to take first two max values.I a m able to enter only 100 after that error.but first two max values is 250 values and 350 value in txt file i have.. — myth
– myth, Commented Mar 17, 2011 at 11:19
You still haven't posted the actual query or code you're using. — Furicane
– Furicane, Commented Mar 17, 2011 at 11:25
INSERT into Telerythm VALUES('"+"600"+"',"+now+",'"+sb1.toString()+"'); — myth
– myth, Commented Mar 17, 2011 at 11:32

georgepsarakis · Accepted Answer · 2011-09-04 08:01:16Z

Are you using the InnoDB or MyISAM engine? This error normally means that you exceeded the allowed row length. Please post your table structure here.

You can do that from a command line client by issuing the command:

SHOW CREATE TABLE yourtable;

Hopefully since asking this question the OP has decided that storing 1000 comma delimited values in a single column has certain drawbacks and abandoned the idea!

1 Answer 1