CREATE TABLE query crashes

I want to create a table with 2 number fields that are both unique.. Here is the query I tried:

CREATE TABLE Favorite {
Indexx INTEGER,
Numberr INTEGER,
UNIQUE(Indexx,Numberr)
}

But it crashes.. Why is this?

Answers


CREATE TABLE Favorite (
Indexx INTEGER,
Numberr INTEGER,
UNIQUE(Indexx,Numberr)
)

This should solve your problem. It was { and } brackets that causes the problem.


Use ( and ), not { and } as described in the documentation.


Need Your Help

What is the maximum number of requests for Instagram?

json api jquery jsonp instagram

I was wondering if there is a limitation of the number of images that are tagged that you can return?

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.