List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:December 2 1999 5:49pm
Subject:Re: Question on table names in v3.22.25
View as plain text  
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
>table name.

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
Question on table names in v3.22.25Sean L. Gilley2 Dec
  • Re: Question on table names in v3.22.25Paul DuBois2 Dec