The flashcards below were created by user
dalbabes
on FreezingBlue Flashcards.
-
Make a new database
create database whatever
-
get the current time and date
select now()
-
delete a table bob
drop table bob;
-
add a field to an existing table
alter table bob add fieldname fieldtype
-
remove a field from a table
alter table bob drop fieldname
-
add a field after a certain field or at the start of all fields
- alter table officeproducts add description text after product_name;
- alter table officeproducts add description text first
-
Alter the data type of a field
alter table bob modify description varchar(255)
-
rename a table
alter table officeproducts rename as office_prod;
-
keyword to look for fields that contain certain things. What wild card character would you use?
- Like(%bob%);
- select first_name,birthday from friends where first_name like ("Des%");
-
If you want to change data in a field, what would you use?
- update table set wher
- update/set/where
-
delete data
delete from tablename where
|
|