MySQL Database

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2912" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>heres what i wanna =
do.......</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>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.................</FONT></DIV></BODY></HTML>

------=_NextPart_000_0123_01C6AFCE.67CF4B00--
James Jones [ Di, 25 Juli 2006 16:40 ] [ ID #1404374 ]

Re: MySQL Database

On Tue, 25 Jul 2006 09:40:46 -0500, "James Jones"
<jamisonburrous08 [at] insightbb.com> 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
jeff.nospam [ Do, 27 Juli 2006 13:32 ] [ ID #1407456 ]
Webserver » microsoft.public.inetserver.asp.db » MySQL Database

Vorheriges Thema: MySQL Database Connections
Nächstes Thema: New group