Problem of convertion from Access to mysql

[jlin412]

Greeting to all mysql experts,

I recently try to convert Access to mySql DB using Intelligent Converter Access to Mysql. I have encountered few problems.

1. Some of php-mysql management programs can't view structure or data if table and column names have space; however, some can.
   Is it illegal to make names of table and column with spaces?

2. My convertion program convert / (backspace) to _ (underscore) for column names.
   Is it illegal to have / (backspace) in the column names?
   Are there any other characters bad for naming table and column?

Thx,

[bastien]

1. not always illegal (not allowable) but always a bad idea to include spaces in table AND field names...bet to replace all spaces with the undescore character

2. same thing...best to just use the underscore character

hth

[nnichols]

The mysql documentation says that a col_name can contain - alphanumeric characters, as well as the underscore and dollar sign characters ('_' , '$').

You cannot use reserved words - it will allow you with some reserved words but it causes chaos when working with the data.

A col_name must not consist solely of digits (0-9) as the name becomes indistinguishable from a number.

Hope this helps 😉

[jlin412]

What are reserved words or where to find them in documention?

[stolzyboy]

http://www.mysql.com/doc/en/Reserved_words.html