a62vYRqm

1drop database classlist;
2create database if not exists classlist; 
3use classlist;
4
5create table users(
6u_id INT,
7u_username varchar (30),
8u_fname varchar (30),
9u_lname varchar (30),
10u_email varchar (30),
11u_password varchar (30),
12
13primary key (u_id)
14);
15
16INSERT INTO users
17VALUES (1, 'phpham', 'phuong', 'pham', 'pungen@hotmail.com', '123');
18
19
20create table clist (
21list_no integer (11)not null auto_increment,
22u_id INT,
23
24constraint pk_clist primary key (list_no),
25constraint users_clist_fk foreign key (u_id) references users (u_id)
26); 
27
28INSERT INTO clist (u_id)
29VALUES ('1');
30
31SELECT u_fname, u_lname FROM users;
32
33SELECT u_fname, u_lname
34FROM users
35INNER JOIN clist ON clist.u_id = users.u_id
36WHERE clist.u_id = 1;