Summer@2006[2]

The one you love
               ___eagles
I know you need a friend, someone you can talk to
Who will understand what you're going through
When it comes to love there is no easy answer
Only you can say what you're gonna do
I heard you on the phone
You took his number
said you were alone
But you'd call him soon
Isn't he the guy,
the guy who left you crying
Isn't he the one who make you blue
When you remember those nights in his arms
You know you got to make up your mind
Are you gonna stay with the one who loves you
Or are you going back to the one you love
Someone's going to cry When they know they're lost you
Someone's gonna thank the stars above
What are you gonna say when he comes over?
There's no easy way to see this through
All the broken dreams all the disappointment
Oh,Girl what you gonna do
Your heart keeps saying it's just not fair
But still you gotta make up your mind

我很喜欢这首歌,贴在这里.这个暑假很不错,因为有世界杯...因为有一份感受像世界杯一样的袭来也像世界杯一样的淡去...但是依然在心里,当我想起,我就会微笑.只有我知道,我不再想说什么了...
 

-- 更改结束符 DELIMITER // -- 创建存储过程 DROP PROCEDURE IF EXISTS ImportOlympicData; CREATE PROCEDURE ImportOlympicData(IN base_path VARCHAR(255)) BEGIN DECLARE year INT; DECLARE season VARCHAR(10); DECLARE file_path VARCHAR(255); DECLARE done INT DEFAULT 0; DECLARE cur CURSOR FOR SELECT 1994, 'Winter' UNION ALL SELECT 1996, 'Summer' UNION ALL SELECT 1998, 'Winter' UNION ALL SELECT 2000, 'Summer' UNION ALL SELECT 2002, 'Winter' UNION ALL SELECT 2004, 'Summer' UNION ALL SELECT 2006, 'Winter' UNION ALL SELECT 2008, 'Summer' UNION ALL SELECT 2010, 'Winter' UNION ALL SELECT 2012, 'Summer' UNION ALL SELECT 2014, 'Winter' UNION ALL SELECT 2016, 'Summer' UNION ALL SELECT 2018, 'Winter' UNION ALL SELECT 2020, 'Summer' UNION ALL SELECT 2022, 'Winter' UNION ALL SELECT 2024, 'Summer'; DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1; OPEN cur; read_loop: LOOP FETCH cur INTO year, season; IF done THEN LEAVE read_loop; END IF; SET file_path = CONCAT(base_path, '/', year, '_', LOWER(season), '.csv'); SET @sql = CONCAT( "LOAD DATA LOCAL INFILE '", file_path, "' ", "INTO TABLE medals ", "FIELDS TERMINATED BY ',' ", "ENCLOSED BY '\"' ", "LINES TERMINATED BY '\n' ", "IGNORE 1 ROWS ", "(NOC, Gold, Silver, Bronze, Total) ", "SET Year = ", year, ", Season = '", season, "';" ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; END LOOP; CLOSE cur; END // -- 恢复默认结束符 DELIMITER ; -- 调用存储过程 CALL ImportOlympicData('C:/Users/Sophie/Desktop/8000/sql/archive (3)'); -- 执行查询 SELECT Year, Season, SUM(Gold) AS total_gold, ROUND(SUM(Gold) / (SELError Code: 1295. This command is not supported in the prepared statement protocol yet
最新发布
03-12
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值