태그>sql구문(총 5개의 글)

'sql구문' 관련 최근글

• SQL 명령어 구문들 (Statements)

  케찹만땅  by 케찹만땅|2010/03/12 11:10

  use testCREATE TABLE userinfo (number int,name char(10),id char(8),password char(10),age int,birthday char(10),sex char(1),daytype char(1),zip char(7),address varchar(50),phone char(15),company va..

  SQL, SQL구문, SQL명령어, SELECT구문, SELECT

• SQL 명령어 뷰(view), 트랜잭션(Transaction) 구문

  케찹만땅  by 케찹만땅|2010/03/10 09:26

  CREATE VIEW title_publishers AS (생성)SELECT t.title, t.price, p.pub_name, p.city, p.stateFROM titles AS t INNER JOIN publishers AS pON t.pub_id = p.pub_idSELECT * FROM title_publishers (사용)ALTER VIEW title_publisher..

  SQL, SQL구문, SQL명령어, 뷰, VIEW

• SQL 명령어 서브 쿼리, 테이블 조인 구문

  케찹만땅  by 케찹만땅|2010/03/09 08:58

  서브 쿼리SELECT title, type, price FROM titles WHERE title_id IN ( SELECT title_id FROM titleauthor WHERE au_id = '998-72-3567')SELECT title_id FROM titles WHERE title_id IN ( SELECT title_id FROM sales)테이블 조인- 내부 조인 (교집합 형..

  SQL, SQL구문, SQL명령어, 쿼리, 서브쿼리

• SQL 명령어 INSERT, UPDATE, DELETE 구문

  케찹만땅  by 케찹만땅|2010/03/08 13:12

  INSERT INTO authors VALUES ('111-22-3333', 'web', 'genie', '051-258-3265', '우리동', '오데구', '', '11111', 0)UPDATE authors SET au_id='111-22-3333', address = '부산시 해운대구', contract = 1 WHERE au_id = '222-22-2222' where절을 생략하면 전체가..

  SQL, INSERT, UPDATE, DELETE, SQL구문

• SQL 명령어 SELECT 구문

  케찹만땅  by 케찹만땅|2010/03/07 15:51

  CREATE DATABASE test ON (filename='c:program filesmicrosoft sql servermssqldatatest.mdf', name='testData') LOG ON (filename='c:program filesmicrosoft sql servermssqldatatest.ldf', name='testLog')CREATE TABLE member ..

  SQL, SQL구문, SQL명령어, SQLSelect, SQLSelect구문