# Action Mysql Select To UI

This action is for data string generation. You define every column you want to select and store it to one **Global** or **Local** variable.

![](https://1038266918-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MOWoZRvpfXHIVNe7SxM%2F-MPJGGX0IR-ekJ4LBbnC%2F-MPJrRO3iDVyB0GuCRuV%2Fssss.png?alt=media\&token=bd835929-0505-444a-9c48-7a6ec5457d50)

Next step is to use Action **Parse String To UI.** 

![](https://1038266918-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MOWoZRvpfXHIVNe7SxM%2F-MPJGGX0IR-ekJ4LBbnC%2F-MPJrjX9nBXwUb8GbJRT%2Fparsestring.png?alt=media\&token=74880fae-200f-4f03-a8cd-7e2d43c693c5)

Define **Data String**, select **Parent Object**, for example, Panel object for this data to be shown, set Header **text color** and **opacity to 1** and text size, fill in all columns data. Header prefab - prefab where header text will be shown, header text - text object with some text for header, datatype - choose text or image. If image - it must be stored to database in base64:

### Example:

**Your image code:** data:image/jpeg;base64,/9j/4SNqRXhpZgAATU0AKgAAAAgADAEAAAMAAAABA

**You need to delete:** data:image/jpeg;base64,

**So your string must be like:** /9j/4SNqRXhpZgAATU0AKgAAAAgADAEAAAMAAAABA

Now make **keyDown trigger** to activate this action and show **Panel.** You will see "Table like" data in your canvas.

### Full story for this example is here:

{% embed url="<https://youtu.be/zXuNW03qayM>" %}