Whitespaces in MySQL

[Anon]

Hi,

Are white spaces supported in MySQL variables names. For example, I want to create a table named "My Table". Will I have to substitute the space character with something else or can I pass this onto MySQL using the double (or single) quotes around it?

Also, would anyone mind telling me all illegal characters in MySQL so I can strip them out? What would be even more helpful is if someone has done a regular expression substituting illegal characters and could give me the expression for it :-)

thanks so much
-sridhar

[Anon]

You cannot have whitespaces in database or table names.

The only characters you have to worry about are single quotes in text that you insert. These should be escaped by the \ character.

If magic_quotes_gpc is on in the php.ini file, then the quotes will be escaped automatically from form data when the form is submitted. If you want to escape them manually, then use $text = addslashes($text);

Hope that helps...

---John Holmes...