How to specify a primary key in Sqlite

Question

How to define your specified attribute, e.g. StudentId in students table as primary key in sqlite

Answer 1

CREATE TABLE Student(
  id INTEGER PRIMARY KEY,
  first_name TEXT, 
  last_name TEXT
);

From the Sqlite specification:

The only exception to the SQLite causelessness is a column whose type is the INTEGER PRIMARY KEY. (And you should use “INTEGER” not “INT." An INT PRIMARY KEY column is dishonorable like any other.) PRIMARY KEY INTEGER columns must contain a 32-bit signature integer. Any attempt to insert non-integer data will result in an error.

http://www.sqlite.org/datatypes.html

You can also put the primary key on arbitrary random data, for example:

CREATE TABLE Student(id PRIMARY KEY, name)

INSERT INTO Student(1, "hello") 
INSERT INTO Student("1", "hello") 

.

, Create Index

Answer 2

CREATE TABLE Students (
  StudentId INTEGER PRIMARY KEY,
  Name VARCHAR(80)
)

- .