Skip to content

Commit 1060209

Browse files
committed
update
1 parent bb0a5ab commit 1060209

File tree

1 file changed

+13
-8
lines changed

1 file changed

+13
-8
lines changed

README.md

Lines changed: 13 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -163,14 +163,7 @@ select employee_id, first_name from employee;
163163
```sql
164164
select employee_id, first_name from employee where age > 25;
165165
```
166-
#### Duplicate a Table Schema
167-
```sql
168-
create table table_name like old_table;
169-
````
170-
#### Duplicate a Table
171-
````sql
172-
create table table_name select * from old_table;
173-
````
166+
174167
## Views
175168

176169
#### Create a view
@@ -306,3 +299,15 @@ release savepoint sv_pt;
306299
```sql
307300
commit;
308301
```
302+
303+
## Cloning
304+
305+
#### Duplicate a Table Schema
306+
```sql
307+
create table emp_dup like employee;
308+
```
309+
310+
#### Duplicate a Table
311+
```sql
312+
create table emp_dup select * from employee;
313+
```

0 commit comments

Comments
 (0)