I'm getting a syntax error: Syntax error near 17:38
insert into tbl_otp('mobile', 'otp', 'exp') values (9932111111, 333333, 2019-04-09 17:38:34)
-
try wrapping the values with inverted commas ""Karun– Karun2019-04-09 16:47:11 +00:00Commented Apr 9, 2019 at 16:47
-
2Datetime not enclosed in single quotesP.Salmon– P.Salmon2019-04-09 16:47:35 +00:00Commented Apr 9, 2019 at 16:47
Add a comment
|
3 Answers
Single quotes denote string literals, so you shouldn't use them for column names. You should, however, surround the date literal with quotes:
insert into
tbl_otp(mobile, otp, exp) -- no quotes
values (9932111111, 333333, '2019-04-09 17:38:34') -- quotes
1 Comment
Lightness Races in Orbit
You should quote column names with backticks not just leave them open. It's a good habit.
insert into tbl_otp(`mobile`, `otp`, `exp`)
values ('9932111111', '333333', '2019-04-09 17:38:34')
Need to backquote your column names and single-quote your values, though the latter is just to be safe.
5 Comments
Lightness Races in Orbit
You mean "former"
Bill Karwin
I edited to format the code with 4-space indentation, so the backticks would be more clearly visible.
Lightness Races in Orbit
@LelioFaieta Until one day they are. It doesn't hurt. Use backticks. Good habit.
Lightness Races in Orbit
I once upgraded our systems past MySQL 5.6.2, which made
PARTITION a reserved word, to find that our codebase had a query without backticks around field names where one of the field names was "partition". We had to push a new build to literally everybody, for a two character fix that should never have been necessary in the first place. Wasn't nice!put the date value in quotes and remove quotes from column names:
insert into tbl_otp(mobile, otp, exp) values (9932111111, 333333, '2019-04-09 17:38:34')
1 Comment
JD D
fixed the column names to remove the single quotes