执行大型sql语句时出错

Question

I am trying to run a very very long sql statement but I get this error

Thread stack overrun: 230352 bytes used of a 262144 byte stack, and 32000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.

How can I assign a bigger stack or solve this problem?? I am using wamp, localhost.

Answer 1

If you have queries that large then you really should be passing parameters into a stored procedure, or batch execution of the SQL. You can change the WAMP MySQL initialization if required, or just use PHPMyAdmin