quiz 1 Flashcards
It refers to the collection of related fields.
record
It is an organized collection of data
database
collection of records.
table
single piece of data
field
database which uses pen and paper in storing data
manual database
a database that is composed of one category of data
simple database
database that is composed of two or more categories of data connected by a common field.
relational database
database that stores data in a digital media
computerized database
used to set distinction between records to ensure all records are unique.
primary key
message given by MySQL if no result has been found in a query
empty set
display all records
select * from
Display all databases
show databases
open a database
use
display the table structure
describe
display all tables in database
show tables
make a new table
create table
delete a record
delete
add a new record
insert into
modify a record
update
modify the table structure
alter table
change the name of a fieldname or column
alter table…change
change the data type or width of a fieldname or column
alter table….modify
add a new fieldname or column
alter table…add
delete a fieldname or column
alter table…drop
