1
2
3
4
5
6
7
8
9
10
mysql>
mysql> CREATE TABLE Employee(
-> id int,
-> first_name VARCHAR(15),
-> last_name VARCHAR(15),
-> start_date DATE,
-> end_date DATE,
-> salary FLOAT(8,2),
-> city VARCHAR(10),
1
2
3
4
5
6
7
8
9
10
mysql>
mysql> insert into Employee(id,first_name, last_name, start_date, end_Date, salary, City, Description)
-> values (1,'Jason', 'Martin', '19960725', '20060725', 1234.56, 'Toronto', 'Programmer');
Query OK, 1 row affected (0.00 sec)
mysql>
mysql> insert into Employee(id,first_name, last_name, start_date, end_Date, salary, City, Description)
-> values(2,'Alison', 'Mathews', '19760321', '19860221', 6661.78, 'Vancouver','Tester');
Query OK, 1 row affected (0.00 sec)
1
2
3
4
5
6
7
8
9
10
mysql>
mysql> select * from job;
+------+------------+
| id | title |
+------+------------+
| 1 | Tester |
| 2 | Accountant |
| 3 | Developer |
| 4 | Coder |
1
2
3
4
5
6
7
8
9
mysql>
mysql> CREATE VIEW myView AS
-> SELECT employee.first_name,job.title
-> FROM employee join job using (id) ;
Query OK, 0 rows affected (0.00 sec)
mysql>
1
2
3
4
5
6
7
8
9
10
mysql>
mysql> select * from myView;
+------------+------------+
| first_name | title |
+------------+------------+
| Jason | Tester |
| Alison | Accountant |
| James | Developer |
| Celia | Coder |
Posts
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.