MySQL writes queries and asks for help?

Table T_USER

clipboard.png

T_ROLE

clipboard.png

:

clipboard.png

the following is the table creation and data script

drop table if exists T_USER;
CREATE TABLE T_USER(
USER_ID INT,
USER_NAME VARCHAR(25)
);
INSERT INTO T_USER VALUES(1,"USER_A");
INSERT INTO T_USER VALUES(2,"USER_B");

drop table if exists T_ROLE;
CREATE TABLE T_ROLE(
USER_ID INT,
USER_ROLE VARCHAR(25)
);
INSERT INTO T_ROLE VALUES(1,"ROLE_1");
INSERT INTO T_ROLE VALUES(1,"ROLE_2");

ask for help, how to achieve

Mar.02,2021

SELECT u.USER_ID, r.USER_ROLE, u.USER_NAME FROM T_USER u LEFT JOIN T_ROLE r ON u.USER_ID = r.USER_ID;
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e89e76-f94.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e89e76-f94.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?