Is prefix a reserved keyword in mysql

Question

Is 'prefix' a reserved keyword in 'mysql', since I get the following error when I try to populate sample data using dbunit for a table containing column called 'prefix'

Embedded error: user.PREFIX - (Non-uppercase input column: prefix) in ColumnNameToIndexes cache map. Note that the map's column names are NOT case sensitive.

prefix is not a reserved keyword in mysql, and the error message is specifically on dbunit instead of mysql — ajreal, Jan 05 '11 at 08:28

score 3 · Accepted Answer · answered Jan 05 '11 at 08:35

MySQL reserved keywords are documented here:

http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html

Apart from the fact that PREFIX is not in the list, you should note that MySQL errors don't look like this. To begin with, they always start with a numeric error code.

Are you by chance calling as lowercase prefix a column you've defined as uppercase PREFIX?

Is prefix a reserved keyword in mysql

1 Answers1