Is that the error from the interactive sql prompt on the API console (https://code.google.com/apis/console/)?
If so, it's expected - the sql prompt cannot not handle large inserts.
You can pipe it through the command line tool (https://developers.google.com/cloud-sql/docs/commandline#savedsqlfile). Or, as you mentioned, importing from cloud stoarge should also work?
On Wed, Jun 5, 2013 at 11:28 PM, Anjanesh Lekshminarayanan <anjanesh@gmail.com> wrote:
An unexpected error has occurred. We're looking into it.
Error 0:Unable to execute statementThis 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.
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)BEGINSET @x = 1;START TRANSACTION;REPEATINSERT 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 gotError 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.--
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.--
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.
No comments:
Post a Comment