Mysql reserved keywords

Question

Navigation

#1 by (2 votes)
#2 by (2 votes)

0

When I log in to php my admin it displays the following message

The column name 'default' is a MySQL reserved keyword.

for a field called default of my table

My question is: can this cause any inconvenience when registering and using this field?

mysql palavras-reservadas

asked by anonymous 19.01.2016 / 17:09

2 answers

score 2 · Answer 1

2

It's not good practice, but I think the only major inconvenience you'll have is having to use escapes, such as "default" or between backticks - > '

19.01.2016 / 17:22

score 2 · Answer 2

2

It is allowed to use however it is necessary to escape with backsticks

 'default'

19.01.2016 / 17:23