将欧元和美元符号插入到 mysql 中的列中 [英] Insert Euro and Dollar symbol to a column in mysql

问题描述

我有 2 行看起来像这样.这是表的创建语句.

I have 2 rows which looks like this. This is the create statement of the table.

CREATE TABLE `currency` (
  `ID` int(10) unsigned NOT NULL,
  `Name` varchar(100) NOT NULL,
  `Abbreviation` varchar(10) NOT NULL,
  `symbol` varchar(5) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE = InnoDB DEFAULT CHARSET = latin1;

我想做的就是为它们插入符号，但它不起作用.我试过这样做.

And all I want to do is insert symbols for them, but its not working. I tried doing it this way.

insert into currency (id, symbol ) values (1,'€') ;
insert into currency (id, symbol ) values (2,'$') ;

推荐答案

使用 UPDATE 和 WHERE 条件.

UPDATE currency
SET symbol = '€'
WHERE ID = 1;
UPDATE currency
SET symbol = '$'
WHERE ID = 2;

这篇关于将欧元和美元符号插入到 mysql 中的列中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！