be1DeGrr

1CREATE DATABASE IF NOT EXISTS lemonade;
2
3use lemonade;
4
5CREATE TABLE users (
6    id int PRIMARY KEY NOT NULL auto_increment,
7    name varchar(50) NOT NULL,
8    email varchar(50) NOT NULL
9);
10
11CREATE TABLE memories (
12    id int PRIMARY KEY NOT NULL auto_increment,
13    content varchar(50) NOT NULL, 
14    userID int,
15    FOREIGN KEY (userID) REFERENCES users(id)
16);
17
18INSERT INTO users (name, email) VALUES ("Ruan", "ruan@gmail.com");
19INSERT INTO users (name, email) VALUES ("Pereira", "pereira@gmail.com");
20
21INSERT INTO memories (content, userID) VALUES ("memoria 1", 1);
22INSERT INTO memories (content, userID) VALUES ("memoria 2", 1);
23INSERT INTO memories (content, userID) VALUES ("memoria 3", 2);
24INSERT INTO memories (content, userID) VALUES ("memoria 4", 2);
25	
26select ANY_VALUE(m.id), ANY_VALUE(m.content), m.userID, ANY_VALUE(u.id), ANY_VALUE(u.name), ANY_VALUE(u.email) from memories m inner join users u on m.userID = u.id group by userID;