[RESOLVED] Create mySQL tables called A to Z

[ClarkF1]

Hi,

I've been working with mySQL databases for about 3 hours now, so very new.

I was wondering if there is an easy way to create 26 tables called A through to Z

I know it would be possible using a loop to do it from 0 to 25 and then have 0 represent A for example but would prefer A to Z

I don't want to do it using myPHPadmin as I want to eventually create an install script so it all gets set up automatically.

[Installer]

Use range():

$uc_alpha = range('A', 'Z');
foreach ($uc_alpha as $letter) {
    mysql_query("CREATE TABLE " . $letter . " (etc)");
}

[ClarkF1]

Many thanks,

Very useful function that......

[Weedpacket]

Um, why on earth would you want "26 tables called A through Z"?! There must be a better way of doing whatever it is you want to do (e.g., have one table with an additional field to store the letter; or if it's the first letter of something stored in another field, the extra field isn't needed because you can look at that first letter).

[ClarkF1]

I've thought about this myself.......

I'm new to mySQL so I'm still seeing how things can be done.........

I'll probably change it anyway.........

Just finding out what is and what is not possible