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:
DELIMITER //
DROP
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?
_
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?
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 VARCHAR(63))
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 VARCHAR(63))
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 VARCHAR(63))
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 VARCHAR(63))