我正在从bash运行mysql查询,它应该将结果写入文件中。事情看起来是这样的(稍微简化一下):
mysql -uname -ppwd wmap -e "select netpoints.bssid,netpoints.lat,netpoints.lonusers WHERE ((users.flags & 1 = 1) AND users.idx=netpoints.userid) OR (netpoints.source=5);" >db
我希望将这个值列表保存为csv“单元格”中的单个字符串。具体来说,我有以下几点:#a csv file that looks something like this:1,name1,1users = pd.read_csv(csv_file, usecols= ['username', 'user_id'])
for row in users.itertuples