opencart 全货币支持代码

最新推荐文章于 2025-06-05 09:14:32 发布

越野骑士

最新推荐文章于 2025-06-05 09:14:32 发布

阅读量771

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.csdn.net/a1038546502/article/details/78844596

本文介绍了一段SQL脚本，用于向currency表中插入多种国际货币的数据，包括货币名称、符号、汇率等信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

LOCK TABLES currency WRITE;
/!40000 ALTER TABLE currency DISABLE KEYS /;
INSERT INTO currency VALUES (1,’Pound Sterling’,’GBP’,’Â£’,”,’2’,0.74753000,1,’2017-12-18 18:11:23’),(2,’US Dollar’,’USD’,’ $','','2',1.00000000,1,'2017-12-18 18:11:23'),(3,'Euro','EUR','','â<82>¬','2',0.84703000,1,'2017-12-18 18:11:23'),(4,'Japanese Yen','JPY','Â¥','','0',112.19000000,1,'2017-12-18 18:11:23'),(5,'Australian Dollar','AUD','$ ’,’AUD’,’2’,1.30290000,1,’2017-12-18 18:11:23’),(6,’Canadian Dollar’,’CAD’,’C $','CAD','2',1.27650000,1,'2017-12-18 18:11:23'),(7,'Czech Koruna','CZK','Kcs','','2',21.75000000,1,'2017-12-18 18:11:23'),(8,'Danish krone','DKK','kr.','','2',6.30550000,1,'2017-12-18 18:11:23'),(9,'Hungary Forint','HUF','Ft','','0',265.48000000,1,'2017-12-18 18:11:23'),(10,'Israel Shekel','ILS','â<82>ª','','2',3.52650000,1,'2017-12-18 18:11:23'),(11,'Mexico Peso','MXN','$ ’,’MXN’,’2’,19.16700000,1,’2017-12-18 18:11:23’),(12,’Taiwan New Dollar’,’TWD’,’NT $','','0',39.99990000,1,'2017-12-16 09:56:02'),(13,'New Zealand Dollar','NZD','$ ’,’NZD’,’2’,1.42330000,1,’2017-12-18 18:11:23’),(14,’Norway Krone’,’NOK’,’kr’,’NOK’,’2’,8.28630000,1,’2017-12-18 18:11:23’),(15,’Philippines Peso’,’PHP’,’â<82>±’,”,’2’,50.42200000,1,’2017-12-18 18:11:23’),(16,’Poland Zloty’,’PLN’,’zÅ<82>’,”,’2’,3.57170000,1,’2017-12-18 18:11:23’),(17,’Russia Ruble’,’RUB’,’â<82>½’,”,’2’,58.87200000,1,’2017-12-18 18:11:23’),(18,’Singapore Dollar’,’SGD’,’$’,’SGD’,’2’,1.34650000,1,’2017-12-18 18:11:23’),(19,’Swiss Franc’,’CHF’,’CHF’,”,’2’,0.98840000,1,’2017-12-18 18:11:23’),(20,’Thailand Baht’,’THB’,’à¸¿’,”,’2’,32.50500000,1,’2017-12-18 18:11:23’);
/!40000 ALTER TABLE currency ENABLE KEYS /;
UNLOCK TABLES;