我有这个查询,我正试图创建一个额外的列与它里面的href链接,我在这里做错了什么
SELECT
Id AS ID,
keywords AS keywords,
'<a href="'javascript:;'" class="'DELETE'" data-id="'+ id +'">Delete</a>' AS 'Delete'
FROM
tblkeywords
我得到的错误是:
1064 -你有一个错误的SQL语法;查看对应于MariaDB服务器版本的手册,以获得在第4行':'附近使用的正确语法
可以使用concat
函数:
SELECT
Id AS ID,
keywords AS keywords,
CONCAT('<a href="''javascript:;''" class="DELETE" data-id="', id,'">Delete</a>' AS 'Delete'
FROM
tblkeywords