카테고리 없음2011. 12. 11. 01:41

www.softwaredevelopmentdeveloper.com

옥션 아이폰/아이팟 집에서 즐기기 롯데마트 11번가 주민등록번호 도용사실이 있는지 확인해 보세요! CJmall 회원가입 도메인 NO.1-호스팅 NO.1 든든한 웹파트너 가비아 ! 건담 전문몰 건담샵 No.1 중고차 쇼핑몰! SK엔카

아래출처는 http://ad.web2r.net/r.php?c=shop 입니다

******************************************************************************************************

SQL commands to append data to a table

******************************************************************************************************

The insert statement is used to insert or add a row of data into the table.

insert into "tablename" (first_column,...last_column) values (first_value,...last_value); [] = optional

Example:

insert into employee (first, last, age, address, city, state) values ('Luke', 'Duke', 45, '2130 Boars Nest', 'Hazard Co', 'Georgia');

* Note: All strings should be enclosed between single quotes: 'string'

To insert records into a table, enter the key words insert into followed by the table name, followed by an open parenthesis, followed by a list of column names separated by commas, followed by a closing parenthesis, followed by the keyword values, followed by the list of values enclosed in parenthesis. The values that you enter will be held in the rows and they will match up with the column names that you specify. Strings should be enclosed in single quotes, and numbers should not.

In the example above, the column name first will match up with the value 'Luke', and the column name state will match up with the value ' Georgia'.

크리에이티브 커먼즈 라이선스

Share |

Posted by 아이맥스