问题 更新时间2023/10/31 9:48:00
创建一个存储过程,实现在user_tables查询参数给出的表名是否存在,并从存储过程中返回结果。
创建一个名称为sch的数据表,表结构如表1所示,将表2中的数据插入sch表中。字段名数据类型主键外键非空唯一自增idint(10)是否是是否namevarchar(50)否否是否否glassvarchar(50)否否是否否表2:idnameglass1xiaomingglass12xiaojunglass2第一步:创建一个sch表,并向sch表中插入表2中的数据,代码如下:mysql>createtablesch->(->idint(10),->namevarchar(50),->glassvarchar(50)->);QueryOK,0rowsaffected(0.11sec)mysql>insertintoschvalue(1,'xiaoming','glass1'),->(2,'xiaojun','glass2');QueryOK,2rowsaffected(0.05sec)Records:2Duplicates:0Warnings:0mysql>descsch;+-------+-------------+------+-----+---------+-------+|Field|Type|Null|Key|Default|Extra|+-------+-------------+------+-----+---------+-------+|id|int(10)|YES||NULL|||name|varchar(50)|YES||NULL|||glass|varchar(50)|YES||NULL||+-------+-------------+------+-----+---------+-------+3rowsinset(0.00sec)
12345678910111213141516171819202122通过select*fromsch来查看插入表格的内容,SQL语句如下:idnameglass1xiaomingglass12xiaojunglass2第二步:创建一个存储函数用来统计表sch中的记录数。mysql>createfunctioncount_sch()->returnsint->return(selectcount(*)fromsch);QueryOK,0rowsaffected(0.05sec)mysql>selectcount_sch();+-------------+|count_sch()|+-------------+|2|+-------------+1rowinset(0.00sec)1234567891011
12345678910111213141516171819202122通过select*fromsch来查看插入表格的内容,SQL语句如下:idnameglass1xiaomingglass12xiaojunglass2第二步:创建一个存储函数用来统计表sch中的记录数。mysql>createfunctioncount_sch()->returnsint->return(selectcount(*)fromsch);QueryOK,0rowsaffected(0.05sec)mysql>selectcount_sch();+-------------+|count_sch()|+-------------+|2|+-------------+1rowinset(0.00sec)123456789101112345678910111213141516171819202122通过select*fromsch来查看插入表格的内容,SQL语句如下:idnameglass1xiaomingglass12xiaojunglass2第二步:创建一个存储函数用来统计表sch中的记录数。mysql>createfunctioncount_sch()->returnsint->return(selectcount(*)fromsch);QueryOK,0rowsaffected(0.05sec)mysql>selectcount_sch();+-------------+|count_sch()|+-------------+|2|+-------------+1rowinset(0.00sec)1234567891011
出自:国家开放大学 >> 国家开放大学Oracle数据库编程
答案