Thank You Like - Recount very slow

[lost puppy]

No, that works fine and returns a count of zero << if it is meant to do that??

It is meant to return a count of one given that the column now exists.

And I was expecting it to generate the same error given that the only change we made was to delete INTO @exist.

Let's put that back in again and see whether we get an error this time:

SELECT COUNT(*)
INTO   @exist
FROM   information_schema.columns 
WHERE  table_schema = database()
       AND
       column_name = 'tyl_tnumtyls'
       AND
       table_name = 'YOURPREFIX_threads';

That ran fine as well 

This is what it came back with (image cut short to hide my prefix .... but I am thinking that it may just be easier to show it all and change the prefix later)