Đây là một cơ sở dữ liệu (CSDL) cung cấp thông tin về loại tiền tệ của tất cả các quốc gia trên toàn thế giới. CSDL này đã được tổng hợp và định dạng dưới dạng SQL, phù hợp để sử dụng trên hệ thống quản lý cơ sở dữ liệu MySQL Server. Chúng tôi rất vui được chia sẻ CSDL này với bạn, giúp bạn có thể khai thác và sử dụng thông tin trong các dự án của mình.
Tạo bảng CSDL có cấu trúc như sau:
-- -- Table structure for table `wp_currency` -- CREATE TABLE `wp_currency` ( `currency_id` int(11) UNSIGNED NOT NULL, `country` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `currency` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `code` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `symbol` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `wp_currency` -- ALTER TABLE `wp_currency` ADD PRIMARY KEY (`currency_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `wp_currency` -- ALTER TABLE `wp_currency` MODIFY `currency_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT; COMMIT;
Sau đó chúng ta insert data cho bảng CSDL này
-- Insert currency records
INSERT INTO wp_currency (country, currency, code, symbol) VALUES ('Albania', 'Leke', 'ALL', 'Lek');
INSERT INTO wp_currency (country, currency, code, symbol) VALUES ('America', 'Dollars', 'USD', '
Lấy dữ liệu currency
-- Select values from table SELECT * FROM currency;
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Afghanistan’, ‘Afghanis’, ‘AFN’, ‘؋’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Argentina’, ‘Pesos’, ‘ARS’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Aruba’, ‘Guilders’, ‘AWG’, ‘ƒ’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Australia’, ‘Dollars’, ‘AUD’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Azerbaijan’, ‘New Manats’, ‘AZN’, ‘ман’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Bahamas’, ‘Dollars’, ‘BSD’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Barbados’, ‘Dollars’, ‘BBD’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Belarus’, ‘Rubles’, ‘BYR’, ‘p.’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Belgium’, ‘Euro’, ‘EUR’, ‘€’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Beliz’, ‘Dollars’, ‘BZD’, ‘BZ
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Bermuda’, ‘Dollars’, ‘BMD’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Bolivia’, ‘Bolivianos’, ‘BOB’, ‘$b’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Bosnia and Herzegovina’, ‘Convertible Marka’, ‘BAM’, ‘KM’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Botswana’, ‘Pula’, ‘BWP’, ‘P’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Bulgaria’, ‘Leva’, ‘BGN’, ‘лв’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Brazil’, ‘Reais’, ‘BRL’, ‘R
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Britain (United Kingdom)’, ‘Pounds’, ‘GBP’, ‘£’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Brunei Darussalam’, ‘Dollars’, ‘BND’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Cambodia’, ‘Riels’, ‘KHR’, ‘៛’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Canada’, ‘Dollars’, ‘CAD’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Cayman Islands’, ‘Dollars’, ‘KYD’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Chile’, ‘Pesos’, ‘CLP’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘China’, ‘Yuan Renminbi’, ‘CNY’, ‘¥’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Colombia’, ‘Pesos’, ‘COP’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Costa Rica’, ‘Colón’, ‘CRC’, ‘₡’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Croatia’, ‘Kuna’, ‘HRK’, ‘kn’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Cuba’, ‘Pesos’, ‘CUP’, ‘₱’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Cyprus’, ‘Euro’, ‘EUR’, ‘€’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Czech Republic’, ‘Koruny’, ‘CZK’, ‘Kč’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Denmark’, ‘Kroner’, ‘DKK’, ‘kr’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Dominican Republic’, ‘Pesos’, ‘DOP ‘, ‘RD
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘East Caribbean’, ‘Dollars’, ‘XCD’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Egypt’, ‘Pounds’, ‘EGP’, ‘£’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘El Salvador’, ‘Colones’, ‘SVC’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘England (United Kingdom)’, ‘Pounds’, ‘GBP’, ‘£’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Euro’, ‘Euro’, ‘EUR’, ‘€’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Falkland Islands’, ‘Pounds’, ‘FKP’, ‘£’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Fiji’, ‘Dollars’, ‘FJD’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘France’, ‘Euro’, ‘EUR’, ‘€’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Ghana’, ‘Cedis’, ‘GHC’, ‘¢’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Gibraltar’, ‘Pounds’, ‘GIP’, ‘£’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Greece’, ‘Euro’, ‘EUR’, ‘€’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Guatemala’, ‘Quetzales’, ‘GTQ’, ‘Q’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Guernsey’, ‘Pounds’, ‘GGP’, ‘£’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Guyana’, ‘Dollars’, ‘GYD’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Holland (Netherlands)’, ‘Euro’, ‘EUR’, ‘€’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Honduras’, ‘Lempiras’, ‘HNL’, ‘L’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Hong Kong’, ‘Dollars’, ‘HKD’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Hungary’, ‘Forint’, ‘HUF’, ‘Ft’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Iceland’, ‘Kronur’, ‘ISK’, ‘kr’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘India’, ‘Rupees’, ‘INR’, ‘Rp’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Indonesia’, ‘Rupiahs’, ‘IDR’, ‘Rp’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Iran’, ‘Rials’, ‘IRR’, ‘﷼’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Ireland’, ‘Euro’, ‘EUR’, ‘€’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Isle of Man’, ‘Pounds’, ‘IMP’, ‘£’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Israel’, ‘New Shekels’, ‘ILS’, ‘₪’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Italy’, ‘Euro’, ‘EUR’, ‘€’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Jamaica’, ‘Dollars’, ‘JMD’, ‘J
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Japan’, ‘Yen’, ‘JPY’, ‘¥’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Jersey’, ‘Pounds’, ‘JEP’, ‘£’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Kazakhstan’, ‘Tenge’, ‘KZT’, ‘лв’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Korea (North)’, ‘Won’, ‘KPW’, ‘₩’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Korea (South)’, ‘Won’, ‘KRW’, ‘₩’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Kyrgyzstan’, ‘Soms’, ‘KGS’, ‘лв’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Laos’, ‘Kips’, ‘LAK’, ‘₭’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Latvia’, ‘Lati’, ‘LVL’, ‘Ls’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Lebanon’, ‘Pounds’, ‘LBP’, ‘£’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Liberia’, ‘Dollars’, ‘LRD’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Liechtenstein’, ‘Switzerland Francs’, ‘CHF’, ‘CHF’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Lithuania’, ‘Litai’, ‘LTL’, ‘Lt’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Luxembourg’, ‘Euro’, ‘EUR’, ‘€’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Macedonia’, ‘Denars’, ‘MKD’, ‘ден’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Malaysia’, ‘Ringgits’, ‘MYR’, ‘RM’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Malta’, ‘Euro’, ‘EUR’, ‘€’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Mauritius’, ‘Rupees’, ‘MUR’, ‘₨’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Mexico’, ‘Pesos’, ‘MXN’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Mongolia’, ‘Tugriks’, ‘MNT’, ‘₮’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Mozambique’, ‘Meticais’, ‘MZN’, ‘MT’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Namibia’, ‘Dollars’, ‘NAD’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Nepal’, ‘Rupees’, ‘NPR’, ‘₨’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Netherlands Antilles’, ‘Guilders’, ‘ANG’, ‘ƒ’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Netherlands’, ‘Euro’, ‘EUR’, ‘€’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘New Zealand’, ‘Dollars’, ‘NZD’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Nicaragua’, ‘Cordobas’, ‘NIO’, ‘C
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Nigeria’, ‘Nairas’, ‘NGN’, ‘₦’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘North Korea’, ‘Won’, ‘KPW’, ‘₩’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Norway’, ‘Krone’, ‘NOK’, ‘kr’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Oman’, ‘Rials’, ‘OMR’, ‘﷼’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Pakistan’, ‘Rupees’, ‘PKR’, ‘₨’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Panama’, ‘Balboa’, ‘PAB’, ‘B/.’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Paraguay’, ‘Guarani’, ‘PYG’, ‘Gs’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Peru’, ‘Nuevos Soles’, ‘PEN’, ‘S/.’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Philippines’, ‘Pesos’, ‘PHP’, ‘Php’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Poland’, ‘Zlotych’, ‘PLN’, ‘zł’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Qatar’, ‘Rials’, ‘QAR’, ‘﷼’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Romania’, ‘New Lei’, ‘RON’, ‘lei’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Russia’, ‘Rubles’, ‘RUB’, ‘руб’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Saint Helena’, ‘Pounds’, ‘SHP’, ‘£’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Saudi Arabia’, ‘Riyals’, ‘SAR’, ‘﷼’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Serbia’, ‘Dinars’, ‘RSD’, ‘Дин.’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Seychelles’, ‘Rupees’, ‘SCR’, ‘₨’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Singapore’, ‘Dollars’, ‘SGD’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Slovenia’, ‘Euro’, ‘EUR’, ‘€’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Solomon Islands’, ‘Dollars’, ‘SBD’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Somalia’, ‘Shillings’, ‘SOS’, ‘S’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘South Africa’, ‘Rand’, ‘ZAR’, ‘R’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘South Korea’, ‘Won’, ‘KRW’, ‘₩’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Spain’, ‘Euro’, ‘EUR’, ‘€’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Sri Lanka’, ‘Rupees’, ‘LKR’, ‘₨’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Sweden’, ‘Kronor’, ‘SEK’, ‘kr’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Switzerland’, ‘Francs’, ‘CHF’, ‘CHF’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Suriname’, ‘Dollars’, ‘SRD’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Syria’, ‘Pounds’, ‘SYP’, ‘£’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Taiwan’, ‘New Dollars’, ‘TWD’, ‘NT
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Thailand’, ‘Baht’, ‘THB’, ‘฿’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Trinidad and Tobago’, ‘Dollars’, ‘TTD’, ‘TT
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Turkey’, ‘Lira’, ‘TRY’, ‘TL’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Turkey’, ‘Liras’, ‘TRL’, ‘£’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Tuvalu’, ‘Dollars’, ‘TVD’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Ukraine’, ‘Hryvnia’, ‘UAH’, ‘₴’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘United Kingdom’, ‘Pounds’, ‘GBP’, ‘£’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘United States of America’, ‘Dollars’, ‘USD’, ‘
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Uruguay’, ‘Pesos’, ‘UYU’, ‘$U’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Uzbekistan’, ‘Sums’, ‘UZS’, ‘лв’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Vatican City’, ‘Euro’, ‘EUR’, ‘€’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Venezuela’, ‘Bolivares Fuertes’, ‘VEF’, ‘Bs’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Vietnam’, ‘Dong’, ‘VND’, ‘₫’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Yemen’, ‘Rials’, ‘YER’, ‘﷼’); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘Zimbabwe’, ‘Zimbabwe Dollars’, ‘ZWD’, ‘Z
Lấy dữ liệu currency
); INSERT INTO wp_currency (country, currency, code, symbol) VALUES (‘India’, ‘Rupees’, ‘INR’, ‘₹’);
Lấy dữ liệu currency
