How to convert postgres sql to mysql query

Question

I have the query in postgres sql like below:

-- 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;

And now I need to convert it to mysql query. But I am confused. How can I do that tutorials? Thanks

I assume you mean "MySQL" and not "SQL Server" by "mysql server". I've modified the question and title to be unambiguous. — Gordon Linoff
– Gordon Linoff, Commented Nov 7, 2015 at 17:58

Gordon Linoff · Accepted Answer · 2015-11-07 17:55:52Z

1

I'm not quite sure how you want to handle the ownership constructs in MySQL, but the table definitions can be readily converted:

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 is the SQL Fiddle.

The SQL Server version isn't much different:

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
);

answered Nov 7, 2015 at 17:55

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mary Over a year ago

Thank u very much Mr. Gordon. That is what I looking for. :-D

Collectives™ on Stack Overflow

How to convert postgres sql to mysql query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related