SQL konstanty

Pouzivam treba stejny prefix pro vice tabulek. Lze to nejak napsat konstantou?

DROP TABLE IF EXISTS machat_room;

CREATE TABLE machat_banned (
ip varchar(15) NOT NULL default '',
PRIMARY KEY(ip)
) TYPE=MYISAM;
-- ) TYPE=MyISAM COLLATE cp1250_general_ci;

CREATE TABLE machat_room (
id int(11) NOT NULL AUTO_INCREMENT,
nick1 varchar(16) default NULL,
nick2 varchar(16) default NULL,
type int(11) default NULL,
date datetime NOT NULL default '0000-00-00 00:00:00',
text varchar(255) default NULL,
ip varchar(15) NOT NULL default '',
PRIMARY KEY(id),
KEY (nick1),
KEY (nick2),
KEY (type)
) TYPE=MyISAM;
-- ) TYPE=MyISAM COLLATE cp1250_general_ci;

V manualu jsem po dlouhem hledani objevil
http://dev.mysql.com/doc/refman/5.1/en/user-variables.html

Nicmene to neumim zkombinovat...
SET @aaa = 'machat_';
SHOW TABLES LIKE @aaa+'banned';

Jeste by to slo mozna obejit pres procedury, ze si nadefinuji create a drop table. To budu muset zjistit zas, jak se dela.