Scribd Logo
Upload

Welcome to Scribd!

  • 304 views

    DDL and DML Commands

    Uploaded by

    nitin jaiswal
    This document lists SQL commands divided into four categories: DDL, DML, DCL, and TCL. DDL commands are used for data definition and include CREATE, DROP, ALTER, RENAME, and TRUNCATE. DML commands are used for data manipulation and include SELECT, INSERT, UPDATE, and DELETE. DCL commands are used for data control and include GRANT and REVOKE. TCL commands are used for transactions and include START TRANSACTION, COMMIT, and ROLLBACK. Examples are provided for commands from each category.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd

    DDL and DML Commands

    Uploaded by

    nitin jaiswal
    304 views3 pages
    This document lists SQL commands divided into four categories: DDL, DML, DCL, and TCL. DDL commands are used for data definition and include CREATE, DROP, ALTER, RENAME, and TRUNCATE. DML commands are used for data manipulation and include SELECT, INSERT, UPDATE, and DELETE. DCL commands are used for data control and include GRANT and REVOKE. TCL commands are used for transactions and include START TRANSACTION, COMMIT, and ROLLBACK. Examples are provided for commands from each category.

    Original Description:

    A wide array of ddl and dml commands for refference

    Original Title

    Ddl and Dml Commands

    Copyright

    © © All Rights Reserved

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document lists SQL commands divided into four categories: DDL, DML, DCL, and TCL. DDL commands are used for data definition and include CREATE, DROP, ALTER, RENAME, and TRUNCATE. DML commands are used for data manipulation and include SELECT, INSERT, UPDATE, and DELETE. DCL commands are used for data control and include GRANT and REVOKE. TCL commands are used for transactions and include START TRANSACTION, COMMIT, and ROLLBACK. Examples are provided for commands from each category.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    304 views3 pages

    DDL and DML Commands

    Uploaded by

    nitin jaiswal
    This document lists SQL commands divided into four categories: DDL, DML, DCL, and TCL. DDL commands are used for data definition and include CREATE, DROP, ALTER, RENAME, and TRUNCATE. DML commands are used for data manipulation and include SELECT, INSERT, UPDATE, and DELETE. DCL commands are used for data control and include GRANT and REVOKE. TCL commands are used for transactions and include START TRANSACTION, COMMIT, and ROLLBACK. Examples are provided for commands from each category.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    of 3

    SQL commands list:

    Langua
    Command List
    ge
     CREATE
     DROP
    DDL  ALTER
     RENAME
     TRUNCATE

     SELECT
     INSERT
    DML
     UPDATE
     DELETE

     GRANT
    DCL
     REVOKE

     START TRANSACTION
    TCL  COMMIT
     ROLLBACK

    DDL:
    CREATE DATABASE explainjava;

    CREATE TABLE user (


    id INT(16) PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255) NOT NULL
    );

    DROP DATABASE explainjava;


    DROP TABLE user;
    ALTER TABLE user ADD COLUMN lastname VARCHAR(255)
    NOT NULL;
    RENAME TABLE user TO student;
    TRUNCATE student;
    DML:
    SELECT * FROM student;
    INSERT INTO student (name, lastname) VALUES
    ('Dmytro', 'Shvechikov');
    INSERT INTO student values(&name,&lastname);
    /
    UPDATE student SET name = 'Dima' WHERE lastname =
    'Shvechikov';
    DELETE FROM student WHERE name = 'Dima';

    DCL:
    CREATE USER 'dmytro'@'localhost' IDENTIFIED BY '123';

    GRANT ALL PRIVILEGES ON explainjava.* TO


    'dmytro'@'localhost';
    FLUSH PRIVILEGES;
    REVOKE ALL PRIVILEGES ON explainjava.* FROM
    'dmytro'@'localhost';
    FLUSH PRIVILEGES;

    TCL:
    START TRANSACTION;

    START TRANSACTION;
    INSERT INTO student (name, lastname) VALUES ('Dmytro',
    'Shvechikov');
    COMMIT;

    START TRANSACTION;
    INSERT INTO student (name, lastname) VALUES ('Dmytro',
    'Shvechikov');
    ROLLBACK;

    You might also like