Re: How can i drop tables with the same predix by using only one single statement?

2006-10-11 Thread Ow Mun Heng
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

Re: How can i drop tables with the same predix by using only one single statement?

2006-10-11 Thread Ow Mun Heng
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

Re: How can i drop tables with the same predix by using only one single statement?

2006-10-11 Thread Ow Mun Heng
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

Re: How can i drop tables with the same predix by using only one single statement?

2006-10-11 Thread Ow Mun Heng
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

Re: How can i drop tables with the same predix by using only one single statement?

2006-10-11 Thread Ow Mun Heng
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

Re: How can i drop tables with the same predix by using only one single statement?

2006-10-11 Thread Mark Leith
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 drop tables with the same predix by using only one single statement?

2006-10-11 Thread 方外 醉月
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? _ 与联机的朋