table name filtered while uploading database

[eshban]

Hello
i am facing a severe problem while deploying a database on my server. Actually my database has a Table and a field with the name 'I.N.T.E.R.C.O.U.R.S.E', so when i upload the sql script through phpmyadmin, it wont accept that name. It is not possible for me to change the database and field name.So kindly guide that how can i deploy my database and fix this problem.

please help in this regard

Eshban

[vinyl-junkie]

You can't have a table name with periods in it. You'll have to change the name. It's ok to have periods in the data element names though.

[eshban]

oh you take the wrong meaning, there is no periods in table name and field name. I just used periods to avoid filteration in this forum.

Hope you got my point.

My table name is INTERCOURSE

Please help in this regard.

Eshban

[vinyl-junkie]

Whatever. As long as the syntax is correct on your command that creates the table, as long as it isn't a reserve word, creating your table should work. If phpMyAdmin has its own "bad word" filter and won't accept the name for some reason, the advice I gave you is still the same. Choose another name for it.

[Lee Stevens]

Link below is MySQL's Reserved Words List.

Have a read throu: http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html , see if that can help you.

[ralph l mayo]

Link below is MySQL's Reserved Words List.

Have a read throu: http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html , see if that can help you.

crap, can't change it to INOUT either ;)

[firepages]

My PHPMyAdmin let me use the following ? perhaps you have 2 different PHPMyAdmin versions ? , if so update your local version to that on the server (newer PHPMyAdmin's allow you to export in a format suitable for older versions)

CREATE TABLE `INTERCOURSE` (
`INTERCOURSE` TINYINT( 1 ) NOT NULL
) TYPE = MYISAM ;


:) @ ralph