Guest User

Untitled

a guest
Dec 15th, 2017
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. results = c.execute(select).fetchall()
  2.  
  3. stroka = ''
  4. for line in results:
  5. stroka = stroka + str(line) + 'n'
  6.  
  7. self.ui.textEdit.setText(stroka)
  8.  
  9. text = 'n'.join([str(line) for line in results])
  10.  
  11. text = 'n'.join(map(str, results))
  12.  
  13. sqlite> select * from tab;
  14. s
  15. ----------
  16. 111
  17. 222
  18. 333
  19.  
  20. sqlite> select group_concat(s,'') from tab;
  21. group_concat(s,'')
  22. ------------------
  23. 111222333
  24.  
  25. sqlite> select group_concat(s,'n') from tab;
  26. group_concat(s,'n')
  27. --------------------
  28. 111n222n333
Add Comment
Please, Sign In to add comment