Relational Database Development 152-156 SQL: Updating Data Notes Activity Text References Pages 162 Page 163 Pages 163 165 – Pages 167 168 – Pages 172 174 – Pages 166 167 – Page 168 169 – Page Pages 171 172 – Page Page Page Page Page 175 Create table tblFebTrips Copying a Table’s Structure with the same structure as MySQL makes it easy to create a new table based on tblTrips another table’s structure Display the structure of the Create Table newTableName Like currTableName new table The new table will have the same set of fields and field definitions as the current table The new table will NOT have data Other versions of SQL do not have the command. In Like those versions you have to create the new table manually with the same fields as the original table.
Relational Database Development 152-156 SQL: Updating Data Notes Activity Text References Pages 162 Page 163 Pages 163 – 165 Pages 167 – 168 Pages 172 – 174 Pages 166 – 167 Page 168 – 169 Page Pages 171 – 172 Page Page Page Page Page 175 Copying a Table’s Structure MySQL makes it easy to create a new table based on another table’s structure Create Table newTableName Like currTableName The new table will have the same set of fields and field definitions as the current table The new table will NOT have data Other versions of SQL do not have the Like command. In those versions you have to create the new table manually with the same fields as the original table. Create table tblFebTrips with the same structure as tblTrips Display the structure of the new table
5%20-%20Updating%20Data%20&%20Structure.docx