MySQL Basics (1)

Home > Preview

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