Sqlserver 语句转成MySql语句

2009-11-26 10:09:58 155 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

SQL server在Select语句中Join一个表值函数进行关联，转成Mysql去实现方式。记一次平台升级兼容SQL server和MySQL开发解决方案。某程序功能执行这样一个sql获取数据，原SQL server语句： SELECT * FROM BidFile AS A INNER JOIN dbo.fun_获取指定流程的合格单位(3, '9') AS B ON A.BidFileId = B.BidFileId 该sql语句为简单截取关键一段，在这局sql中select一张表，该表关联join了一个表值函数，具体是什么不重要，只需要知道表值函数的作用就是返回一个列表集合用于外层. 阅读详情

要转成一样的效果，用powerdesigner怎么转？能转吗？

create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)
;
create table authors (
authorID int identity,
firstName varchar (20) NOT NULL,
lastName varchar (30) NOT NULL,
constraint pk_authors primary key (authorID)
)
;
create table titles (
isbn varchar (20) NOT NULL,
title varchar (100) NOT NULL,
editionNumber int NOT NULL,
copyright varchar (4) NOT NULL,
publisherID int NOT NULL,
imageFile varchar (20) NOT NULL,
price float NOT NULL,
constraint fk_titles foreign key (publisherID)
references publishers (publisherID),
constraint pk_titles primary key (isbn)
)
;
create table authorISBN (
authorID int NOT NULL,
isbn varchar (20) NOT NULL,
constraint fk_authorISBN_1 foreign key (authorID)
references authors (authorID),
constraint fk_authorISBN_2 foreign key (isbn)
references titles (isbn)
)
;
create table bookusers
(
userId numeric identity,
account varchar(20) not null,
password varchar(20) not null,
name varchar(20) not null,
createTime datetime not null,
constraint PK_BOOKUSERS primary key (userId)
);

...全文