MySQL CREATE TABLE SELECT Sub-Query Example Selected Rows

MySQL CREATE TABLE SELECT Sub-Query Example Selected Rows

Open your SQL Query Editor then copy & paste the below code to make a backup table holding all employees of IT Department (60) from a MySQL table using CREATE TABLE .. SELECT Sub-Query:

   CREATE TABLE employees_it
   SELECT *
   FROM employees
   WHERE DepartmentID =60

MySQL CREATE TABLE SELECT Sub-Query Example Selected Rows - Execution in SQL Query Editor

 

Related Tutorial Examples

1. Creating Table(s) Using SQL Command MySQL Example
2. Creating Database(s) Using SQL Command MySQL Example
3. How to ADD Column In MySQL Existing Table Example
4. How to Drop Column From MySQL Existing Table Example
5. How to Modify Column From MySQL Existing Table Example
6. Select From Multiple Database In a Query
7. MySQL Database Object Existance Check SQL Example
8. 19 Examples to Learn MySQL
9. MySQL Sub Query: INSERT INTO SELECT *... Example
10. 28 Basic Tutorials to Learn Oracle