擅长:python、mysql、java
<p>我把所有的东西都包括进去了。现在我不需要调用函数<code>test</code></p>
<pre><code>cursor.execute('''SELECT (SELECT CONCAT_WS(',',id,name,eg,access)
from tabl_name where id=ofk.demo_id) AS result
,cd.name, cd.no,ofk.demo_id
FROM `main_table` as myo
LEFT JOIN `table1` as emt ON emt.some_id = myo.some1_id
LEFT JOIN `table2` as ofk ON ofk.id = myo.kit_id
LEFT JOIN `table3` as cd ON cd.eg_id = myo.eg_id
WHERE emt.type="test" '''
result = dictfetchall(cursor) # function to get data in form of dictionary
tmp_list, tmp_dict = [], {}
for res in result:
try:
info = res['result'].decode("utf-8").split(",") # converting res['result'] from bytes to string
except:
info = res['result'].split(",") # res['result'] is in string form
tmp_dict['name'] = res['name']
tmp_dict['no'] = res['no']
tmp_dict['data1'] = info[0] # id
tmp_list.append(tmp_dict.copy())
</code></pre>
<p>这个东西让我的代码快了10倍</p>