关于#sql#的问题,请各位专家解答!

求看看哪里有错

img

Ecreate table goods
shop_acc archar(30)
goods name varchar(30】
goods_tyeyarchar(30】
goods_prices double check(soods_prices>=0.0),
goods_restint check(goode.teat>=0),
goods_selled int check(goode.sel1gd>=0),
primary key(skop-acc,goods_name),
foreign key(sho.acc) references shop(ghep-39S
0%

```

check不能之间定义字段类型,楼上这个用gpt完成在乱写,把检查条件放在外键定义最后

check(goods_prices >= 0.0),
  check(goods_rest >= 0),
  check(goods_selled >= 0)