SIMPLE DATABASE QUERYS

                                                SIMPLE DATABASE QUERYS 

    ***CREATE TABLE***
CREATE TABLE RAJA(ENO INT,ENAME VARCHAR(10),SALARY INT);

          ***INSERT***
1) INSERT INTO RAJA VALUES(:ENO,:ENAME,:SALARY);

           ***UPDATE***
2) UPDATE RAJA SET ENAME='KAVIN' WHERE ENO=1;

        ***ALTER***
3) ALTER TABLE RAJA ADD(PLACE VARCHAR(10));
4) ALTER TABLE RAJA RENAME TO ROCK;
5)   ALTER TABLE ROCK DROP COLUMN PLACE;

        ***DELETE***
6) DELETE RAJA WHERE ENO=1;
7) DROP TABLE RAJA;

        ***VIEW***
8) SELECT * FROM RAJA;
9) SELECT ENAME FROM RAJA;
10) SELECT ESAL,ENAME FROM RAJA;

        ***DISTINCT***
11) SELECT DISTINCT(ENAME) FROM RAJA;

        ***TRAUNCATE***
12)TRUNCATE TABLE RAJA;

        ***TEMPORVARY TABLE***
13)CREATE TABLE #RAJA(ENO INT(10),ENAMR VARCHAR(10)):

        ***COPY TABLE***
14)SELECT *  INTO RAJA FROM ROCK;