MySQL Table from Microsoft Access Table

[Kyjan]

Guys,

First time poster. I've consulted these forums forever and they've been a great help, so...

I export a table from Microsoft Access to MySQL (and I can't edit the field names in the Access database because it's being used by something else as well). One of the field names in the Access table is 'Database' - which is a name that I know should not be here. When I export it to the MySQL database and attempt an 'ALTER TABLE', it throws a syntax error because I'm trying to use a reserved word wrongly. Is there a way to rename the field - for example, I want to do 'ALTER TABLE x CHANGE Database DatabaseChk char(1)', but it doesn't work. :-(

Thanks in advance!

[mourisj]

Use backticks :

alter table x change database ...

JJ Mouris