SQL Statements

  1. INSERT STATEMENT

    INSERT INTO EMPLOYEEES
    VALUES ('Smith','John','1980-06-10','Los Angles',16,45000)
  2. SELECT STATEMNET

    SELECT * FROM EMPLOYEES
    WHERE FIRST_NAME='PERRY'
  3. UPDATE STATEME

    UPDATE EMPLOYEES
    SET SALARY=999999
    WHERE FIRST_NAME='PERRY'
  4. DELETE STATEMENT

    DELETE FROM EMPLOYEES
    WHERE FIRST_NAME='BRUCE'
posted @ 2007-08-17 10:29  许晓光  阅读(258)  评论(0编辑  收藏  举报