At 9:37 AM -0500 12/2/99, Sean L. Gilley wrote:
>In version 3.22.25, I'm wondering just what characters I can use
>in my table names. In a system I've written, the customer enters
>information, and one entry in that information is used to create a
alphanumeric and '$' and '_'.
>We had a problem yesterday.
>The user tried to create a table with the name "MSVE 230-30-13".
>I guessed there couldn't be spaces in the name, but it looks like
>the dashes are getting interpreted as minus signs as well.
>I've tried creating the table name MSVE_230-30-13 in serveral ways:
> create table "MSVE_230-30-13"
> create table 'MSVE_230-30-13'
> create table MSVE_230\-30\-13
>and probably some others, but I can't seem to get past the syntax errors.
>Is there any way to create this table name, or should I simply
>disallow spaces and dashes for this value? (And is there anything else
>I should disallow?)
For your version of MySQL, disallow everything except alphanumerics,
'$' and '_'.
Paul DuBois, paul@stripped