擅长:python、mysql、java
<p>对于您的请求,<code>data_all</code>是1个元素的元组上的iterable</p>
<pre><code>`y = "%s" % x` properly converts a 1-element tuple to a string, but you're right, it's not the best way.
</code></pre>
<blockquote>
<p>fetchall(): Fetches all (remaining) rows of a query result, returning a list. Note that the cursor’s arraysize attribute can affect the performance of this operation. An empty list is returned when no rows are available.</p>
</blockquote>
<p>要获取此元素并创建包含字符串的列表,请执行以下操作:</p>
<pre><code>[x for (x,) in data_all]
</code></pre>
<p>这将解压元组中的<code>x</code>,并创建一个字符串列表(相当于<code>[x[0] for x in data_all]</code>)</p>