Scribd
Upload
5 views1 page

SQL Table Creation and Data Insertion

The document contains SQL commands to create a table named 'entries' with fields for name, address, email, floor, and resources. It includes several insert statements to populate the table with data related to individuals and their associated resources. Finally, it includes a select statement to retrieve all records from the 'entries' table.

Uploaded by

Vikram Sethuraj
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
5 views1 page

SQL Table Creation and Data Insertion

The document contains SQL commands to create a table named 'entries' with fields for name, address, email, floor, and resources. It includes several insert statements to populate the table with data related to individuals and their associated resources. Finally, it includes a select statement to retrieve all records from the 'entries' table.

Uploaded by

Vikram Sethuraj
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

create table entries (

name varchar(20),
address varchar(20),
email varchar(20),
floor int,
resources varchar(10));

insert into entries


values ('A','Bangalore','A@[Link]',1,'CPU'),
('A','Bangalore','A1@[Link]',1,'CPU'),
('A','Bangalore','A2@[Link]',2,'DESKTOP')
,('B','Bangalore','B@[Link]',2,'DESKTOP'),
('B','Bangalore','B1@[Link]',2,'DESKTOP'),
('B','Bangalore','B2@[Link]',1,'MONITOR');

select * from entries;

You might also like