用单引号引起引用的列值后如何更新MySQL表?
众所周知,借助QUOTE()
函数,我们可以将列的值放在单引号中。通过将QUOTE()
函数与UPDATE子句一起使用,我们可以更新带有引号的表。我们需要给出列名作为QUOTE()
函数的参数。下面的示例在将“Course”列的值放在单引号中之后将更新表“examination_btech”。
示例
mysql> UPDATE examination_btech SET Course = QUOTE(Course); mysql> Select * from examination_btech; +--------+----------+----------+ | RollNo | Name | Course | +--------+----------+----------+ | 1 | Rahul | 'B.Tech' | | 2 | Raman | 'B.Tech' | | 3 | Sahil | 'B.Tech' | | 4 | Shalini | 'B.Tech' | | 5 | Pankaj | 'B.Tech' | | 6 | Mohan | 'B.Tech' | | 7 | Yash | 'B.Tech' | | 8 | digvijay | 'B.Tech' | | 9 | Gurdas | 'B.Tech' | | 10 | Preeti | 'B.Tech' | +--------+----------+----------+ 10 rows in set (0.00 sec)