MewV9qQv

1create database Control;
2
3DELIMITER $$
4CREATE PROCEDURE taulacontrol_proc()
5
6BEGIN
7
8create table IF NOT EXISTS TaulaControl(
9	
10	nomBd varchar(20),
11	nomTaula varchar(20),
12	registres int(6)
13
14)
15select TABLE_SCHEMA, TABLE_NAME, TABLE_ROWS	
16FROM information_schema.tables;
17	
18END
19$$
20DELIMITER ;
21
22CALL taulacontrol_proc;