sql陳述句-有解無憂

麻煩大佬幫忙決議下sql陳述句，謝謝老鐵們

uj5u.com熱心網友回復：

SELECT stu_nam,CONCAT(stu_no,'_',id),sex,score
FROM class cl
INNER JOIN student_1 st1 ON cl.stu_no=st1.number
UNION
SELECT stu_nam,CONCAT(stu_no,'-',id),sex,score
FROM class cl
INNER JOIN student_2 st2 ON cl.stu_no=st2.number;

uj5u.com熱心網友回復：

參考 1 樓 qq_45948983的回復:

SELECT stu_nam,CONCAT(stu_no,'_',id),sex,score
FROM class cl
INNER JOIN student_1 st1 ON cl.stu_no=st1.number
UNION
SELECT stu_nam,CONCAT(stu_no,'-',id),sex,score
FROM class cl
INNER JOIN student_2 st2 ON cl.stu_no=st2.number;

INSERT INTO class(stu_name,stu_no,class)
VALUES('王君如','101','高一1班');

uj5u.com熱心網友回復：

參考 1 樓 qq_45948983的回復:

SELECT stu_nam,CONCAT(stu_no,'_',id),sex,score
FROM class cl
INNER JOIN student_1 st1 ON cl.stu_no=st1.number
UNION
SELECT stu_nam,CONCAT(stu_no,'-',id),sex,score
FROM class cl
INNER JOIN student_2 st2 ON cl.stu_no=st2.number;

老哥，這是第1提的2種決議嗎

uj5u.com熱心網友回復：

參考 2 樓 qq_45948983的回復:

Quote: 參考 1 樓 qq_45948983的回復:
SELECT stu_nam,CONCAT(stu_no,'_',id),sex,score
FROM class cl
INNER JOIN student_1 st1 ON cl.stu_no=st1.number
UNION
SELECT stu_nam,CONCAT(stu_no,'-',id),sex,score
FROM class cl
INNER JOIN student_2 st2 ON cl.stu_no=st2.number;

INSERT INTO class(stu_name,stu_no,class)
VALUES('王君如','101','高一1班');

DELIMITER $
CREATE PROCEDURE tx(IN s_number INT)
BEGIN
SELECT class_name,number,sex,score
FROM student_1
UNION
SELECT class_name,number,sex,score
FROM student_2;
END $

uj5u.com熱心網友回復：

參考 3 樓 qq_47678112的回復:

Quote: 參考 1 樓 qq_45948983的回復:
SELECT stu_nam,CONCAT(stu_no,'_',id),sex,score
FROM class cl
INNER JOIN student_1 st1 ON cl.stu_no=st1.number
UNION
SELECT stu_nam,CONCAT(stu_no,'-',id),sex,score
FROM class cl
INNER JOIN student_2 st2 ON cl.stu_no=st2.number;

老哥，這是第1提的2種決議嗎

這是這三道題阿

uj5u.com熱心網友回復：

大佬，牛逼

uj5u.com熱心網友回復：

參考 6 樓 qq_47678112的回復:

大佬，牛逼

沒有沒有??我只是剛好學到MySQL 我自己寫的話就是這樣，也不確定可以不可以

uj5u.com熱心網友回復：

參考 4 樓 qq_45948983的回復:

Quote: 參考 2 樓 qq_45948983的回復:
Quote: 參考 1 樓 qq_45948983的回復:
SELECT stu_nam,CONCAT(stu_no,'_',id),sex,score
FROM class cl
INNER JOIN student_1 st1 ON cl.stu_no=st1.number
UNION
SELECT stu_nam,CONCAT(stu_no,'-',id),sex,score
FROM class cl
INNER JOIN student_2 st2 ON cl.stu_no=st2.number;

INSERT INTO class(stu_name,stu_no,class)
VALUES('王君如','101','高一1班');

DELIMITER $
CREATE PROCEDURE tx(IN s_number INT)
BEGIN
SELECT class_name,number,sex,score
FROM student_1
UNION
SELECT class_name,number,sex,score
FROM student_2;
END $

少了個where篩選條件，

不好意思

轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/34510.html

標籤：基礎類

上一篇：一個迷惑問題?_??

下一篇：求大佬救救我