mysql - 如何将 postgresql 查询转换为 mysql 查询

Question

我在 postgres sql 中有如下查询:

-- Table: album
   CREATE TABLE album
   (
    id bigserial NOT NULL,
    artist character varying(255),
    title character varying(255),
    CONSTRAINT pk_album PRIMARY KEY (id )
   )
   WITH (
   OIDS=FALSE
   );
   ALTER TABLE album
   OWNER TO developer;

  -- Table: track
     CREATE TABLE track
     (
     track_id bigserial NOT NULL,
     track_title character varying(255),
     album_id bigint,
     CONSTRAINT track_pkey PRIMARY KEY (track_id ),
    CONSTRAINT fk_track_album FOREIGN KEY (album_id)
     REFERENCES album (id) MATCH SIMPLE
     ON UPDATE CASCADE ON DELETE CASCADE
)
  WITH (
 OIDS=FALSE
   );
     ALTER TABLE track
    OWNER TO developer;

现在我需要将其转换为 mysql 查询。但我很困惑。我怎样才能做那个教程？谢谢

Answer 1

我不太确定你想如何处理 MySQL 中的所有权结构，但表定义可以很容易地转换:

CREATE TABLE album (
    id bigint NOT NULL auto_increment,
    artist varchar(255),
    title varchar(255),
    CONSTRAINT pk_album PRIMARY KEY (id)
);

CREATE TABLE track (
    track_id bigint NOT NULL auto_increment,
    track_title varchar(255),
    album_id bigint,
    CONSTRAINT track_pkey PRIMARY KEY (track_id ),
    CONSTRAINT fk_track_album FOREIGN KEY (album_id)
    REFERENCES album (id) ON UPDATE CASCADE ON DELETE CASCADE
);

Here是 SQL fiddle 。

SQL Server版本差别不大:

CREATE TABLE album (
    id bigint NOT NULL identity,
    artist varchar(255),
    title varchar(255),
    CONSTRAINT pk_album PRIMARY KEY (id)
);

CREATE TABLE track (
    track_id bigint NOT NULL identity,
    track_title varchar(255),
    album_id bigint,
    CONSTRAINT track_pkey PRIMARY KEY (track_id ),
    CONSTRAINT fk_track_album FOREIGN KEY (album_id)
    REFERENCES album (id) ON UPDATE CASCADE ON DELETE CASCADE
);