Update list fruit

avatar
unknown
mysql
2 years ago
11 kB
5
Indexable
ALTER TABLE md_fetal_period_info
ADD fruit varchar(30);

ALTER TABLE md_fetal_period_info
ADD image_fruit nvarchar(100);

ALTER TABLE md_fetal_period_info
ADD gif_week nvarchar(100);

ALTER TABLE md_fetal_period_info
CHANGE  fruit fruit varchar(30) AFTER description,
CHANGE  image_fruit image_fruit varchar(100) AFTER description,
CHANGE  gif_week gif_week varchar(100) AFTER description;


UPDATE md_fetal_period_info
SET fruit = CASE
WHEN fetal_week = 1 THEN '--'
WHEN fetal_week = 2 THEN '--'
WHEN fetal_week = 3 THEN '--'
WHEN fetal_week = 4 THEN 'Hạt chia'
WHEN fetal_week = 5 THEN 'Hạt cam'
WHEN fetal_week = 6 THEN 'Hạt lựu'
WHEN fetal_week = 7 THEN 'Quả việt quất nhỏ'
WHEN fetal_week = 8 THEN 'Quả mâm xôi'
WHEN fetal_week = 9 THEN 'Quả anh đào'
WHEN fetal_week = 10 THEN 'Quả quất'
WHEN fetal_week = 11 THEN 'Quả sung'
WHEN fetal_week = 12 THEN 'Quả mận'
WHEN fetal_week = 13 THEN 'Quả chanh vàng'
WHEN fetal_week = 14 THEN 'Quả đào'
WHEN fetal_week = 15 THEN 'Quả táo'
WHEN fetal_week = 16 THEN 'Quả bơ'
WHEN fetal_week = 17 THEN 'Quả lê'
WHEN fetal_week = 18 THEN 'Củ khoai lang'
WHEN fetal_week = 19 THEN 'Quả xoài'
WHEN fetal_week = 20 THEN 'Quả chuối'
WHEN fetal_week = 21 THEN 'Củ cà rốt'
WHEN fetal_week = 22 THEN 'Quả đu đủ'
WHEN fetal_week = 23 THEN 'Cà tím'
WHEN fetal_week = 24 THEN 'Bắp ngô'
WHEN fetal_week = 25 THEN 'Bí đỏ Acorn'
WHEN fetal_week = 26 THEN 'Bí ngòi'
WHEN fetal_week = 27 THEN 'Súp lơ'
WHEN fetal_week = 28 THEN 'Bí Kabocha'
WHEN fetal_week = 29 THEN 'Bí đao'
WHEN fetal_week = 30 THEN 'Bắp cải lớn'
WHEN fetal_week = 31 THEN 'Bó tỏi tây'
WHEN fetal_week = 32 THEN 'Bắp cải Napa'
WHEN fetal_week = 33 THEN 'Quả dứa'
WHEN fetal_week = 34 THEN 'Quả dưa lưới'
WHEN fetal_week = 35 THEN 'Quả dưa mật'
WHEN fetal_week = 36 THEN 'Quả dưa vàng'
WHEN fetal_week = 37 THEN 'Cải cầu vồng'
WHEN fetal_week = 38 THEN 'Thân cây đại hoàng'
WHEN fetal_week = 39 THEN 'Quả dưa hấu'
WHEN fetal_week = 40 THEN 'Quả dưa hấu'
ELSE NULL
END;


