Forums

Please, whats the appropriate way to save JSON data to MySQL database table column? Tried the code below but I get errors.

ALTER TABLE `1234_StudentResultCaptured` ADD `SCHSRCjsonphsycho` JSON NOT NULL AFTER `SCHSRCclass`;

Hi atanunu ,

Are you getting errors when you edit the table, or when you try to save data? The code you have there looks as if it should work in PHPMyAdmin to edit the table.

Bob