Inserting JSON to MySQL in Lua

Question

I went from SQLite to MySQL and now I have this issue.. this was not happening with previous SQLite system.. basically what I want is insert a JSON to MySQL, this is the example:

UPDATE stats SET achievements = `[ { "Filthy Rich": "10\/12\/14", "I keep on rollin'": "10\/12\/14" } ]` WHERE account = 'Feche'

And this is the error that I get:

(1054) Unknown column '[ { "Filthy Rich": "10\/12\/14", "I keep on rollin'": "10\/12\/14" } ]' in 'field list'

I've been searching but all answers are for PHP and non for Lua.. AFAIK PHP has an automatic encode that scapes all characters, but there is none in Lua.. thanks.

sgeddes · Accepted Answer · 2014-12-11 02:31:42Z

1

Don't use backticks, use apostrophes:

UPDATE stats 
SET achievements = '[ { "Filthy Rich": "10\/12\/14", "I keep on rollin''": "10\/12\/14" } ]' 
WHERE account = 'Feche'

Backticks are used to identify tables and columns, hence the unknown column error.

Also, you will need to escape any single quotes with double single quotes instead.

answered Dec 11, 2014 at 2:31

sgeddes

62.9k7 gold badges67 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

sgeddes Over a year ago

@Feche1320 -- I think you now have a different error. Looks like you have a single quote in your string. That needs to be escaped.

Feche1320 Over a year ago

Indeed that was the problem, sorry for the stupid question, thanks.

Collectives™ on Stack Overflow

Inserting JSON to MySQL in Lua

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related