Sorry for the multiple post screw up.
My Bad
On Thu, 2006-10-12 at 11:43 +0800, Ow Mun Heng wrote:
> On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote:
> > Hey
> >
> > 方外 醉月 wrote:
> > >
> > > How can i do if i want to drop tables with the same predix?
>
> > If you are using 5.0:
> >
> > DEL
On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote:
> Hey
>
> 方外 醉月 wrote:
> >
> > How can i do if i want to drop tables with the same predix?
> If you are using 5.0:
>
> DELIMITER //
> DROP PROCEDURE drop_table_prefix//
>
> CREATE PROCEDURE drop_table_prefix(IN dbs VARCHAR(64), IN pref VARCHA
On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote:
> Hey
>
> 方外 醉月 wrote:
> >
> > How can i do if i want to drop tables with the same predix?
> If you are using 5.0:
>
> DELIMITER //
> DROP PROCEDURE drop_table_prefix//
>
> CREATE PROCEDURE drop_table_prefix(IN dbs VARCHAR(64), IN pref VARCHA
On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote:
> Hey
>
> 方外 醉月 wrote:
> >
> > How can i do if i want to drop tables with the same predix?
> If you are using 5.0:
>
> DELIMITER //
> DROP PROCEDURE drop_table_prefix//
>
> CREATE PROCEDURE drop_table_prefix(IN dbs VARCHAR(64), IN pref VARCHA
On Wed, 2006-10-11 at 16:11 +0100, Mark Leith wrote:
> Hey
>
> 方外 醉月 wrote:
> >
> > How can i do if i want to drop tables with the same predix?
> If you are using 5.0:
>
> DELIMITER //
> DROP PROCEDURE drop_table_prefix//
>
> CREATE PROCEDURE drop_table_prefix(IN dbs VARCHAR(64), IN pref VARCHA
Hey
方外 醉月 wrote:
>
> How can i do if i want to drop tables with the same predix?
>
> For example, there is a database including a lot of tables,such as
> tableA,tableB(table*)
>
> Now,how can i drop those tables by using only one single statement?
>
> __
How can i do if i want to drop tables with the same predix?
For example, there is a database including a lot of tables,such as
tableA,tableB(table*)
Now,how can i drop those tables by using only one single statement?
_
与联机的朋