Reset Database
|
Return to Main
Tables
member
id
numeric
name
text
address
text
city
text
state
character
zip
text
age
numeric
cars
mem_id
numeric
make
text
model
text
year
numeric
Query
Enter a SQL statement below and press Execute:
select * from member
Or try one of these SQL commands:
select * from member
select * from cars
select id, name, address from member where state = 'CA'
select * from member where name like 'B%'
select * from cars where year >= 1998
select mem_id, id, name, make, model, year from cars join member on id = mem_id
insert into cars values ( 1001, 'Infiniti', 'Q45', 1997 )