/SQL/How to set up an auto incrementing id db browser

How to set up an auto incrementing id db browser

Flutter sqlite auto incrementing id primary key

db.execSQL("create table " + TABLE__WORK + " (ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,Name TEXT, Title TEXT, Time TEXT, Date TEXT)");

Source: stackoverflow.com

How to set up an auto incrementing id db browser

Create table tbl_student (
	id_tbl_student integer not null primary key autoincrement,
	col_student_no text not null unique,
	col_name text not null,
	col_sex text null,
	col_status int null,
	col_birthday date null,
	col_id_no text null unique,
	col_mobile integer UNIQUE
	);
create table tbl_course (
	id_tbl_course integer not null primary key autoincrement,
	col_name text not null unique,
	col_hours int null default 64
	);
create table tbl_score (
	id_tbl_score integer not null primary key autoincrement,
	col_score int null check (col_score>=0 and col_score<=100),
	id_tbl_course int not null references tbl_course (id_tbl_course),
	id_tbl_student int not null references tbl_student (id_tbl_student),
	constraint idxu_course_student unique (id_tbl_student, id_tbl_course)
	);
	insert into tbl_student 
values ('SW103101','蔡日','F',1,'1990-5-7','372822199005076102','13987654321'); 
insert into tbl_student 
values ('SW103102','陈琳','M',1,'1990-2-20','420922199002201021','13987654322'); 
insert into tbl_student 
values ('SW103103','程恒坤','F',1,'1989-9-29','320283198909296002','13987654323'); 
insert into tbl_student 
values ('SW103109','鞠迪','M',1,'1990-5-5','342623199005058001','13987654329'); 
insert into tbl_student 
values ('NW102101','王俊峰','M',1,'1989-4-22','362424198904222008','13987654341'); 
insert into tbl_student 
values ('NW102102','王明星','F',1,'1989-4-9','320283198904095017','13987654342'); 
insert into tbl_course values ('C++程序设计','80'); 
insert into tbl_course values ('计算机网络技术','48'); 
insert into tbl_course values ('数据库程序设计','64'); 
insert into tbl_score values (82,1,1); 
insert into tbl_score values (91,1,2); 
insert into tbl_score values (86,1,3); 
insert into tbl_score values (90,1,4); 
insert into tbl_score values (67,1,5); 
insert into tbl_score values (66,2,6); 
insert into tbl_score values (79,2,1); 
insert into tbl_score values (94,2,2); 
insert into tbl_score values (87,3,4); 
insert into tbl_score values (68,3,5); 
select col_name, col_mobile from tbl_student where col_sex like '%f' ;
id_tbl_student of all students whose score is greater than 80.
select id_tbl_student from tbl_score where col_score >79;
name, id_tbl_course, col_score from tbl_student and tbl_score.
select tbl_student.col_name, tbl_score.col_score, tbl_score.id_tbl_student
from tbl_score
INNER JOIN tbl_student on tbl_score.id_tbl_student=tbl_student.id_tbl_student
select tbl_student.col_name, tbl_score.col_score
from tbl_score
INNER JOIN tbl_student on tbl_score.id_tbl_course=1;

How to set up an auto incrementing id db browser

Create table tbl_student (
	id_tbl_student integer not null primary key autoincrement,
	col_student_no text not null unique,
	col_name text not null,
	col_sex text null,
	col_status int null,
	col_birthday date null,
	col_id_no text null unique,
	col_mobile integer UNIQUE
	);
create table tbl_course (
	id_tbl_course integer not null primary key autoincrement,
	col_name text not null unique,
	col_hours int null default 64
	);
create table tbl_score (
	id_tbl_score integer not null primary key autoincrement,
	col_score int null check (col_score>=0 and col_score<=100),
	id_tbl_course int not null references tbl_course (id_tbl_course),
	id_tbl_student int not null references tbl_student (id_tbl_student),
	constraint idxu_course_student unique (id_tbl_student, id_tbl_course)
	);
	insert into tbl_student 
values ('SW103101','蔡日','F',1,'1990-5-7','372822199005076102','13987654321'); 
insert into tbl_student 
values ('SW103102','陈琳','M',1,'1990-2-20','420922199002201021','13987654322'); 
insert into tbl_student 
values ('SW103103','程恒坤','F',1,'1989-9-29','320283198909296002','13987654323'); 
insert into tbl_student 
values ('SW103109','鞠迪','M',1,'1990-5-5','342623199005058001','13987654329'); 
insert into tbl_student 
values ('NW102101','王俊峰','M',1,'1989-4-22','362424198904222008','13987654341'); 
insert into tbl_student 
values ('NW102102','王明星','F',1,'1989-4-9','320283198904095017','13987654342'); 
insert into tbl_course values ('C++程序设计','80'); 
insert into tbl_course values ('计算机网络技术','48'); 
insert into tbl_course values ('数据库程序设计','64'); 
insert into tbl_score values (82,1,1); 
insert into tbl_score values (91,1,2); 
insert into tbl_score values (86,1,3); 
insert into tbl_score values (90,1,4); 
insert into tbl_score values (67,1,5); 
insert into tbl_score values (66,2,6); 
insert into tbl_score values (79,2,1); 
insert into tbl_score values (94,2,2); 
insert into tbl_score values (87,3,4); 
insert into tbl_score values (68,3,5); 
select col_name, col_mobile from tbl_student where col_sex like '%f' ;
id_tbl_student of all students whose score is greater than 80.
select id_tbl_student from tbl_score where col_score >79;
name, id_tbl_course, col_score from tbl_student and tbl_score.
select tbl_student.col_name, tbl_score.col_score, tbl_score.id_tbl_student
from tbl_score
INNER JOIN tbl_student on tbl_score.id_tbl_student=tbl_student.id_tbl_student
select tbl_student.col_name, tbl_score.col_score
from tbl_score
INNER JOIN tbl_student on tbl_score.id_tbl_course=1;

Similar codes

8 votes200 views1 answer
Mysql restore database
SQL
2 votes168 views1 answer
Add 2 hours to current time in MySQL
SQL
8 votes197 views2 answers
Grant all privileges database postgres to user
SQL
0 vote230 views1 answer
MySQL update with subquery
SQL
2 votes179 views1 answer
Mysql increment value by 1 in update
SQL
4 votes197 views1 answer
Is there any command to change postgres password
SQL
2 votes168 views2 answers
Oracle create table if not exists
SQL
0 vote171 views1 answer
Psql select * from table
SQL
0 vote185 views1 answer
Mysql db dump restore max file size issue
SQL
0 vote178 views1 answer
PostgreSQL types and C# types
SQL