GXevbgYy

1/*
2    le muni chat
3*/
4
5USE mini_chat;
6DROP TABLE IF EXISTS mc_user;
7DROP TABLE IF EXISTS mc_comment;
8CREATE TABLE IF NOT EXISTS mc_user
9(
10    id_user INT NOT NULL AUTO_INCREMENT,
11    user_name VARCHAR(65) NOT NULL,
12    PRIMARY KEY(id_user)
13);
14
15CREATE TABLE IF NOT EXISTS mc_comment
16(
17    id_comment INT NOT NULL AUTO_INCREMENT,
18    comment_user INT NOT NULL,
19    comment_content  TEXT,
20    PRIMARY KEY(id_comment)
21);
22
23INSERT INTO mc_user(user_name)
24VALUES 
25('noah'),
26('moise');
27
28
29-- la requete qui me permet d'afficher les message posté et leur nom en meme temps --
30SELECT *
31FROM mc_comment 
32INNER JOIN mc_user ON mc_comment.comment_user = mc_user.id_user;
33
34
35INSERT INTO mc_comment(comment_user, comment_content)
36VALUES
37(1, 'bonjour'),
38(2, 'comment ça va');