创建一个图书表

Original 2019-07-05 10:35:59 860
abstract:–创建图书表create table book(no varchar2(64),name varchar2(10),author varchar2(10),category varchar2(10));–插入数据–insert into 表名(各个列明)–values(各列对应的值)insert into book (no,name,author,category)values(‘001’,‘简爱

–创建图书表

create table book

(

no varchar2(64),

name varchar2(10),

author varchar2(10),

category varchar2(10)

);


–插入数据–insert into 表名(各个列明)

–values(各列对应的值)

insert into book (no,name,author,category)values(‘001’,‘简爱’,‘夏洛蒂’,‘文学小说’);

insert into book (no,name,author,category)values(‘002’,‘平凡的世界’,‘路遥’,‘文学小说’);

insert into book (no,name,author,category)values(‘003’,‘物种起源’,‘达尔文’,‘生物学’);

insert into book (no,name,author,category)values(‘004’,‘意林’,‘文学联合会’,‘杂志’);

---------------------

作者:wangmeili1231

来源:CSDN

原文:https://blog.csdn.net/wangmeili1231/article/details/88218535

版权声明:本文为博主原创文章,转载请附上博文链接!


Correcting teacher:天蓬老师Correction time:2019-07-05 14:45:02
Teacher's summary:这种复制粘贴的作业 , 你发布前至少要看一眼吧, 如果是提交给客户的代码, 你还指望能收到尾款吗? --------------------- 作者:wangmeili1231 来源:CSDN 原文:https://blog.csdn.net/wangmeili1231/article/details/88218535 版权声明:本文为博主原创文章,转载请附上博文链接!

Release Notes

Popular Entries