Inayotaka kwa SQL INSERT INTO

Mwongozo wa INSERT INTO

Mwongozo wa INSERT INTO inatumiwa kuingia mawingu mpya katika tabia.

Muundo

INSERT INTO Jina la Tovuti VALUES (value 1, value 2,...)

Wenyeji wa data hatau ingependekeza kolumu

INSERT INTO table_name (kolumu 1, kolumu 2,...) VALUES (value 1, value 2,...)

Ingeza mawingu mpya

"Persons" Tovuti:

LastName FirstName Adress City
Carter Thomas Changan Street Beijing

Mwongozo wa SQL:

INSERT INTO Persons VALUES ('Gates', 'Bill', 'Xuanwumen 10', 'Beijing')

Matokeo:

LastName FirstName Adress City
Carter Thomas Changan Street Beijing
Gates Bill Xuanwumen 10 Beijing

Ingeza data katika kolumu zilizopangwa

"Persons" Tovuti:

LastName FirstName Adress City
Carter Thomas Changan Street Beijing
Gates Bill Xuanwumen 10 Beijing

Mwongozo wa SQL:

INSERT INTO Persons (LastName, Adress) VALUES ('Wilson', 'Champs-Elysees')

Matokeo:

LastName FirstName Adress City
Carter Thomas Changan Street Beijing
Gates Bill Xuanwumen 10 Beijing
Wilson 　 Champs-Elysees