在数据库php中创建数据表 bj_t * 表结构如下 bj_t * bj_t_id 整型 主键 自动增长 * bjmc varchar(30) unique唯一性约束 班级名称 * xbmc varchar(30) 系部名称 * zymc varchar(30) 专业名称 * create table bj_t * ( * bj_t_id int primary key auto_increment, * bjmc varchar(30) unique comment '班级名称', * xbmc varchar(30) comment '系部名称', * zymc varchar(30) comment '专业名称' * )
时间: 2024-01-17 09:19:07 浏览: 120
回答完毕,数据库php中创建数据表bj_t的表结构如下:
```
create table bj_t (
bj_t_id int primary key auto_increment,
bjmc varchar(30) unique comment '班级名称',
xbmc varchar(30) comment '系部名称',
zymc varchar(30) comment '专业名称'
)
```
其中,`bj_t_id`是整型主键,自动增长;`bjmc`是班级名称,唯一性约束;`xbmc`是系部名称;`zymc`是专业名称。这个表可以用来存储班级的基本信息。
相关问题
sql语句以视图和表XS为基表创建视图V_XS,包含专业名称、班级名称、学号和姓名
以下是创建视图V_XS的SQL语句:
```
CREATE VIEW V_XS AS
SELECT XH, XM, ZYMC, BJMC
FROM XS
JOIN BJ ON XS.BH = BJ.BH
JOIN ZY ON BJ.ZYBH = ZY.ZYBH;
```
其中,XS为表名,包含学号(XH)、姓名(XM)和班级编号(BH);BJ为表名,包含班级编号(BH)和专业编号(ZYBH);ZY为表名,包含专业编号(ZYBH)和专业名称(ZYMC)。通过JOIN操作将这三个表连接起来,然后根据需要选择需要的字段,最终得到包含专业名称、班级名称、学号和姓名的视图V_XS。
TRUNCATE TABLE FDM.fdm_jg_fydkjl; INSERT INTO FDM.fdm_jg_fydkjl ( gh, -- 工号 xm, -- 姓名 dwh, -- 单位号 dwmc, -- 单位名称 fbdkrwsj, -- 发布打卡任务时间 wcdksj, -- 完成打卡时间 dkdd, -- 打卡地点 sfqj, -- 是否请假 sfyxdk, -- 是否有效打卡 xb, -- 性别 lxdh, -- 联系电话 hsqksm, -- 核算情况说明 sfzjh, -- 身份证件号 jzdz -- 居住地址 ) SELECT t2.gh, --工号 t11.xm, --姓名 t11.dwh, -- 单位号 t11.dwmc, -- 单位名称 CAST(NULL AS TIMESTAMP) AS fbdkrwsj, -- 发布打卡任务时间 t2.dksj AS wcdksj, -- 完成打卡时间 NULL AS dkdd, -- 打卡地点 NULL AS sfqj, -- 是否请假 '1' AS sfyxdk, -- 是否有效打卡 CAST(t4.xb AS VARCHAR), --性别 CAST(t7.lxdh AS VARCHAR), -- 联系电话 CAST(t8.hsqksm AS VARCHAR) AS hsqksm, -- 核算情况说明 CAST(t9.sfz AS VARCHAR) AS sfzjh, --身份证件号 CAST(t10.jzdz AS VARCHAR) AS jzdz --居住地址 FROM ( SELECT DISTINCT(t1.user_id) AS gh, t1.answer AS bjmc, t1.answer_time AS dksj FROM ODS.ODS_YDXY_LYYD3_B_GRADUATE_ANSWER t1 WHERE t1.type = 'bjmc' )t2 LEFT JOIN ( SELECT DISTINCT(t1.user_id) AS gh, t1.answer AS xm, t1.answer_time AS dksj FROM ODS.ODS_YDXY_LYYD3_B_GRADUATE_ANSWER t1 WHERE t1.type = 'username' ) t3 ON t2.gh = t3.gh AND t2.dksj = t3.dksj LEFT JOIN ( SELECT DISTINCT(t1.user_id) AS gh, t1.answer AS xb, t1.answer_time AS dksj FROM ODS.ODS_YDXY_LYYD3_B_GRADUATE_ANSWER t1 WHERE t1.type = 'xb' ) t4 ON t2.gh = t4.gh AND t2.dksj = t4.dksj LEFT JOIN ( SELECT DISTINCT(t1.user_id) AS gh, t1.answer AS bjmc, t1.answer_time AS dksj FROM ODS.ODS_YDXY_LYYD3_B_GRADUATE_ANSWER t1 WHERE t1.type = 'bjmc' ) t5 ON t2.gh = t5.gh AND t2.dksj = t5.dksj LEFT JOIN ( SELECT DISTINCT(t1.user_id) AS gh, t1.answer AS bmmc, t1.answer_time AS dksj FROM ODS.ODS_YDXY_LYYD3_B_GRADUATE_ANSWER t1 WHERE t1.type = 'bmmc' ) t6 ON t2.gh = t6.gh AND t2.dksj = t6.dksj LEFT JOIN ( SELECT DISTINCT(t1.user_id) AS gh, CAST(t1.answer AS VARCHAR) AS lxdh, t1.answer_time AS dksj FROM ODS.ODS_YDXY_LYYD3_B_GRADUATE_ANSWER t1 WHERE t1.type = 'bdsjh' ) t7 ON t2.gh = t7.gh AND t2.dksj = t7.dksj LEFT JOIN ( SELECT DISTINCT(t1.user_id) AS gh, t1.answer AS hsqksm, t1.answer_time AS dksj FROM ODS.ODS_YDXY_LYYD3_B_GRADUATE_ANSWER t1 WHERE t1.type = 'radio' ) t8 ON t2.gh = t8.gh AND t2.dksj = t8.dksj LEFT JOIN ( SELECT DISTINCT(t1.user_id) AS gh, t1.answer AS sfz, t1.answer_time AS dksj FROM ODS.ODS_YDXY_LYYD3_B_GRADUATE_ANSWER t1 WHERE t1.type = 'sfz' ) t9 ON t2.gh = t9.gh AND t2.dksj = t9.dksj LEFT JOIN ( SELECT t1.user_id AS gh, t1.answer AS jzdz, t1.answer_time AS dksj FROM ODS.ODS_YDXY_LYYD3_B_GRADUATE_ANSWER t1 WHERE t1.type = 'address' ) t10 ON t2.gh = t10.gh AND t2.dksj = t10.dksj LEFT JOIN FDM.fdm_jg_jbxx t11 ON t2.gh = t11.gh WHERE t2.gh = t11.gh
很抱歉,我不太明白您的问题。我只能告诉您,FDM.fdm_jg_fydkjl是一个用于存储用户工号、姓名、单位号、单位名称、发布打卡任务时间、完成打卡时间、打卡地点、是否请假、是否有效打卡、性别、联系电话、核算情况说明、身份证件号和居住地址等信息的表。