这是我们数据库课的第二个实验,这些代码是适配SQL Server的代码,而我用的是MySQL,嘎嘎报错,请问如何修改使其适配MySQL正常运行?
(我找过适配修改教程,但可能是我太笨了,还是跑不起来(悲))
SELECT P.*
FROM Customer C,Orders O,Lineitem L,PartSupp PS,Part P
WHERE C.custkey=O.custkey AND O.orderkey=L.orderkey AND
L.suppkey=PS.suppkey AND L.partkey=PS.partkey AND
PS.partkey=P.partkey AND C.name='张三'
INTERSECT
SELECT P.*
FROM Customer C,Orders O,Lineitem L,PartSupp PS,Part P
WHERE C.custkey=O.custkey AND O.orderkey=L.orderkey AND
L.suppkey=PS.suppkey AND L.partkey=PS.partkey AND
PS.partkey= P.partkey AND C.name='李四'
```sql
SELECT P.*
FROM Customer C,Orders O,Lineitem L,PartSupp PS,Part P
WHERE C.custkey= O.custkey AND O.orderkey=L.orderkey AND
L.suppkey=PS.suppkey AND L.partkey=PS.partkey AND
PS.partkey=P.partkey AND C.name='张三'
UNION
SELECT P.*
FROM Customer C,Orders O,Lineitem L,PartSupp PS,Part P
WHERE C.custkey=O.custkey AND O.orderkey=L.orderkey AND
L.suppkey=PS.suppkey AND L.partkey=PS.partkey AND
PS.partkey=P.partkey AND C.name='李四'
SELECT P.*
FROM Customer
C,Orders O,Lineitem L,PartSupp PS,Part P
WHERE C.custkey=O.custkey AND O.orderkey=L.orderkey AND
L.suppkey=PS.suppkey AND L.partkey=PS.partkey AND
PS.partkey= P.partkey AND C.name='张三'
EXCEPT
SELECT P.*
FROM Customer C,Orders O,Lineitem L,PartSupp PS,Part P
WHERE C.custkey=O.custkey AND O.orderkey=L.orderkey AND
L.suppkey=PS.suppkey AND L.partkey=PS.partkey AND
PS.partkey=P.partkey AND C.name='李四';
```