Introduction to Structured Query Language (SQL) Query Solution || Coursera 2022 || Week
You just need to run this query in phpMyAdmin and according to given input data you just write in the user table. And after run the below query you click on export menu in the up side and follow the instructions. And First of all create database named as "roster" When you have the data all inserted, use phpMyAdmin to Export the data as follows: Select the database (do not select a table within the database) Select the Export Tab Select "Custom - display all possible options" Select "Save output to a file" Set the format to JSON Do not select "pretty print" the output Leave everything else as default and run the export. NOTE : "DON'T CHANGE THE USER_ID " you only change the name. Rest of the query is same. So here is the query CREATE TABLE `course` ( `course_id` int(11) NOT NULL, `title` varchar(128) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO `course` (`course_id`, `title`) VALUES (1, 'si106'), (2, ...
