I want to store Android Table Data from my App into a MySQL database. Users can create tables and insert data and save those tables. For me it seems quite inefficient to save the table as corresponding rows and columns in the Database, because many tables mean many MySQL entries.
Is there any method more efficiently to achieve that? I'm thinking of using the MySQL json format to store the row and column data of an Android table so it will represent only one row in MySQL.
I have to store a table id and additional information for each table. These informations would be redundant if I choose the method of simply adding row and column data directly to MySQL.
Any hints on how to do this?