Dear Team;
In old days we can see data in phpMyAdmin against each row. But now it is not. There is a way to view data in phpMyAdmin other than rational table.
Best regards.
Arshad
View Data in phpMyAdmin
-
- Posts: 574
- Joined: July 9th, 2012, 11:32 am
- Location: Islamabad, Pakistan
Re: View Data in phpMyAdmin
Questionnaire content is stored as compressed JSON. Easiest way to view a case is using MySQL Workbench using the query
SELECT uncompress(questionnaire) FROM DICT_NAME where caseids = '<your caseid string>';
In the result grid you can right click on the cell and open in value viewer as Text/JSON
SELECT uncompress(questionnaire) FROM DICT_NAME where caseids = '<your caseid string>';
In the result grid you can right click on the cell and open in value viewer as Text/JSON
-
- Posts: 574
- Joined: July 9th, 2012, 11:32 am
- Location: Islamabad, Pakistan
Re: View Data in phpMyAdmin
Dear Savy;
How can update case in phpmyadmin through sql query.
Best.
a.
How can update case in phpmyadmin through sql query.
Best.
a.