28. Insert and update data using DDL, DML, and DCL statements.

VESRN Technologies

VESRN TECHNOLOGIES

Learn Technology Easily

Programming | ITI | Practical Exercises

MySQL Practical

Insert and update data using DDL, DML and DCL statements.

Create Database

CREATE DATABASE iti_training;
USE iti_training;

Create Table

CREATE TABLE trainee (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(50),
    trade VARCHAR(30),
    marks INT
);

Insert Data

INSERT INTO trainee(name, trade, marks)
VALUES
('Raju','Electrician',78),
('Kumar','Fitter',82),
('Ravi','Welder',69);

Update Data

UPDATE trainee
SET marks=85
WHERE name='Raju';

Result

DDL used to create and modify table structures. DML used to insert, update and delete records. DCL used to control permissions.


I practiced all under my trainer Venugopal Sir.

© 2026 VESRN Technologies | Designed by Venugopal

Popular posts from this blog

Install Windows 7 Operating System - Practical

Image
COPA  Install Windows  -7  Operating System I have learned basically these steps to install windows operating system on Personal Computer(PC) The three basic types of clean installation procedures are as follows: Install on a brand new disk or computer system Erase the disk, format it, and install Install into a new directory I am using  first two methods, be sure my computer can boot from a DVD (most newer computers support booting from a DVD drive). Doing so might require changing the drive boot order in the BIOS or CMOS. The Windows 7 DVD is bootable and should run the Setup program automatically. Clean Install from DVD, Step by Step A typical clean installation (on a blank hard disk) step-by-step procedure is as follows: 1. Insert the Windows 7 DVD into your computer’s DVD-ROM drive, and restart the computer. Windows 7 Setup should start automatically. If Setup does not start automatically, ensure that your computer is configured to boot from the DVD drive. 2. In...
Read more

COPA Bits for Computer Based Test (CBT) by Venugopal Vanjarapu

  Computer Operator and Programming Assistant 1st Semester - Module 1 & 2: Safe Working Practice & Introduction to Computer Components 1 Which is the sequence, in which computer operates?  A Input, output, process  B Input, process, output  C Process, input, output  D Output, process, input  2 Which is the first general purpose programmable electronic computer?  A ENIAC B EDVAC  C EDSAC  D UNIVAC  3 What type of device is computer?   A Electrical device  B Electronic device  C Electro magnetic  D Electro mechanical  4 Who is considered as father of computer?  A Charles Babbage  B John Lickert  C John Mauchy  D M.V Wilkes  5 Who invented Analytical engine?  A Charles Babbage  B John Lickert  C John Mauchy  D M.V Wilkes  6 What is the main electronic component of the first generation computer?  A Integrated circuit  B Microprocess  C Transisto...
Read more

Exp-4 Ms-Dos Commands for COPA Trade - Practical

MSDOS - Commands  Date:  To find the current date, MS-DOS provides DATE command eg:  c:\>date  the current date is : Thu 03/03/2022 Enter the new date : (mm-dd-yy) You can enter new date which will change your current system date Time: To find the current time, MS-DOS provide the TIME commands c:\>time the current time is : 16:11:30.30 Enter the new time: we can enter new time which will change your current system date Cd (change directory):  CD (change directory) is a command used to switch directories in MS-DOS.  cd.. : Goes back one directory. For example, below you can see it goes back from Temp directory to Windows directory.  C:\>windows\Temp>cd.. C:\>windows>cd/ c:\> Suppose you want to go to a specific directory and if you are in root directory you can go using following command. For example we want to switch to Desktop Cd C:\Users\123\Desktop C:\Windows\Temp>cd.. C:\Windows>cd/ C:\>cd users\vesrn\destop C:\>use...
Read more