Summary DBMS lab programs

Program -1
# cd c:\xampp\mysql\bin


# mysql.exe -u root


MariaDB [(none)]> create database joe;

MariaDB [(none)]> show databases;

MariaDB [(none)]> use joe;
Database changed

MariaDB [joe]> show tables;

Clear Screen : \! cls

, Program -02
Aim:
To create and record handling using SQL queries.
 INSERT statement
 Using SELECT and INSERT together
 DELETE, UPDATE, TRUNCATE statements
 DROP, ALTER statements


Queries:
CREATE:
CREATE TABLE Students( id int primary key, name varchar(50) not null, address text,
phone varchar(10)unique, Sub1 int not null,sub2 int not null, Place VARCHAR(20)
DEFAULT 'Erode');


DESCRIBE:
Desc students;


INSERT
insert into Students( id , name , address , phone ,
Sub1,sub2)values(20241001,'Ajay',thindal,9600670999,85,89);
insert into Students( id , name , address , phone ,
Sub1 ,sub2)values(20241010,'Ram','thindal',9600674569,85,89),
(20241005,'balu','perund
urai',9578587143,92,65);
insert into Students values(20241014,'Ramesh','thindal',9611674569,85,85,'palladam'),
(20241015,'babu','perundurai',9578555143,92,65,'bhavani');


SELECT:
select * from students;


SQL ALTER TABLE Statement
ALTER TABLE students ADD email varchar(10);
ALTER TABLE students MODIFY COLUMN sub1 varchar(5);
ALTER TABLE students CHANGE name fullname VARCHAR(55);