MySQL Basics (1)
Home > Preview
The flashcards below were created by user
on FreezingBlue Flashcards.
Make a new database
create database whatever
get the current time and date
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?
- 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
delete from tablename where
What would you like to do?
Home > Flashcards > Print Preview