How to separate columns list with mysql

[Unknown_Designer (Himanshu)]

How to create saparate columns and create list with mysql

[CJcorp (Asit)]

Use something like this.

This is an example go through it and create according to your need

[Unknown_Designer (Himanshu)]

One More Thing @CJcorp how to remove columns name

[CJcorp (Asit)]

This is also in the image start loop from 2

[Unknown_Designer (Himanshu)]

Thanks

[Rogerio_Rios (Professional Support)]

#off-topic
Understand that this format with | between columns.
This is not the original return from Mysql it is a formatted return created in procedure blocks “display table”.

[pepocero]

App Inventor Tutorials and Examples: Dynamic Table Layout | Pura Vida Apps

With this method you can get the lists obtained from any query (also obtained from MySql) and put the data in a table. You can change the colours of the table using html.

I use this system.

I have a database in MySQL . I make a query and get a JSON. Then I convert that JSON to lists and put them in the table. And it looks very good.