Home
Flashcards
Preview
MySQL Basics (1)
Home
Get App
Take Quiz
Create
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
Author
dalbabes
ID
95911
Card Set
MySQL Basics (1)
Description
sql terms
Updated
7/26/2012, 4:03:15 PM
Show Answers
Home
Flashcards
Preview