sqlite to mysql
I'm trying to migrate from sqlite to mysql and am having trouble with this table creation. I am wondering how other people have got around the problem of creating unique or primary keys on tables.
CREATE TABLE wiki (
name text,
version integer,
time integer,
author text,
ipnr text,
text text,
comment text,
readonly integer,
UNIQUE (name,version)
);
Subject
Views
Written By
Posted
sqlite to mysql
13939
February 11, 2011 03:13PM
6886
February 17, 2011 12:50AM
3508
February 18, 2011 01:43PM
3348
March 28, 2011 12:40AM
3074
April 01, 2011 12:35AM
4242
May 16, 2011 05:34AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.