2. The use of authorized as a result, get the data, create the object query table belongs to the Lord himself permissions granted to others, more complete data rows inserted,
(1) the table owner to build a new and student table the same stu_cs table structure, and then use from other students
On the select privilege on the student table, insert the "computer science" students more than one-time to stu_cs table,

To solve the solving ah

CodePudding user response:

There is the answer?

CodePudding user response:

Table 1. Built at the same time, the student table data into stu_cs in the following way:
The create table stu_cs as select * from schema. The student;

CodePudding user response:

 insert into stu_cs select * from student where conditions 

CodePudding user response:

Description of the literature and art
Like the upstairs, the method of directly insert with respect to OK