Question

write sQL statement to create the following table inMy SQL​

Answer 1

Answer:

MySQL Create Table statement with examples

CREATE TABLE 'schemaname'.' tablename'(

column_1 datatype (length) NOT NULL | DEFAULT | UNIQUE,

...,

Primary key,

Foreign key.

) ENGINE=storage_engine;

Answer 2

Answer:

CREATE TABLE data( Record_no  int, name varchar (20), marks int);

Explanation:

• Create keyword creates tables and databases depending upon the keyword followed by it.
• While creating a table you must add attributes with the datatypes.