UPDATE md_fetal_period_info
SET image_fruit = CASE
when fetal_week =1 then "nothing"
when fetal_week =2 then "nothing"
when fetal_week =3 then "nothing"
WHEN fetal_week = 4 THEN "https://admmomeduapi.exsoft.vn/api/attachments/db2d46f5-739d-43cd-8b00-c3ca46b5c7ce"
WHEN fetal_week = 5 THEN "https://admmomeduapi.exsoft.vn/api/attachments/169a37e7-d7db-462c-9f81-2b9dd8f143a2"
When fetal_week = 6 then "https://admmomeduapi.exsoft.vn/api/attachments/de0eb30d-2ce5-4b1c-802d-0bc29cee152f"
when fetal_week = 7 then "https://admmomeduapi.exsoft.vn/api/attachments/227fb625-283b-467b-a6ee-e0a96c40cdd2"
when fetal_week = 8 then "https://admmomeduapi.exsoft.vn/api/attachments/7743cf6f-11e2-4b94-b516-9cc046fb4657"
when fetal_week = 9 then "https://admmomeduapi.exsoft.vn/api/attachments/69d09160-c3d7-495e-aa23-747d4b4171f6"
when fetal_week = 10 then "https://admmomeduapi.exsoft.vn/api/attachments/726adce5-c1d2-46e6-b2b0-b43270a8bdc2"
when fetal_week = 11 then "https://admmomeduapi.exsoft.vn/api/attachments/0110c58e-d3fa-49e5-b121-aa3cc02704a7"
when fetal_week =12 then "https://admmomeduapi.exsoft.vn/api/attachments/e5fbc1ac-c22c-499f-874f-085d4beb7b35"
when fetal_week = 13 then "https://admmomeduapi.exsoft.vn/api/attachments/dbae2cf8-4ab8-49e5-a2ce-bc11c4af89c0"
when fetal_week =14 then "https://admmomeduapi.exsoft.vn/api/attachments/1d803ae7-e98c-41d9-874a-97c2039d4a39"
when fetal_week = 15 then "https://admmomeduapi.exsoft.vn/api/attachments/3aabc533-8731-4385-b096-5407d641774d"
when fetal_week = 16 then "https://admmomeduapi.exsoft.vn/api/attachments/4fbf368e-6afb-4ceb-abe6-e34c398c9401"
when fetal_week = 17 then "https://admmomeduapi.exsoft.vn/api/attachments/c38a72d6-a86f-46fc-81df-de95822e09fd"
when fetal_week = 18 then "https://admmomeduapi.exsoft.vn/api/attachments/30e3a2a1-5675-4d67-a79c-e3928363087d"
when fetal_week = 19 then "https://admmomeduapi.exsoft.vn/api/attachments/dc174447-4055-4a18-a1fe-044a29bbdc64"
when fetal_week = 20 then "https://admmomeduapi.exsoft.vn/api/attachments/09ffeaf0-7ee9-45ad-b10e-3eb715620375"
when fetal_week = 21 then "https://admmomeduapi.exsoft.vn/api/attachments/97b6ba0f-e203-4a44-ae77-051fa2cd0589"
when fetal_week = 22 then "https://admmomeduapi.exsoft.vn/api/attachments/84632a6e-a886-4ae9-8f84-ef18e5d17f24"
when fetal_week = 23 then "https://admmomeduapi.exsoft.vn/api/attachments/fc3549b3-a8cd-4101-b266-3103d65c1c5d"
when fetal_week = 24 then "https://admmomeduapi.exsoft.vn/api/attachments/2db007db-8ffe-4dc8-9280-8cac36c42def"
when fetal_week = 25 then "https://admmomeduapi.exsoft.vn/api/attachments/6609052b-a637-4a33-9908-1994f67a7cea"
when fetal_week = 26 then "https://admmomeduapi.exsoft.vn/api/attachments/2327fab7-64c8-4ccf-a459-9c98c11bc8ee"
when fetal_week = 27 then "https://admmomeduapi.exsoft.vn/api/attachments/a40e54e5-ace6-44fb-a3e9-428f64fa085b"
when fetal_week = 28 then "https://admmomeduapi.exsoft.vn/api/attachments/dc17947a-2610-458f-a977-5c8d9789a266"
when fetal_week =29 then "https://admmomeduapi.exsoft.vn/api/attachments/e9057003-8837-426f-a005-5fe96323763c"
when fetal_week = 30 then "https://admmomeduapi.exsoft.vn/api/attachments/3020437a-8cef-4198-930e-c7936e959f39"
when fetal_week = 31 then "https://admmomeduapi.exsoft.vn/api/attachments/5fb635f2-9961-4bae-b6a1-0df7772e6710"
when fetal_week = 32 then "https://admmomeduapi.exsoft.vn/api/attachments/4d8d56b0-9c18-42a2-b198-69e88e884215"
when fetal_week = 33 then "https://admmomeduapi.exsoft.vn/api/attachments/8ef359ac-6a14-4cae-8d14-aaec3ac7367c"
when fetal_week = 34 then "https://admmomeduapi.exsoft.vn/api/attachments/aa4e49d2-8aaa-4eee-9fd8-60cec27fa7a9"
when fetal_week = 35 then "https://admmomeduapi.exsoft.vn/api/attachments/da3e8ee6-262e-4712-a470-8dbbe0371b9f"
when fetal_week =36 then "https://admmomeduapi.exsoft.vn/api/attachments/1872c012-7d38-472d-a3cd-c9c18a75bd51"
when fetal_week = 37 then "https://admmomeduapi.exsoft.vn/api/attachments/a66d30f6-75f0-4152-b185-34d7bc544295"
when fetal_week = 38 then "https://admmomeduapi.exsoft.vn/api/attachments/513b3214-153b-49fb-80dd-14d52862994e"
when fetal_week = 39 then "https://admmomeduapi.exsoft.vn/api/attachments/abfb8943-abda-459d-a861-8daf65eb39d1"
when fetal_week = 40 then "https://admmomeduapi.exsoft.vn/api/attachments/abfb8943-abda-459d-a861-8daf65eb39d1"
ELSE NULL
END;


