Re: Error 0: Unable to execute statement

An unexpected error has occurred. We're looking into it.

Error 0: 

Unable to execute statement

This is all that showed.

I can't use that procedure because there are some values for many (`code`, `tags`).

Can I save this as an sql file on google cloud storage and import that table ?

I ultimately intend on using phpMyAdmin to access this database for populating some of the fields.

---------------------------------------------------------
Thanks & Regards
Anjanesh Lekshminarayanan

On Thu, Jun 6, 2013 at 4:30 AM, Tony Tseng <ttt@google.com> wrote:

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 a topic in the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-cloud-sql-discuss/ds0KAI_yrVY/unsubscribe?hl=en.
To unsubscribe from this group and all its topics, 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.