Results 1 to 12 of 12
Thread: SQLite INNER JOIN 3
Hybrid View
-
6th March 2012 15:58 #1Registered User
Join Date: Oct:2008
Location:
Posts: 95
SQLite INNER JOIN 3
,
SQLite3 . SQL-. .
:
, carperson, id- id- .Code:CREATE TABLE [carperson] ( [person_id] INTEGER NOT NULL PRIMARY KEY, [car_id] INTEGER NOT NULL ); CREATE TABLE [cars] ( [car_id] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [brand] VARCHAR(64) NOT NULL, [model] VARCHAR(64) NOT NULL ); CREATE TABLE [person] ( [p_id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, [LastName] VARCHAR(100) NOT NULL, [FirstName] VARCHAR(100) NOT NULL, [Address] VARCHAR(100) NULL, [City] VarCHAR(80) NULL );
INNER ( LEFT) JOIN, .
:
, :Code:LastName model ------------------ Pesho Pasat Mincho Golf 4
?Code:SELECT person.LastName, cars.model FROM person INNER JOIN carperson ON person.p_id=carperson.person_id
, SQLite, 2 .
!
-
6th March 2012 16:02 #2
-
6th March 2012 16:53 #3Registered User
Join Date: Oct:2008
Location: here
Posts: 542
- join- :
, carperson.person_id primary key, .. person , join- inner left.Code:SELECT person.LastName, cars.model FROM person INNER JOIN carperson ON person.p_id=carperson.person_id INNER JOIN cars ON carperson.car_id=cars.car_id
-
6th March 2012 16:56 #4
-
6th March 2012 18:23 #5Registered User
Join Date: Jul:2005
Location: Sofiq
Posts: 2,798
-
6th March 2012 18:32 #6
-
6th March 2012 19:27 #7Registered User
Join Date: Oct:2008
Location:
Posts: 95
-
6th March 2012 20:06 #8Registered User
Join Date: Oct:2008
Location: here
Posts: 542
- ,

primary key , primary key- , . , , primary key.
, primary key, :
primary key- , , [car_id], [person_id] .Code:CREATE TABLE [carperson] ( [car_id] INTEGER NOT NULL, [person_id] INTEGER NOT NULL ); ALTER TABLE [carperson] ADD CONSTRAINT [PK_carperson] PRIMARY KEY ( [car_id] , [person_id] )
...
tutorial e , :
http://www.w3schools.com/sql/default.asp
-
6th March 2012 20:24 #9Registered User
Join Date: Oct:2008
Location:
Posts: 95
.
. .
, . , , . , , 15 .
SQLite, :
The Definitive Guide to SQLite
, .
ALTER TABLE ... CONSTRAINT, , , , , !
-
6th March 2012 23:19 #10
PhrozenCrew, , . .. MSSQL, Oracle, MySQL .. 'Composite Primary Keys'.
SQLite . 'table-constraint'.
( , SQLite):
, ( ) (), / . , . . ( Identity , .)Code:CREATE TABLE something (column1, column2, value, PRIMARY KEY (column1, column2));
PRIMARY KEY
, SQLite .. , . ( JOIN- , .. , .. .. , . SQLtite .. JOIN- .., JOIN- LEFT/RIGHT JOIN-..)Code:CREATE TABLE [carperson] ( [person_id] INTEGER NOT NULL, [car_id] INTEGER NOT NULL );




Reply With Quote

Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in