In a table, what's the use, is not can directly add the data in table form?

CodePudding user response:

Building table and initialization data, can be done an action,
CREATE TABLE name new TABLE AS the SELECT field 1, 2, the field 3 FROM the existing TABLE name WHERE...

CodePudding user response:

Although I can't see the figure, see the first floor of the reply, this operation is to the original one or more data is copied to the new table on the table

CodePudding user response:

refer to the second floor with ah response:

although I can't see the figure, but see on the first floor of the reply, this operation is to the original one or more table data is copied to the new list

Got it, thank you, uh huh, already understand, thank you.

CodePudding user response:

reference 1st floor AHUA1001 response:

building table and initialization data, can be done an action,
CREATE TABLE name new TABLE AS the SELECT field 1, 2, the field 3 FROM the existing TABLE name WHERE...

Got it, thank you, thank you,