Tutorial 9 Тopic: MYSQL Insert Records • Write a SQL statement to insert a record with your own value into the table countries against each columns. Here in the following is the structure of the table...


Can you help me with these SQL queries?



Tutorial 9<br>Тopic:<br>MYSQL Insert Records<br>• Write a SQL statement to insert a record with your<br>own value into the table countries against each<br>columns.<br>Here in the following is the structure of the table<br>countries.<br>| Field<br>| Туре<br>| Null | Key | Default | Extra |<br>| YES<br>| YES<br>| decimal(10,0) | YES<br>| varchar(2)<br>| COUNTRY_ID<br>| COUNTRY_NAME | varchar(40)<br>| REGION_ID<br>| NULL<br>NULL<br>| NULL<br>|<br>• Write a SQL statement to insert one row into the<br>table countries against the column country_id and<br>country_name.<br>• Write a SQL statement to create duplicate of<br>countries table named country_new with<br>all<br>structure and data.<br>

Extracted text: Tutorial 9 Тopic: MYSQL Insert Records • Write a SQL statement to insert a record with your own value into the table countries against each columns. Here in the following is the structure of the table countries. | Field | Туре | Null | Key | Default | Extra | | YES | YES | decimal(10,0) | YES | varchar(2) | COUNTRY_ID | COUNTRY_NAME | varchar(40) | REGION_ID | NULL NULL | NULL | • Write a SQL statement to insert one row into the table countries against the column country_id and country_name. • Write a SQL statement to create duplicate of countries table named country_new with all structure and data.

Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here