Question

Query of the creating table sql

Answer 1

Answer:

a. Set appropriate data types for the fields.

b. Write a query to display all the records.

c. Write the query to update the Author of the book named KORTH to Arvind.

d. Write a query to delete record where the price is Rs. 550hddh

Explanation:

dhdhdhdhhshshdhgdqoieru i am king

Answer 2

Answer:

Use:

CREATE TABLE table_name( column_name1 data_type1, column_name2 data_type2, column_name3 data_type3, column_name4 data_type4);

Explanation:

• CREATE command allows you to create a Table/Database.

Example:

CREATE TABLE student_data ( name varcahr(20), class int, Roll int, marks int);