Results 1 to 12 of 12

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Oct:2008
    Location:
    Posts: 95

    SQLite INNER JOIN 3

    ,

    SQLite3 . SQL-. .
    :

    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
    );
    , carperson, id- id- .
    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 .

    !

  2. #2
    Registered User PepiX's Avatar
    Join Date: Sep:2004
    Location:
    Posts: 13,376
    SQLite, , ..

    :

    FROM (T1 INNER JOIN T2 ON T1.F1 = T2.F21) INNER JOIN T3 ON T2.F22 = T3.F3



    FROM (person INNER JOIN carperson ON person.p_id = carperson.person_id) INNER JOIN cars ON carperson.car_id = cars.car_id
    ███████ ( Ilko)
    ███████-, ? ( )
    ███████

  3. #3
    Registered User
    Join Date: Oct:2008
    Location: here
    Posts: 542
    - join- :

    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
    , carperson.person_id primary key, .. person , join- inner left.

  4. #4
    Registered User PepiX's Avatar
    Join Date: Sep:2004
    Location:
    Posts: 13,376
    Quote Originally Posted by StoyoDobria View Post
    , carperson.person_id primary key, .. person , join- inner left.
    .. carperson . .
    ███████ ( Ilko)
    ███████-, ? ( )
    ███████

  5. #5
    Registered User
    Join Date: Jul:2005
    Location: Sofiq
    Posts: 2,798
    Quote Originally Posted by PepiX View Post
    .. carperson . .
    PRIMARY , 2 , 2 . 1 1 . , car_id UNIQUE.

  6. #6
    Registered User PepiX's Avatar
    Join Date: Sep:2004
    Location:
    Posts: 13,376
    Quote Originally Posted by _ShadoW_ View Post
    PRIMARY
    ███████ ( Ilko)
    ███████-, ? ( )
    ███████

  7. #7
    Registered User
    Join Date: Oct:2008
    Location:
    Posts: 95
    !

    Quote Originally Posted by PepiX View Post
    FROM (person INNER JOIN carperson ON person.p_id = carperson.person_id) INNER JOIN cars ON carperson.car_id = cars.car_id
    PepiX, , . .. StoyoDobria.

    , , MS Access, 2 PRIMARY KEY , . , UNIQUE. , SQLite , PRIMARY KEY . , :
    - 1, 2 ( Lada Golf 3)
    - ( Pasat-)

    :
    Code:
    CREATE TABLE [carperson] (
    [car_id] INTEGER  NOT NULL PRIMARY KEY,
    [person_id] INTEGER  NOT NULL
    );
    !

  8. #8
    Registered User
    Join Date: Oct:2008
    Location: here
    Posts: 542
    - ,
    primary key , primary key- , . , , primary key.

    , primary key, :
    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] 
    )
    primary key- , , [car_id], [person_id] .
    ...

    tutorial e , :
    http://www.w3schools.com/sql/default.asp

  9. #9
    Registered User
    Join Date: Oct:2008
    Location:
    Posts: 95
    .
    . .
    , . , , . , , 15 .

    SQLite, :
    The Definitive Guide to SQLite

    , .

    ALTER TABLE ... CONSTRAINT, , , , , !
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	51rajz.jpg‎ 
Views:	353 
Size:	17.4 KB 
ID:	49820  

  10. #10
    Registered User PepiX's Avatar
    Join Date: Sep:2004
    Location:
    Posts: 13,376
    PhrozenCrew, , . .. MSSQL, Oracle, MySQL .. 'Composite Primary Keys'.

    SQLite . 'table-constraint'.

    ( , SQLite):

    Code:
    CREATE TABLE something (column1, column2, value, PRIMARY KEY (column1, column2));
    , ( ) (), / . , . . ( Identity , .)

    PRIMARY KEY

    Code:
    CREATE TABLE [carperson] (
    [person_id] INTEGER  NOT NULL,
    [car_id] INTEGER  NOT NULL
    );
    , SQLite .. , . ( JOIN- , .. , .. .. , . SQLtite .. JOIN- .., JOIN- LEFT/RIGHT JOIN-..)
    ███████ ( Ilko)
    ███████-, ? ( )
    ███████

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |