Temporary notes on MySQL

chnhbhndchngn 2022-02-13 08:24:57 阅读数:936

temporary notes mysql

Query two conditions

SELECT
*
FROM
investmenttab
WHERE
( investment, investdays ) =
( SELECT
investment,
investdays
FROM
investmenttab
WHERE
investmentlistid = 'ph-000000001' );

Store the query results directly in the new table ( New table not created )

create table temp as
select ename from employee_new
;

copyright:author[chnhbhndchngn],Please bring the original link to reprint, thank you. https://en.javamana.com/2022/02/202202130824550848.html