Years ago I worked on an RDBMS that had a feature to allow execution of
'sections' of a command file, avoiding others. I am still ign scanning the
docs, but have not found anything similar in MySQL.
For example, in a database creation table one could enter (in MySQL format)
the following:
mysql> source master_DB_creation(table_a, table_c, consistency_check);
Where the file master_DB_creation file would contain:
-------------------------------------------
?section table_a
drop table if exists table_a;
create table table_a
( foo int not null auto_increment,
bar char(12),
primary key (foo)
);
?section table_b
drop table if exists table_b;
create table table_b
( foo int not null auto_increment,
name char(12),
.......
... yada ... yada ..yoda...
.......
phone char(12),
primary key (foo)
);
?section table_c
drop table if exists table_c;
create table table_c
( foo int not null auto_increment,
name char(12),
street char(24),
city char(18),
state char(2),
zip char(9),
PIN int,
primary key (foo, int)
);
?section consistency_check
select <some context from database to ensure consistency, etc.>.....
....
---------------------------------------------------
Does anyone know whether this functionality exists in MySQL?
Regards,
Tony
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
