Entry

Database: Language: SQL: Table: Operation: Insert: How to insert data in a table?

Mar 20th, 2005 02:41
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- 20 March 2005 - 04:37 pm ----------------------

Database: Language: SQL: Table: Operation: Insert: How to insert data 
in a table?

---

Use the SQL command:

 INSERT INTO <your table name>

---
---

General format:

-----------------------------------------------
INSERT INTO
 <mytable>
(
 <columnname1>,
 <columnname2>,
 <columnname3>,
 ...
 <columnnameN>
)
VALUES
(
 <value1>,
 <value2>,
 <value3>,
 ...
 <valueN>
)
;
-----------------------------------------------

---
---

e.g.

-----------------------------------------------
INSERT INTO
 tableAddressS
(
 columnFirstNameS,
 columnLastNameS,
 columnStreetS,
 columnCityS,
 columnZipCodeS,
 columnCountryS,
 columnTelephoneS,
 columnFaxS,
 columnRemarkS
)
VALUES
(
 'Knud',
 'van Eeden',
 'mystreet',
 'mycity',
 'myzipcode',
 'mycountry',
 'mytelephone',
 'myfax',
 ''
)
;
-----------------------------------------------

---
---

Internet: see also:

---

Database: Language: SQL: Overview: Can you give an overview of links 
about SQL?
http://www.faqts.com/knowledge_base/view.phtml/aid/32811/fid/54

----------------------------------------------------------------------