• Home
  • Temporary notes on MySQL

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

《 "Error 1366 (HY000): incorrect string value: '\ XE5 \ XBC \ xa0 \ xe4 \ xb8 \ x89' for column 'name“