MySQL Alter Table - Exercises, Practice, Solution
MySQL Alter Table [15 exercises with solution]
1. Write a SQL statement to rename the table countries to country_new.
2. Write a SQL statement to add a column region_id to the table locations.
3. Write a SQL statement to add a columns ID as the first column of the table locations.
4. Write a SQL statement to add a column region_id after state_province to the table locations.
5. Write a SQL statement change the data type of the column country_id to integer in the table locations.
6. Write a SQL statement to drop the column city from the table locations.
7. Write a SQL statement to change the name of the column state_province to state, keeping the data type and size same.
8. Write a SQL statement to add a primary key for the columns location_id in the locations table.
Here is the sample table employees.
Sample table: employees
9. Write a SQL statement to add a primary key for a combination of columns location_id and country_id.
10. Write a SQL statement to drop the existing primary from the table locations on a combination of columns location_id and country_id.
11. Write a SQL statement to add a foreign key on job_id column of job_history table referencing to the primary key job_id of jobs table.
12. Write a SQL statement to add a foreign key constraint named fk_job_id on job_id column of job_history table referencing to the primary key job_id of jobs table.
13. Write a SQL statement to drop the existing foreign key fk_job_id from job_history table on job_id column which is referencing to the job_id of jobs table.
14. Write a SQL statement to add an index named indx_job_id on job_id column in the table job_history.
15. Write a SQL statement to drop the index indx_job_id from job_history table.
More to Come !
Do not submit any solution of the above exercises at here, if you want to contribute go to the appropriate exercise page.
- New Content published on w3resource:
- HTML-CSS Practical: Exercises, Practice, Solution
- Java Regular Expression: Exercises, Practice, Solution
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework
- Angular - JavaScript Framework
- Vue - JavaScript Framework
- Jest - JavaScript Testing Framework