首先开启mysql的load data功能,解决办法:
vi /etc/my.cnf
添加
local-infile=1
重启数据库
连接数据库的时候,用
mysql --local-infile=1 -uroot -p123456 -P3306 -hlocalhost
然后就可以导入数据了
版本8.0.33
语句1:
-- using default substitutions
select
l_returnflag,
l_linestatus,
sum(l_quantity) as sum_qty,
sum(l_extendedprice) as sum_base_price,
sum(l_extendedprice * (1 - l_discount)) as sum_disc_price,
sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) as sum_charge,
avg(l_quantity) as avg_qty,
avg(l_extendedprice) as avg_price,
avg(l_discount) as avg_disc,
count(*) as count_order
from
lineitem
where
l_shipdate <= '1998-12-01' - interval 90 day
group by
l_returnflag,
l_linestatus
order by
l_returnflag,
l_linestatus;