Difference between DDL and DML

Problem

The engineering team is building a new microservice and they need a quick test table. As the new intern, you are tasked with creating this table and inserting a single record to verify the connection. Create a table named test with a single integer column id (DDL), and then insert the value 1 into it (DML). Finally, retrieve the data.

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution