DELIMITER $$
CREATE PROCEDURE FindCSourceRecords()
BEGIN
DECLARE done INT DEFAULT FALSE;
DECLARE tableName VARCHAR(255);
DECLARE cur CURSOR FOR
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'c_source'
AND TABLE_SCHEMA = 'cbdb_data'; -- Replace with your database name
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
OPEN cur;
read_loop: LOOP
FETCH cur INTO tableName;
IF done THEN
LEAVE read_loop;
END IF;
-- Corrected dynamic SQL to properly execute and check for existence
SET @s = CONCAT('SELECT EXISTS (SELECT 1 FROM ', tableName, ' WHERE c_source = 38299) INTO @exists;');
PREPARE stmt FROM @s;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
-- Check if the query found a row and then do something with the result
IF @exists THEN
-- This is a placeholder action; you might want to SELECT the table name or insert it into a log
SELECT CONCAT('Found in table: ', tableName) AS Result;
END IF;
END LOOP;
CLOSE cur;
END$$
DELIMITER ;
Call query procedure
CALL FindCSourceRecords();
Remove query procedure
DROP PROCEDURE IF EXISTS FindCSourceRecords;
The procedure to update
DELIMITER $$
CREATE PROCEDURE UpdateCSourceRecords()
BEGIN
DECLARE done INT DEFAULT FALSE;
DECLARE tableName VARCHAR(255);
DECLARE cur CURSOR FOR
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'c_source'
AND TABLE_SCHEMA = 'cbdb_data'; -- Replace with your actual database name
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
OPEN cur;
read_loop: LOOP
FETCH cur INTO tableName;
IF done THEN
LEAVE read_loop;
END IF;
-- Dynamic SQL for updating c_source values
SET @s = CONCAT('UPDATE ', tableName, ' SET c_source = 9334 WHERE c_source = 38299;');
PREPARE stmt FROM @s;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
END LOOP;
CLOSE cur;
END$$
DELIMITER ;
Fuller’s London Pride: 甜與清香,但不清冽。有評論說它像 sweet raisin 和乾水果。這種味道確實很有辨識度。
LORD HOBO 的 J.P. LICKS CHOCOLATE MINT ICE CREAM STOUT: 麻州 Woburn 的 LORD HOBO 釀酒公司每季度會和一間本地社區的公司一起推出限定的創意啤酒。這次他們的合作夥伴是 J.P LICKS 冰激凌公司! 2023 年冬季合作的就是這款 CHOCOLATE MINT ICE CREAM STOUT. 這麼想來 CHOCOLATE, ICE CREAM 和 STOUT 確實是太合拍了!它的口味也是直接且過癮的 CHOCOLATE MINT ICE CREAM + STOUT,這口味描述沒有一個字多餘。另外,有點奇怪的是,在冬季退出冰激凌款啤酒是不是有點不合時宜~ 這裡也引用酒標上的全文:Our Collab Series features quarterly releases only available for a limited time. Each release features a different company in our local community that we’ve teamed up with to craft a unique and innovative beer. CHOCOLATE MINT ICE CREAM – For our last collab of the year, we’ve Partnered with our friends at J.P. Licks to bring you a Chocolate Mint Ice Cream Stout. Brewed with lactose for a smooth Yet full body, aromas and flavors of refreshing mint are complimented by bold notes of hare con with a hint of creamy vanilla.
這張小提琴獨奏專輯演奏者 Hilary Hahn 正師從 Eugène Ysaÿe 的學生 Jascha Brodsky. Hilary Hahn 熟稔 Eugène Ysaÿe 以及 Eugène Ysaÿe 同時代小提琴演奏家的演奏技術。因此在專輯中,Hilary Hahn 也致敬了 Eugène Ysaÿe 的同輩,如 Joseph Szigeti, Jacques Thibaud, George Enescu, Fritz Kreisler, Mathieu Crickboom, and Manuel Quiroga 的風格。
這張專輯在錄音技術上採用非常獨特的方法:在波士頓的一間 radio station studio 進行近距離錄音。這種錄音方法巨大的犧牲了聲場,但營造出似乎坐在 Hilary Hahn 近旁椅子上傾聽的奇妙親近感。Eugène Ysaÿe 式飽滿的情緒,加上克制顫弓和細緻的左手技術把情緒侵略性變得雅緻。在情緒性和雅緻化兩者的張力下,聽者非常容易聽進去。
這樣創造性錄音技術之外,Hilary Hahn 還是一家 AI 科技公司的聯合創始人、副總裁。這家科技公司叫做 deepmusic.ai. 而另一位聯合創始人兼 CEO 是 Carol Reiley. Carol Reiley 的丈夫則是 Andrew Ng. deepmusic.ai 公司的咨詢委員會正是 Andrew Ng 以及 Jeremy Howard. Jeremy Howard 是 kaggle 的總裁,Fast.AI 的創始人,和 huggingface 有緊密的關聯,是當前飽受關注的 AI 編程語言 Mojo 所屬的公司 Modular 的顧問。之前我也讀過他的書: Deep Learning for Coders with Fastai and PyTorch: AI Applications Without a PhD. 不過從網站和社交媒體上看,這間公司可能是因為新冠疫情的影響,今年來鮮有活動。
Tree Elephant Pale Ale by Wandering Soul – 右一:New England Pale ALE, 輕微苦,有啤酒花的清香。 這支酒又是麻州公司在麻州釀造的本地酒。罐子上也標註了这支酒使用的啤酒花:Chinook, El Dorado and Idaho 7 hopes. 罐體印製大象主題口號:plant a tree or die(不種樹就去死)。Plant a tree or die 也是一隻波士頓 hardcore punk (硬核朋克) 樂隊 Tree 的第四張專輯。沒錯!這家啤酒廠和 Tree 樂隊有合作,並且在罐子上印製了樂隊網站的二維碼。這是解析獲得的網址:https://linktr.ee/treeboston.
Cold Pizza by Black Hog Brewing Co. – 左二:罐子上說是 Dry Hopped Italian Style Pilsner(干投意大利風格皮爾森)。Dry Hopped 是多次投入啤酒花,帶來能濃郁的啤酒花香。確實感受到更濃的啤酒花香。但味道比較單一,清爽度也不太好。也許是放得有點久了?
Melody Maker by Wandering Soul Beer – 中間:Melody 是個沒能成功出生在這個世界的嬰兒。這裡就全文引用罐子上的悲傷的故事吧:
Melody Maker is a hazy and tropical pale ale, browed with some of my favorite hops, along with flaked oats to enhance the body of the beer. This beer is dedicated to our first child Melody, who we lost when my wife was almost 9 months in pregnant in 2017. After going through that experience, I knew that I had to channel my grief somehow. This beer is an attempt at that.
Part of the goal of this project is to help others who have experienced loss in their lives. A portion of profits will be donated to Resolve New England, a group that helps families with Pregnancy loss.
Thank you for buying this deer and for supporting this project.It means more than I can say.
3. **Hazy IPA**:這是指 “Hazy India Pale Ale” 的啤酒風格,也被稱為 “New England IPA”。這種啤酒具有濃郁的香氣、較低的苦味、和模糊(或濁澀)的外觀。與傳統的IPA不同,Hazy IPA重視果汁般的口感和濃郁的啤酒花風味。
因此,”DDH Tassie Hazy IPA” 應該是一種使用塔斯馬尼亞啤酒花,且經過兩次乾投啤酒花過程的Hazy India Pale Ale 啤酒。
The Lady Legendary – 左二:清冽的 cider!酸酸的清爽的味道,是青蘋果的感覺。完全沒有甜味。酿酒厂在麻州 Leominster 北方,估計在麻州以外不太容易喝到。據說是用 Heirloom 蘋果(美國的一種青蘋果)放在橡木桶裡發酵得來的。
Major Tom – 右二:特別純正的 New England IPA,中度苦味,回味有些果香。和圖上的喵星人完全不搭。嗚嗚嗚>w<
Cherry Sour à La Mode – 左一:酸酸的草莓和熱帶水果的風味!BERLINER WEISS 風格啤酒~ 不會甜也不會過於酸。仔細品味似乎有一些太妃糖的味道。罐子上的自述說是有肉桂,不太容易嘗出來。自述非常有趣,把製造商、合作商,對酒的味道的說明,以及罐子的藝術設計者都列了出來。充滿了自豪和單純~ 這裡就把自述全文引出來吧:BERLINER WEISS STYLE ALE WITH CHERRY JUICE CONCENTRATE, CINNAMON AND NATURAL FLAVOR. BREWED + CANNED BY UNTITLED ART. WAUNAKEE, WI IN COLLABORATION WITH CORPORATE LADDER BREWING. ARTWORK BY STEPHENIE HAMEN 後面還跟著 STEPHENIE HAMEN 親筆的簽名。STEPHENIE HAMEN 是一位現代圖像設計師,這裡也附上她的網站鏈接:https://stepheniehamenart.com