MySQL Database

MySQL Database

am 25.07.2006 16:40:46 von James Jones

This is a multi-part message in MIME format.

------=_NextPart_000_0123_01C6AFCE.67CF4B00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

heres what i wanna do.......


for each month, i want to create a new table...........but if the table =
is already existing, then how would i detect that........and vice versa, =
how would i check that its not there.................
------=_NextPart_000_0123_01C6AFCE.67CF4B00
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



charset=3Diso-8859-1">




heres what i wanna =
do.......

 

 

for each month, i want to create a new=20
table...........but if the table is already existing, then how would i =
detect=20
that........and vice versa, how would i check that its not=20
there.................


------=_NextPart_000_0123_01C6AFCE.67CF4B00--

Re: MySQL Database

am 27.07.2006 13:32:27 von jeff.nospam

On Tue, 25 Jul 2006 09:40:46 -0500, "James Jones"
wrote:

>heres what i wanna do.......
>
>
>for each month, i want to create a new table...........but if the table is already existing, then how would i detect that........and vice versa, how would i check that its not there.................

First, rethink your design. You'd really need to be creative to
justify creating a new table each month when you could simply have a
month column in one table and selct records by month.

Jeff