MySQL Forums
Forum List  »  SQLite

sqlite to mysql
Posted by: dallas smith
Date: February 11, 2011 03:13PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
sqlite to mysql
13593
February 11, 2011 03:13PM
6608
February 17, 2011 12:50AM
3317
February 18, 2011 01:43PM
3188
March 28, 2011 12:40AM
2890
April 01, 2011 12:35AM
4017
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.