<div>
This does not look like a PHP script, since the variable names do not start with dollar signs. &nbsp;Suggest you request attention and ask a moderator to put this into the correct zones for the languages you're using.
</div>


<div>
Thanks. &nbsp;It's useful and I'll use it elsewhere.
</div>


<div>
<div class="content wysiwyg-content">
I tried the following.<br />
<br />
<br />
from alembic import op<br />
<br />
&nbsp; &nbsp; # Convert character set to utf8<br />
&nbsp; &nbsp; for table in op.execute(&quot;SHOW TABLES&quot;):<br />
&nbsp; &nbsp; &nbsp; &nbsp; print tables<br />
&nbsp; &nbsp; &nbsp; &nbsp; op.execute(&quot;alter table &quot;&nbsp;+ table + &quot;&nbsp;convert to character set utf8 collate utf8_general_ci&quot;)<br />
<br />
throws the following error:<br />
TypeError: 'NoneType' object is not iterable<br />
<br />
I also tried<br />
<br />
&nbsp; &nbsp; tables = op.execute(&quot;SHOW TABLES&quot;)<br />
&nbsp; &nbsp; for table in tables():<br />
&nbsp; &nbsp; &nbsp; &nbsp; print tables<br />
&nbsp; &nbsp; &nbsp; &nbsp; op.execute(&quot;alter table &quot;&nbsp;+ table + &quot;&nbsp;convert to character set utf8 collate utf8_general_ci&quot;)<br />
<br />
throws the following error:<br />
TypeError: 'NoneType' object is not callable
</div>
</div>


I tried the following.


from alembic import op

    # Convert character set to utf8
    for table in op.execute("SHOW TABLES"):
        print tables
        op.execute("alter table " + table + " convert to character set utf8 collate utf8_general_ci")

throws the following error:
TypeError: 'NoneType' object is not iterable

I also tried

    tables = op.execute("SHOW TABLES")
    for table in tables():
        print tables
        op.execute("alter table " + table + " convert to character set utf8 collate utf8_general_ci")

throws the following error:
TypeError: 'NoneType' object is not callable

How can I iterate through mysql tables to alter character set?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Python is a widely used general-purpose, high-level programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than would be possible in other languages. Python supports multiple programming paradigms, including object-oriented, imperative and functional programming or procedural styles. It features a dynamic type system and automatic memory management and has a large and comprehensive set of standard libraries, including NumPy, SciPy, Django, PyQuery, and PyLibrary.