Re: Postgresql to mysql

[mona hazarika]

Hi everyone,

I am converting a postgres sql file into a mysql sql file.I have some create table queries as well as sequences for most of the tables.I know that we have to assign auto_increment to some column if a sequence is created for that column.But wat if a sequence is being created for the whole table ?Wat wil be the equivalent for the sequnce part in mysql?

I have a create table syntax as follws:

CREATE TABLE calendar_events (
id numeric NOT NULL,
syear numeric(4,0),
school_id numeric,
school_date date,
title character varying(50),
description character varying(500)
);

CREATE SEQUENCE calendar_events_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;

SELECT pg_catalog.setval('calendar_events_seq', 25, true);

ALTER TABLE ONLY calendar_events
ADD CONSTRAINT calendar_events_pkey PRIMARY KEY (id);


Now i have converted the create table query into mysql syntax but i dont know wat to do with the sequence part for the whole table.Should i assume that the sequence defined is for the "id" in the table calendar_events and so assign auto_increment for that field?

Will this equivalent for the above table be correct?

CREATE TABLE IF NOT EXISTS `calendar_events` (
`id` double NOT NULL auto_increment,
`syear` double default '0',
`school_id` double default '0',
`school_date` date default NULL,
`title` varchar(50) default '',
`description` longtext,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;