BtZ05TnD

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(2, 'kaas', 'knut', 'aas', 'kaas@gmail.com', '123');
19
20
21create table clist (
22list_no integer (11)not null auto_increment,
23u_id INT,
24
25constraint pk_clist primary key (list_no),
26constraint users_clist_fk foreign key (u_id) references users (u_id)
27); 
28
29INSERT INTO clist (u_id)
30VALUES (1), (2);
31
32SELECT u_fname, u_lname FROM users;
33
34SELECT u_fname, u_lname
35FROM users
36INNER JOIN clist ON clist.u_id = users.u_id
37WHERE clist.u_id = 1;