Re: Error 0: Unable to execute statement

Could you provide more information? Is that the entirety of the error message?

In the meantime, if you just want to pre-populate 200,000 rows in that particular table, you can use the following procedure:

 DELIMITER #

 CREATE PROCEDURE fill(num_rows INT)

 BEGIN

   SET @x = 1;

   START TRANSACTION;

   REPEAT

     INSERT INTO table_name (code, tags) VALUES (@x, '');

     SET @x = @x + 1;

   UNTIL @x > num_rows END REPEAT;

   COMMIT;

 END#

 DELIMITER ;

On Wed, Jun 5, 2013 at 4:57 AM, Anjanesh Lekshminarayanan <anjanesh@gmail.com> wrote:

I created a table & tried pasting a large table row from my phpMyAdmin.

INSERT INTO `table_name` (`code`, `tags`) VALUES

(1, ''),

(2, ''),

.

.

.

(199998, ''),

(199999, ''),

(200000, '');

I got 

Error 0: 

Unable to execute statement.

How come there is no specific MySQL error ?

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.