Question

我在Pg11安装了Mimic3数据库,并试图利用该代码查询: 步骤解决办法 1. 导言

SELECT ie.subject_id, ie.hadm_id, ie.icustay_id,
    ie.intime, ie.outtime
FROM `physionet-data.mimiciii_clinical.icustays` ie;

但我照此错误。

ERROR:  syntax error at or near "`"
LINE 3: FROM `physionet-data.mimiciii_clinical.icustays` ie
             ^
, Time: 0.004000s

如果我删除这两条背书,我就会发出警告。

ERROR:  syntax error at or near "-"
LINE 3: FROM physionet-data.mimiciii_clinical.icustays ie
                      ^
, Time: 0.002000s

如果我把“改为”的话,就会发现以下错误:

ERROR:  relation "physionet-data.mimiciii_clinical.icustays" does not exist
LINE 3: FROM "physionet-data.mimiciii_clinical.icustays" ie
             ^
, Time: 0.002000s

有些人希望能告诉我什么是错的。谢谢!

Answer 1

邮政局不使用背书,以引用表格名称,使用双字母,在姓名中不作引用,因此你可能希望:

SELECT ie.subject_id, ie.hadm_id, ie.icustay_id,
    ie.intime, ie.outtime
FROM "physionet-data.mimiciii_clinical.icustays" ie;

Answer 2

well, write the solve way first,try to modify the physionet-data.mimiciii_clinical.icustays into mimiciii_clinical.icustays, be attention,no . i meet the same question in install MIMICIV_derived part, so i search the same ask from chinese forum,then i find here,maybe answer is too late,but i hope it can help the guys meet this problem too. i think this problem is because the MIMIC s administrator use the mysql,and this file is not the offical version too,something maybe include cloud part such as physionet-data. ? i learn sql and database short time. Maybe forget to exchange it ?Because you can cheak the code run normally in other file, you will find all the process can be done in the local. First time write the answer in english, so if something read weird, sorry lol

友情链接