CODEWITHSUNDEEP
phpmysqlwamp
user1583647
user1583647

Reputation: 1245

Error executing big sql statements

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.

Upvotes: 0

Views: 279

Answers (1)

Frank
Frank

Reputation: 91

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

Upvotes: 2

Related Questions