format list in text to table of applescriptstudio

Scripting Forums AppleScript Studio & Xcode
#1

Hi all, i have a list from MySQL like this

set mySQLCommand to do shell script "/usr/local/mysql/bin/mysql -D " & mysql_db & " -u " & mysql_user & " -h " & mysql_host & " -p" & mysql_pw & " -e  'Select * from clips where imagen like  \"%.jpg\"'"

set lista to mySQLCommand

and i try to convert in this format to applescript studio:

{|table column 1|:"live"}, {|table column 1|:"mix"}, {|table column 1|:"remix"}, {|table column 1|:"re-mix"}, {|table column 1|:"Unknown Pleasures"}, {|table column 1|:""}, {|table column 1|:""}, {|table column 1|:""}, {|table column 1|:"ret"}, {|table column 1|:""}, {|table column 1|:""}, {|table column 1|:""}, {|table column 1|:""}, {|table column 1|:""}, {|table column 1|:""}, {|table column 1|:""}}

tku guys

#2

Hi fatherjuan,

How does the value of mySQLCommand look like? You might want to post an example of what is returned from the ‘do shell script’.

gl,