Let us now write a query to let the user create a post on our platform. Write a SQL query to insert a new record into the "post" table on our platform? The new entry should include the following details: set the "username" field as 'newton', the "post$\_$title" as 'Intro to MYSQL$\text{'},$ and the "post$\_$description" as $\text{'}$My First Post'. Kindly note that this post entry does not include any associated photo.

Tables Schema as Below:

post

columnName dataType

id int

username varchar$(24)$

post$\_$title varchar $(72)$

post$\_$description text

datetime$\_$created datetime

number$\_$of$\_$likes int

photo blob

Hint

Q$2.$

SQL $-$ Table Creation

easy

Let us start our journey by creating a 'PROFILE' table for storing the data of the users of our platform. Create a table profile with $3$ fields $($ USERNAME VARCHAR $(24),$ FULL$\_$NAME VARCHAR $(72),$ HEADLINE VARCHAR $(72)).$

Tables Schema as Below:

PROFILE

columnName dataType

USERNAME VARCHAR $(24)$

FULL$\_$NAME VARCHAR $(72)$

HEADLINE VARCHAR $(72)$