UPDATE md_fetal_period_info
SET gif_week = CASE
WHEN fetal_week = 1 THEN "https://admmomeduapi.exsoft.vn/api/attachments/d1a56bb6-a8fc-4521-9e90-7d039678963e"
WHEN fetal_week = 2 THEN "https://admmomeduapi.exsoft.vn/api/attachments/eaa46429-fe9d-4d18-829e-21b9e721e78c"
WHEN fetal_week = 3 THEN "https://admmomeduapi.exsoft.vn/api/attachments/dab17cd5-773a-47e8-b1ed-f737425727b1"
WHEN fetal_week = 4 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/0088860b-da81-440d-aa53-124682e73e1b'
WHEN fetal_week = 5 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/d1704f3d-6c8c-42a2-ae9c-9f83a5a09264'
WHEN fetal_week = 6 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/0f6eef8f-7072-4bd7-a175-3da357198545'
WHEN fetal_week = 7 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/020eed1b-90b1-4c65-8c46-d2a8d5071086'
WHEN fetal_week = 8 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/0fd802b7-1f94-4c7c-9a8d-bec0405dafaf'
WHEN fetal_week = 9 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/e16e5dd1-300d-46de-8ed0-e56c7b99993b'
WHEN fetal_week = 10 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/bb56a697-0a66-4b04-9369-e1f3a2aadc89'
WHEN fetal_week = 11 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/02a33512-0567-4cec-8532-4384dc843f4a'
WHEN fetal_week = 12 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/6565630c-05d1-4af2-94ae-a321e2a37018'
WHEN fetal_week = 13 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/f1a35c88-1fc4-4e96-b414-5901e9fd6440'
WHEN fetal_week = 14 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/8a78229e-1b57-4ca9-a53b-a6b1654a8918'
WHEN fetal_week = 15 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/7c6afbb0-01de-4087-bf3b-3af0efb296df'
WHEN fetal_week = 16 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/bc6f6838-9010-4e37-a157-2faeac8d6dab'
WHEN fetal_week = 17 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/c5389db8-5a71-433d-8e5d-9624dc47dd30'
WHEN fetal_week = 18 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/0513deb8-1738-4ac0-9863-73de5c3cf2d7'
WHEN fetal_week = 19 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/accb377e-eaaa-4e38-8847-bcd4bc6f5946'
WHEN fetal_week = 20 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/c1aa49b8-3b1d-4a20-b685-7565ddb2778e'
WHEN fetal_week = 21 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/74b8368b-4271-4e95-a324-05996a810f97'
WHEN fetal_week = 22 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/a2fe468e-24a4-432d-b559-ec6bef683de6'
WHEN fetal_week = 23 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/6d08b4fa-ee9b-4055-b63f-62537ac0d4c9'
WHEN fetal_week = 24 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/53ed121a-07b9-444e-b620-d41929ae876f'
WHEN fetal_week = 25 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/1afa3711-f1e4-4bbd-ab95-48bdc6b63daa'
WHEN fetal_week = 26 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/5b9ede70-19d1-4c5c-8873-1bdf956ef18a'
WHEN fetal_week = 27 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/f8a0c152-78cb-455c-bcca-f4ff38159d9f'
WHEN fetal_week = 28 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/6ce3be3a-475e-43ce-a81c-a6955a5ce41a'
WHEN fetal_week = 29 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/cd8e35ff-f047-4f98-8e38-b1f8245e3e5b'
WHEN fetal_week = 30 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/4c30ae38-a574-4955-8e21-528cb1fa2364'
WHEN fetal_week = 31 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/5b2b65e9-6c1a-4382-842c-b485cb2ed03f'
WHEN fetal_week = 32 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/f9a0eb81-3823-477a-af44-4c9ee73fb377'
WHEN fetal_week = 33 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/94010417-e7f8-4dd4-9071-fad2151939a9'
WHEN fetal_week = 34 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/47f269ca-7b73-439b-91a2-1b943dd987ad'
WHEN fetal_week = 35 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/e86f6598-5a41-44ef-a735-21341535cf6f'
WHEN fetal_week = 36 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/39bcd965-f7d2-44fd-a2e5-7b515c086481'
WHEN fetal_week = 37 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/8b682563-dcff-44d1-adc7-07236b070dd0'
WHEN fetal_week = 38 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/19df7d37-ee38-4643-92bb-2c5c0eff00f5'
WHEN fetal_week = 39 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/884e0f05-cf02-4e25-9921-822fd618442f'
WHEN fetal_week = 40 THEN 'https://admmomeduapi.exsoft.vn/api/attachments/fda00a90-0e54-47a0-ae25-0e318355d4f5'
ELSE NULL
END;
Editor is loading...