mysql> show tables; +-------------------+ | Tables_in_final | +-------------------+ | cliente | | compra | | detalle_compra | | detalle_domicilio | | detalle_factura | | detalle_pedido | | domicilio | | empleado | | factura | | pedido | | perfil | | producto | | proveedor | | supermercado | +-------------------+ 14 rows in set (0.00 sec) mysql> delimiter // mysql> delimiter ; mysql> describe cliente; +-----------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+----------+------+-----+---------+-------+ | cedula | char(10) | NO | PRI | NULL | | | nombre1 | char(20) | NO | | NULL | | | nombre2 | char(20) | YES | | NULL | | | apellido1 | char(20) | NO | | NULL | | | apellido2 | char(20) | NO | | NULL | | | direccion | char(15) | NO | | NULL | | | telefono | char(10) | NO | | NULL | | +-----------+----------+------+-----+---------+-------+ 7 rows in set (0.09 sec) mysql> delimiter // mysql> create procedure insertarc(in _cedula char(10), in _nombre1 char(20), in _nombre2 char(20), in _apellido1 char(20), in _apellido2 char(20), in _direccion char(15), in _telefono char(10)) -> begin -> insert into cliente(cedula,nombre1,nombre2,apellido1,apellido2,direccion,telefono) values (_cedula, _nombre1, _nombre2, _apellido1, _apellido2, _direccion, _telefono); -> end -> // Query OK, 0 rows affected (0.08 sec) mysql> delimiter ; mysql> describe empleado; +------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+----------+------+-----+---------+-------+ | id | char(10) | NO | PRI | NULL | | | nombre1 | char(20) | NO | | NULL | | | nombre2 | char(20) | YES | | NULL | | | apellido1 | char(20) | NO | | NULL | | | apellido2 | char(20) | NO | | NULL | | | direccion | char(15) | NO | | NULL | | | telefono | char(10) | NO | | NULL | | | cod_perfil | char(5) | NO | MUL | NULL | | +------------+----------+------+-----+---------+-------+ 8 rows in set (0.08 sec) mysql> delimiter // mysql> create procedure insertarc(in _id char(10), in _nombre1 char(20), in _nombre2 char(20), in _apellido1 char(20), in _apellido2 char(20), in _direccion char(15), in _telefono char(10), in _cod_perfil char(5)) -> begin -> insert into empleado(id,nombre1,nombre2,apellido1,apellido2,direccion,telefono,cod_perfil) values (_cedula, _nombre1, _nombre2, _apellido1, _apellido2, _direccion, _telefono, _cod_perfil); -> end -> // ERROR 1304 (42000): PROCEDURE insertarc already exists mysql> create procedure insertare(in _id char(10), in _nombre1 char(20), in _nombre2 char(20), in _apellido1 char(20), in _apellido2 char(20), in _direccion char(15), in _telefono char(10), in _cod_perfil char(5)) -> begin -> insert into empleado(id,nombre1,nombre2,apellido1,apellido2,direccion,telefono,cod_perfil) values (_cedula, _nombre1, _nombre2, _apellido1, _apellido2, _direccion, _telefono, _cod_perfil); -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> create procedure modificarc(in _nombre1 char(20), in _nombre2 char(20), in _apellido1 char(20), in _apellido2 char(20), in _direccion char(15), in _telefono char(10)) -> begin -> update cliente set nombre1=_nombre1, nombre2=_nombre2, apellido1=_apellido1, apellido2=_apellido2, direccion=_direccion, telefono=_telefono// ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 mysql> create procedure modificarc(in _cedula char(10), in _nombre1 char(20), in _nombre2 char(20), in _apellido1 char(20), in _apellido2 char(20), in _direccion char(15), in _telefono char(10)) -> begin -> update cliente set nombre1=_nombre1, nombre2=_nombre2, apellido1=_apellido1, apellido2=_apellido2, direccion=_direccion, telefono=_telefono where cedula=_cedula; -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> create procedure consultarc(in _cedula char(10)) -> begin -> select cedula, nombre1, nombre2, apellido1, apellido2, direccion, telefono where cedula=_cedula; -> end -> // ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where cedula=_cedula; end' at line 3 mysql> create procedure consultarc(in _cedula char(10)) -> begin -> select cedula, nombre1, nombre2, apellido1, apellido2, direccion, telefono from cliente where cedula=_cedula; -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> describe cliente; +-----------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+----------+------+-----+---------+-------+ | cedula | char(10) | NO | PRI | NULL | | | nombre1 | char(20) | NO | | NULL | | | nombre2 | char(20) | YES | | NULL | | | apellido1 | char(20) | NO | | NULL | | | apellido2 | char(20) | NO | | NULL | | | direccion | char(15) | NO | | NULL | | | telefono | char(10) | NO | | NULL | | +-----------+----------+------+-----+---------+-------+ 7 rows in set (0.01 sec) mysql> alter table cliente add estado char(20) not null after telefono; Query OK, 0 rows affected (0.08 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> describe cliente; +-----------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+----------+------+-----+---------+-------+ | cedula | char(10) | NO | PRI | NULL | | | nombre1 | char(20) | NO | | NULL | | | nombre2 | char(20) | YES | | NULL | | | apellido1 | char(20) | NO | | NULL | | | apellido2 | char(20) | NO | | NULL | | | direccion | char(15) | NO | | NULL | | | telefono | char(10) | NO | | NULL | | | estado | char(20) | NO | | NULL | | +-----------+----------+------+-----+---------+-------+ 8 rows in set (0.01 sec) mysql> alter table empleado add estado char(20) not null after telefono; Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> describe empleado; +------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+----------+------+-----+---------+-------+ | id | char(10) | NO | PRI | NULL | | | nombre1 | char(20) | NO | | NULL | | | nombre2 | char(20) | YES | | NULL | | | apellido1 | char(20) | NO | | NULL | | | apellido2 | char(20) | NO | | NULL | | | direccion | char(15) | NO | | NULL | | | telefono | char(10) | NO | | NULL | | | estado | char(20) | NO | | NULL | | | cod_perfil | char(5) | NO | MUL | NULL | | +------------+----------+------+-----+---------+-------+ 9 rows in set (0.01 sec) mysql> create procedure eliminarc(in _cedula char(10)) -> delimiter // -> begin -> update cliente set estado='inactivo' where cedula=_cedula; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '//begin update cliente set estado='inactivo' where cedula=_cedula' at line 2 mysql> delimiter // mysql> create procedure eliminarc(in _cedula char(10) -> begin -> update cliente set estado='inactivo' where cedula=_cedula; -> end -> // ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'begin update cliente set estado='inactivo' where cedula=_cedula; end' at line 2 mysql> create procedure eliminarc(in _cedula char(10)) -> begin -> update cliente set estado='inactivo' where cedula=_cedula; -> end -> // Query OK, 0 rows affected (0.04 sec) mysql> show procedure status; -> \c mysql> delimiter ; mysql> show procedure status; +------------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +------------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | final | consultarc | PROCEDURE | root@localhost | 2013-11-21 17:18:17 | 2013-11-21 17:18:17 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | eliminarc | PROCEDURE | root@localhost | 2013-11-21 17:25:05 | 2013-11-21 17:25:05 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertarc | PROCEDURE | root@localhost | 2013-11-21 17:03:48 | 2013-11-21 17:03:48 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertare | PROCEDURE | root@localhost | 2013-11-21 17:06:40 | 2013-11-21 17:06:40 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificarc | PROCEDURE | root@localhost | 2013-11-21 17:12:47 | 2013-11-21 17:12:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | consultaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:22 | 2013-10-22 21:30:22 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | eliminaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:23 | 2013-10-22 21:30:23 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | insertaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:23 | 2013-10-22 21:30:23 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | modificaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:23 | 2013-10-22 21:30:23 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | consultaralumno | PROCEDURE | root@localhost | 2013-10-23 20:25:13 | 2013-10-23 20:25:13 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | eliminaralumno | PROCEDURE | root@localhost | 2013-10-23 20:32:52 | 2013-10-23 20:32:52 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | insertaralumno | PROCEDURE | root@localhost | 2013-10-22 21:52:42 | 2013-10-22 21:52:42 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | modificaralumno | PROCEDURE | root@localhost | 2013-10-23 20:31:09 | 2013-10-23 20:31:09 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | test | test_multi_sets | PROCEDURE | root@localhost | 2010-05-04 05:29:03 | 2010-05-04 05:29:03 | DEFINER | | latin1 | latin1_swedish_ci | latin1_swedish_ci | +------------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 14 rows in set (0.06 sec) mysql> create procedure consultare(in _id char(10), in _nombre1 char(20), in _nombre2 char(20), in _apellido1 char(20), in _apellido2 char(20), in _direccion char(15), in _telefono char(10), in _cod_perfil char(5), in _estado char(20)) -> begin -> select cedula,nombre1,nombre2,apellido1,apellido2,direccion,telefono,estado,cod_perfil from empleado where cedula=_cedula && estado='activo'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 mysql> delimiter // mysql> create procedure consultare(in _id char(10), in _nombre1 char(20), in _nombre2 char(20), in _apellido1 char(20), in _apellido2 char(20), in _direccion char(15), in _telefono char(10), in _cod_perfil char(5), in _estado char(20)) -> begin -> select cedula,nombre1,nombre2,apellido1,apellido2,direccion,telefono,estado,cod_perfil from empleado where cedula=_cedula && estado='activo'; -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> create procedure modificare(in _id char(10), in _nombre1 char(20), in _nombre2 char(20), in _apellido1 char(20), in _apellido2 char(20), in _direccion char(15), in _telefono char(10), in _estado char(20), in _cod_perfil char(5)) -> begin -> update empleado set nombre1=_nombre1, nombre2=_nombre2, apellido1=_apellido2, direccion=_direccion, telefono=_telefono, estado=_estado, cod_perfil=_cod_perfil where cedula=_cedula; -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> show procedure status; +------------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +------------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | final | consultarc | PROCEDURE | root@localhost | 2013-11-21 17:18:17 | 2013-11-21 17:18:17 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultare | PROCEDURE | root@localhost | 2013-11-21 17:28:56 | 2013-11-21 17:28:56 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | eliminarc | PROCEDURE | root@localhost | 2013-11-21 17:25:05 | 2013-11-21 17:25:05 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertarc | PROCEDURE | root@localhost | 2013-11-21 17:03:48 | 2013-11-21 17:03:48 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertare | PROCEDURE | root@localhost | 2013-11-21 17:06:40 | 2013-11-21 17:06:40 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificarc | PROCEDURE | root@localhost | 2013-11-21 17:12:47 | 2013-11-21 17:12:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificare | PROCEDURE | root@localhost | 2013-11-21 17:31:37 | 2013-11-21 17:31:37 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | consultaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:22 | 2013-10-22 21:30:22 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | eliminaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:23 | 2013-10-22 21:30:23 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | insertaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:23 | 2013-10-22 21:30:23 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | modificaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:23 | 2013-10-22 21:30:23 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | consultaralumno | PROCEDURE | root@localhost | 2013-10-23 20:25:13 | 2013-10-23 20:25:13 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | eliminaralumno | PROCEDURE | root@localhost | 2013-10-23 20:32:52 | 2013-10-23 20:32:52 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | insertaralumno | PROCEDURE | root@localhost | 2013-10-22 21:52:42 | 2013-10-22 21:52:42 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | modificaralumno | PROCEDURE | root@localhost | 2013-10-23 20:31:09 | 2013-10-23 20:31:09 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | test | test_multi_sets | PROCEDURE | root@localhost | 2010-05-04 05:29:03 | 2010-05-04 05:29:03 | DEFINER | | latin1 | latin1_swedish_ci | latin1_swedish_ci | +------------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 16 rows in set (0.01 sec) mysql> delimiter // mysql> create procedure eliminare(in _id char(10)) -> begin -> update empleado set estado='inactivo' where id=_id; -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> show tables; +-------------------+ | Tables_in_final | +-------------------+ | cliente | | compra | | detalle_compra | | detalle_domicilio | | detalle_factura | | detalle_pedido | | domicilio | | empleado | | factura | | pedido | | perfil | | producto | | proveedor | | supermercado | +-------------------+ 14 rows in set (0.00 sec) mysql> describe compra; +------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+----------+------+-----+---------+-------+ | cod_compra | char(10) | NO | PRI | NULL | | | fecha | date | NO | | NULL | | | hora | char(9) | NO | | NULL | | | nit | char(10) | NO | MUL | NULL | | +------------+----------+------+-----+---------+-------+ 4 rows in set (0.07 sec) mysql> delimiter // mysql> create procedure insertarcompra(in _cod_compra char(10), in _fecha date, in _hora char(9), in _nit char(10)) -> begin -> insert into compra(cod_compra, fecha,hora,nit) values (_cod_compra, _fecha, _hora, _nit); -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> create procedure consultarcompra(in _cod_compra char(10), in _fecha date, in _hora char(9), in _nit char(10)) -> begin -> select fecha, hora, nit from compra where cod_compra=_cod_compra; -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> describe factura; +-------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+----------+------+-----+---------+-------+ | cod_factura | char(10) | NO | PRI | NULL | | | fecha | date | NO | | NULL | | | hora | char(9) | NO | | NULL | | | neto | float | NO | | NULL | | | id | char(10) | NO | MUL | NULL | | | cedula | char(10) | NO | MUL | NULL | | +-------------+----------+------+-----+---------+-------+ 6 rows in set (0.04 sec) mysql> delimiter // mysql> create procedure crearf(in _cod_factura char(10), in _ fecha date, in _hora char(9), in _neto float(11), in _id char(10), in _cedula char(10)) -> begin -> insert into factura(cod_factura, fecha, hora, neto, id, cedula) values (_cod_factura, _fecha, _hora, _neto, _id, _cedula); -> end -> // ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fecha date, in _hora char(9), in _neto float(11), in _id char(10), in _cedula ch' at line 1 mysql> create procedure crearf(in _cod_factura char(10), in _fecha date, in _hora char(9), in _neto float(11), in _id char(10), in _cedula char(10)) -> begin -> insert into factura(cod_factura, fecha, hora, neto, id, cedula) values (_cod_factura, _fecha, _hora, _neto, _id, _cedula); -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> create procedure consultarf(in _cod_factura char(10), in _fecha date, in _hora char(9), in _neto float(11), in _id char(10), in _cedula char(10)) -> begin -> select fecha, hora, neto, id, cedula from factura where cod_factura=_cod_factura; -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> show tables; +-------------------+ | Tables_in_final | +-------------------+ | cliente | | compra | | detalle_compra | | detalle_domicilio | | detalle_factura | | detalle_pedido | | domicilio | | empleado | | factura | | pedido | | perfil | | producto | | proveedor | | supermercado | +-------------------+ 14 rows in set (0.00 sec) mysql> describe perfil; +-------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+----------+------+-----+---------+-------+ | cod_perfil | char(5) | NO | PRI | NULL | | | cargo | char(20) | NO | | NULL | | | descripcion | char(70) | YES | | NULL | | +-------------+----------+------+-----+---------+-------+ 3 rows in set (0.07 sec) mysql> delimiter // mysql> create procedure crearp(in _cod_perfil char(5), in _cargo char(20), in _descripcion char(70)) -> begin -> insert into perfil(cod_perfil, cargo, descripcion) values (_cod_perfil, _cargo, _descripcion); -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> create procedure modificarc(in _cod_perfil char(5), in _cargo char(20), in _descripcion char(70)) -> begin -> update perfil set cargo=_cargo, descripcion=_descripcion where cod_perfil=_cod_perfil; -> end -> // ERROR 1304 (42000): PROCEDURE modificarc already exists mysql> create procedure modificarcargo(in _cod_perfil char(5), in _cargo char(20), in _descripcion char(70)) -> update perfil set cargo=_cargo, descripcion=_descripcion where cod_perfil=_cod_perfil; -> end -> // Query OK, 0 rows affected (0.00 sec) ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'end' at line 1 mysql> delimiter ; mysql> show procedure status; +------------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +------------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | final | consultarc | PROCEDURE | root@localhost | 2013-11-21 17:18:17 | 2013-11-21 17:18:17 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarcompra | PROCEDURE | root@localhost | 2013-11-21 17:38:30 | 2013-11-21 17:38:30 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultare | PROCEDURE | root@localhost | 2013-11-21 17:28:56 | 2013-11-21 17:28:56 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarf | PROCEDURE | root@localhost | 2013-11-21 17:43:12 | 2013-11-21 17:43:12 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | crearf | PROCEDURE | root@localhost | 2013-11-21 17:41:26 | 2013-11-21 17:41:26 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | crearp | PROCEDURE | root@localhost | 2013-11-21 17:44:46 | 2013-11-21 17:44:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | eliminarc | PROCEDURE | root@localhost | 2013-11-21 17:25:05 | 2013-11-21 17:25:05 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | eliminare | PROCEDURE | root@localhost | 2013-11-21 17:32:55 | 2013-11-21 17:32:55 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertarc | PROCEDURE | root@localhost | 2013-11-21 17:03:48 | 2013-11-21 17:03:48 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertarcompra | PROCEDURE | root@localhost | 2013-11-21 17:34:54 | 2013-11-21 17:34:54 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertare | PROCEDURE | root@localhost | 2013-11-21 17:06:40 | 2013-11-21 17:06:40 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificarc | PROCEDURE | root@localhost | 2013-11-21 17:12:47 | 2013-11-21 17:12:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificarcargo | PROCEDURE | root@localhost | 2013-11-21 17:46:31 | 2013-11-21 17:46:31 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificare | PROCEDURE | root@localhost | 2013-11-21 17:31:37 | 2013-11-21 17:31:37 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | consultaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:22 | 2013-10-22 21:30:22 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | eliminaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:23 | 2013-10-22 21:30:23 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | insertaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:23 | 2013-10-22 21:30:23 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | modificaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:23 | 2013-10-22 21:30:23 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | consultaralumno | PROCEDURE | root@localhost | 2013-10-23 20:25:13 | 2013-10-23 20:25:13 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | eliminaralumno | PROCEDURE | root@localhost | 2013-10-23 20:32:52 | 2013-10-23 20:32:52 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | insertaralumno | PROCEDURE | root@localhost | 2013-10-22 21:52:42 | 2013-10-22 21:52:42 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | modificaralumno | PROCEDURE | root@localhost | 2013-10-23 20:31:09 | 2013-10-23 20:31:09 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | test | test_multi_sets | PROCEDURE | root@localhost | 2010-05-04 05:29:03 | 2010-05-04 05:29:03 | DEFINER | | latin1 | latin1_swedish_ci | latin1_swedish_ci | +------------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 23 rows in set (0.01 sec) mysql> show tables; +-------------------+ | Tables_in_final | +-------------------+ | cliente | | compra | | detalle_compra | | detalle_domicilio | | detalle_factura | | detalle_pedido | | domicilio | | empleado | | factura | | pedido | | perfil | | producto | | proveedor | | supermercado | +-------------------+ 14 rows in set (0.00 sec) mysql> describe pedido; +---------------+----------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+----------+------+-----+---------+----------------+ | cod_pedido | int(11) | NO | PRI | NULL | auto_increment | | fecha | date | NO | | NULL | | | hora | char(9) | NO | | NULL | | | cod_proveedor | char(10) | NO | MUL | NULL | | +---------------+----------+------+-----+---------+----------------+ 4 rows in set (0.12 sec) mysql> delimiter // mysql> create procedure crearpedido(in _cod_pedido auto_increment, in _fecha date, in _hora, in _cod_proveedor char(10)) -> begin -> // ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'auto_increment, in _fecha date, in _hora, in _cod_proveedor char(10)) begin' at line 1 mysql> create procedure crearpedido(in _fecha date, in_hora char(9), in _cod_proveedor char(10)) -> begin -> insert into pedido(fecha, hora, cod_proveedor) values (_fecha, _hora, _cod_proveedor); -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> create procedure modificarpedido(in _cod_pedido int auto_increment, in _fecha date, in _hora char(9), in _cod_proveedor char(10)) -> begin -> select fecha, hora, cod_proveedor from pedido where cod_pedido=_cod_pedido; -> end -> // ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'auto_increment, in _fecha date, in _hora char(9), in _cod_proveedor char(10)) be' at line 1 mysql> create procedure modificarpedido(in _cod_pedido int(11), in _fecha date, in _hora char(9), in _cod_proveedor char(10)) -> select fecha, hora, cod_proveedor from pedido where cod_pedido=_cod_pedido; -> end -> // Query OK, 0 rows affected (0.00 sec) ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'end' at line 1 mysql> create procedure modificarpedido(in _cod_pedido int(11), in _fecha date, in _hora char(9), in _cod_proveedor char(10)) -> begin -> select fecha, hora, cod_proveedor from pedido where cod_pedido=_cod_pedido; -> end -> // ERROR 1304 (42000): PROCEDURE modificarpedido already exists mysql> create procedure consultarpedido(in _cod_pedido int(11), in _fecha date, in _hora char(9), in _cod_proveedor char(10)) -> begin -> update pedido set fecha=_fecha, hora=_hora, cod_proveedor=_cod_proveedor where cod_pedido=_cod_pedido; -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> show tables; +-------------------+ | Tables_in_final | +-------------------+ | cliente | | compra | | detalle_compra | | detalle_domicilio | | detalle_factura | | detalle_pedido | | domicilio | | empleado | | factura | | pedido | | perfil | | producto | | proveedor | | supermercado | +-------------------+ 14 rows in set (0.00 sec) mysql> show procedure status; +------------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +------------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | final | consultarc | PROCEDURE | root@localhost | 2013-11-21 17:18:17 | 2013-11-21 17:18:17 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarcompra | PROCEDURE | root@localhost | 2013-11-21 17:38:30 | 2013-11-21 17:38:30 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultare | PROCEDURE | root@localhost | 2013-11-21 17:28:56 | 2013-11-21 17:28:56 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarf | PROCEDURE | root@localhost | 2013-11-21 17:43:12 | 2013-11-21 17:43:12 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarpedido | PROCEDURE | root@localhost | 2013-11-21 17:59:22 | 2013-11-21 17:59:22 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | crearf | PROCEDURE | root@localhost | 2013-11-21 17:41:26 | 2013-11-21 17:41:26 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | crearp | PROCEDURE | root@localhost | 2013-11-21 17:44:46 | 2013-11-21 17:44:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | crearpedido | PROCEDURE | root@localhost | 2013-11-21 17:50:56 | 2013-11-21 17:50:56 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | eliminarc | PROCEDURE | root@localhost | 2013-11-21 17:25:05 | 2013-11-21 17:25:05 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | eliminare | PROCEDURE | root@localhost | 2013-11-21 17:32:55 | 2013-11-21 17:32:55 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertarc | PROCEDURE | root@localhost | 2013-11-21 17:03:48 | 2013-11-21 17:03:48 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertarcompra | PROCEDURE | root@localhost | 2013-11-21 17:34:54 | 2013-11-21 17:34:54 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertare | PROCEDURE | root@localhost | 2013-11-21 17:06:40 | 2013-11-21 17:06:40 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificarc | PROCEDURE | root@localhost | 2013-11-21 17:12:47 | 2013-11-21 17:12:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificarcargo | PROCEDURE | root@localhost | 2013-11-21 17:46:31 | 2013-11-21 17:46:31 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificare | PROCEDURE | root@localhost | 2013-11-21 17:31:37 | 2013-11-21 17:31:37 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificarpedido | PROCEDURE | root@localhost | 2013-11-21 17:53:03 | 2013-11-21 17:53:03 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | consultaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:22 | 2013-10-22 21:30:22 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | eliminaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:23 | 2013-10-22 21:30:23 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | insertaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:23 | 2013-10-22 21:30:23 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | modificaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:23 | 2013-10-22 21:30:23 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | consultaralumno | PROCEDURE | root@localhost | 2013-10-23 20:25:13 | 2013-10-23 20:25:13 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | eliminaralumno | PROCEDURE | root@localhost | 2013-10-23 20:32:52 | 2013-10-23 20:32:52 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | insertaralumno | PROCEDURE | root@localhost | 2013-10-22 21:52:42 | 2013-10-22 21:52:42 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | modificaralumno | PROCEDURE | root@localhost | 2013-10-23 20:31:09 | 2013-10-23 20:31:09 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | test | test_multi_sets | PROCEDURE | root@localhost | 2010-05-04 05:29:03 | 2010-05-04 05:29:03 | DEFINER | | latin1 | latin1_swedish_ci | latin1_swedish_ci | +------------+-----------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 26 rows in set (0.01 sec) mysql> describe domicilio; +---------------+----------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+----------+------+-----+---------+----------------+ | cod_domicilio | int(11) | NO | PRI | NULL | auto_increment | | fecha | date | NO | | NULL | | | hora | char(9) | NO | | NULL | | | descripcion | char(30) | YES | | NULL | | +---------------+----------+------+-----+---------+----------------+ 4 rows in set (0.61 sec) mysql> delimiter // mysql> create procedure creardomicilio(in _cod_domicilio int(11), in _fecha date, in _hora char(9), in _descripcion char(30)) -> begin -> insert into domicilio(cod_domicilio,fecha,hora,descripcion) values (_cod_docimicilio, _fecha, _hora, _descripcion); -> end -> // Query OK, 0 rows affected (0.15 sec) mysql> create procedure modificardomicilio(in _cod_domicilio int(11), in _fecha date, in _hora char(9), in _descripcion char(30)) -> begin -> update domicilio set fecha=_fecha, hora=_hora, descripcion=_descripcion where cod_domicilio=_cod_domicilio; -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> create procedure consultardomicilio(in _cod_domicilio in(11)) -> begin -> select fecha, hora, descripcion from domicilio where cod_domicilio=_cod_domicilio; -> end -> // ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'in(11)) begin select fecha, hora, descripcion from domicilio where cod_domicilio' at line 1 mysql> create procedure consultardomicilio(in _cod_domicilio int(11)) -> begin -> select fecha, hora, descripcion from domicilio where cod_domicilio=_cod_domicilio; -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> describe proveedor; +---------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+----------+------+-----+---------+-------+ | cod_proveedor | char(10) | NO | PRI | NULL | | | nombre | char(20) | NO | | NULL | | | direccion | char(15) | NO | | NULL | | | telefono | char(10) | NO | | NULL | | +---------------+----------+------+-----+---------+-------+ 4 rows in set (0.12 sec) mysql> delimiter // mysql> create procedure insertarproveedor(in _cod_proveedor char(10), in _nombre char(20), in _direccion char(15), in _telefono char(10)) -> begin -> insert into proveedor(cod_proveedor, nombre, direccion, telefono) values (_cod_proveedor, _nombre, direccion, _telefono); -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> create procedure modificarproveedor(in _cod_proveedor char(10), in _nombre char(20), in _direccion char(15), in _telefono char(10)) -> begin -> update proveedor set nombre=_nombre, direccion=_direccion, telefono=_telefono where cod_proveedor=_cod_proveedor; -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> create procedure consultarproveedor(in _cod_proveedor char(10)) -> begin -> select nombre, direccion, telefono from proveedor where cod_proveedor=_cod_proveedor; -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> describe supermercado; +-----------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+----------+------+-----+---------+-------+ | nit | char(10) | NO | PRI | NULL | | | nombre | char(20) | NO | | NULL | | | direccion | char(15) | NO | | NULL | | | telefono | char(10) | NO | | NULL | | +-----------+----------+------+-----+---------+-------+ 4 rows in set (0.12 sec) mysql> delimiter // mysql> create procedure insertarsuper(in _nit char(10), _nombre char(20), _direccion char(15), _telefono char(10)) -> begin -> insert into supermercado(nit, nombre, direccion, telefono) values (_nit, _nombre, _direccion, _telefono); -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> create procedure consultarsuper(in _nit char(10)) -> begin -> select nombre, direccion, telefono from supermercado where nit=_nit; -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> describe detalle_compra; +--------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+----------+------+-----+---------+-------+ | cod_compra | char(10) | NO | MUL | NULL | | | cod_producto | char(5) | NO | MUL | NULL | | | descripcion | char(60) | YES | | NULL | | +--------------+----------+------+-----+---------+-------+ 3 rows in set (0.13 sec) mysql> delimiter // mysql> create procedure insertardetallecompra(in _cod_compra char(10), in _cod_producto char(5), in _descripcion char(60)) -> begin -> insert into detalle_compra(cod_compra, cod_producto, descripcion ) values (_cod_compra, _cod_producto, _descripcion); -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> exit; -> \c mysql> delimiter ; mysql> exit; mysql> delimiter // mysql> create procedure insertarproducto(in _cod_producto char(5), in _nombre char(20), in _cantidad int(3), in _costo float(8)) -> begin -> insert into producto(cod_producto, nombre, cantidad, costo) values (_cod_producto, _nombre, _cantidad, _costo); -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> create procedure modificarproducto(in _cod_producto char(5), in _nombre char(20), in _cantidad int(3), in _costo float(8)) -> begin -> update producto set nombre=_nombre, cantidad=_cantidad, costo=_costo where cod_producto=_cod_producto; -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> create procedure consultar producto(in _cod_producto char(5)) -> begin -> select nombre, cantidad, costo from producto where cod_producto=_cod_producto; -> end -> // ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'producto(in _cod_producto char(5)) begin select nombre, cantidad, costo from pro' at line 1 mysql> create procedure consultarproducto(in _cod_producto char(5)) -> begon -> // ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2 mysql> create procedure consultarproducto(in _cod_producto char(5)) -> begin -> select nombre,cantidad,costo from producto where cod_producto=_cod_producto; -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> delete from producto where cod_producto='A01'; Query OK, 0 rows affected (0.04 sec) mysql> select * from producto; +--------------+--------+----------+-------+ | cod_producto | nombre | cantidad | costo | +--------------+--------+----------+-------+ | AZ01 | Arroz | 100 | 1250 | +--------------+--------+----------+-------+ 1 row in set (0.00 sec) mysql> select * from producto; +--------------+--------+----------+-------+ | cod_producto | nombre | cantidad | costo | +--------------+--------+----------+-------+ | AZ01 | Arroz | 100 | 1300 | +--------------+--------+----------+-------+ 1 row in set (0.00 sec) mysql> describe perfil; +-------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+----------+------+-----+---------+-------+ | cod_perfil | char(5) | NO | PRI | NULL | | | cargo | char(20) | NO | | NULL | | | descripcion | char(70) | YES | | NULL | | +-------------+----------+------+-----+---------+-------+ 3 rows in set (0.04 sec) mysql> describe empleado; +------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+----------+------+-----+---------+-------+ | id | char(10) | NO | PRI | NULL | | | nombre1 | char(20) | NO | | NULL | | | nombre2 | char(20) | YES | | NULL | | | apellido1 | char(20) | NO | | NULL | | | apellido2 | char(20) | NO | | NULL | | | direccion | char(15) | NO | | NULL | | | telefono | char(10) | NO | | NULL | | | estado | char(20) | NO | | NULL | | | cod_perfil | char(5) | NO | MUL | NULL | | +------------+----------+------+-----+---------+-------+ 9 rows in set (0.02 sec) mysql> call insertare('12345','asdas','asdad','asdad','asdad','aasdad','asdasd','asdasd','asdas'); ERROR 1318 (42000): Incorrect number of arguments for PROCEDURE final.insertare; expected 8, got 9 mysql> drop procedure insertare; Query OK, 0 rows affected (0.04 sec) mysql> delimiter // mysql> create procedure insertare(in _id char(10), in _nombre1 char(20), in _nombre2 char(20), in _apellido1 char(20), in _apellido2 char(20), in _direccion char(15), in _telefono char(10), in _estado char(20), in _cod_perfil char(20)) -> begin -> insert into empleado(id,nombre1,nombre2,apellido1,apellido2,direccion,telefono,estado,cod_perfil) values (_id, _nombre1, _nombre2, _apellido1, _apellido2, _direccion, _telefono, _estado, _cod_perfil); -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> call insertare('asda','asdad','asdasd','asdasd','asdasd','sadasd','dasda','dasdad','asdasd'); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`final`.`empleado`, CONSTRAINT `empleado_ibfk_1` FOREIGN KEY (`cod_perfil`) REFERENCES `perfil` (`cod_perfil`) ON DELETE CASCADE ON UPDATE CASCADE) mysql> call crearp('adas','asdad','asdasdsad'); Query OK, 1 row affected (0.08 sec) mysql> select * from perfil; +------------+-------+-------------+ | cod_perfil | cargo | descripcion | +------------+-------+-------------+ | adas | asdad | asdasdsad | +------------+-------+-------------+ 1 row in set (0.00 sec) mysql> call consultarp('adas'); ERROR 1305 (42000): PROCEDURE final.consultarp does not exist mysql> call consultarc('adas'); Empty set (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql> delimiter // mysql> create procedure consultarperfil(in _cod_perfil char(5)) -> begin -> select cargo,descripcion from perfil where cod_perfil=_cod_perfil; -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> delete from perfil where cod_perfil='adas'; -> // Query OK, 1 row affected (0.04 sec) mysql> delimiter ; mysql> select * from perfil; Empty set (0.00 sec) mysql> select * from cargo; ERROR 1146 (42S02): Table 'final.cargo' doesn't exist mysql> select * from perfil; +------------+--------+-------------------+ | cod_perfil | cargo | descripcion | +------------+--------+-------------------+ | CAR01 | Cajero | Encargado de caja | +------------+--------+-------------------+ 1 row in set (0.00 sec) mysql> delete from perfil; Query OK, 1 row affected (0.00 sec) mysql> select * from perfil; Empty set (0.00 sec) mysql> delimiter // mysql> create procedure llevarcargo(in _cod_perfil char(5)) -> begin -> update empleado set cod_perfil=(select cod_perfil from perfil); -> end -> // Query OK, 0 rows affected (0.03 sec) mysql> call llevarcargo(CAR01); -> // ERROR 1054 (42S22): Unknown column 'CAR01' in 'field list' mysql> call llevarcargo('CAR01'); -> // Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> select * from cliente; +----------+---------+----------+-----------+-----------+-----------+----------+--------+ | cedula | nombre1 | nombre2 | apellido1 | apellido2 | direccion | telefono | estado | +----------+---------+----------+-----------+-----------+-----------+----------+--------+ | 15512675 | Luis | Fernando | Garcia | Pati¤o | Rionegro | 6147089 | Activo | | 39448559 | Diana | Milena | Pati¤o | Ramirez | Medellin | 6147089 | Activo | +----------+---------+----------+-----------+-----------+-----------+----------+--------+ 2 rows in set (0.00 sec) mysql> select * from empleado; Empty set (0.00 sec) mysql> select * from perfil; +------------+--------+------------------------------+ | cod_perfil | cargo | descripcion | +------------+--------+------------------------------+ | CAR01 | Cajero | Encargado de manejar la caja | +------------+--------+------------------------------+ 1 row in set (0.00 sec) mysql> show procedure status; +------------+-----------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +------------+-----------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | final | consultarc | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarcompra | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultardomicilio | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultare | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarf | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarpedido | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarperfil | PROCEDURE | root@localhost | 2013-11-22 14:11:10 | 2013-11-22 14:11:10 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarproducto | PROCEDURE | root@localhost | 2013-11-22 12:49:15 | 2013-11-22 12:49:15 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarproveedor | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarsuper | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | creardomicilio | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | crearf | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | crearp | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | crearpedido | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | eliminarc | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | eliminare | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertarc | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertarcompra | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertardetallecompra | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertare | PROCEDURE | root@localhost | 2013-11-22 13:40:41 | 2013-11-22 13:40:41 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertarproducto | PROCEDURE | root@localhost | 2013-11-22 12:45:20 | 2013-11-22 12:45:20 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertarproveedor | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertarsuper | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | llevarcargo | PROCEDURE | root@localhost | 2013-11-22 14:35:47 | 2013-11-22 14:35:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificarc | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificarcargo | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificardomicilio | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificare | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificarpedido | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificarproducto | PROCEDURE | root@localhost | 2013-11-22 12:47:13 | 2013-11-22 12:47:13 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificarproveedor | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula | consultar_carrera | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | consultar_estudiante | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | consultar_materia | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | consultar_usuario | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula | eliminar_carrera | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | eliminar_estudiante | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | eliminar_materia | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | eliminar_usuario | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula | insertar_carrera | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | insertar_estudiante | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | insertar_materia | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | insertar_usuario | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula | modificar_carrera | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | modificar_estudiante | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | modificar_materia | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | modificar_usuario | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | validar_password | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | consultaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:22 | 2013-10-22 21:30:22 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | eliminaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:23 | 2013-10-22 21:30:23 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | insertaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:23 | 2013-10-22 21:30:23 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | modificaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:23 | 2013-10-22 21:30:23 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | consultaralumno | PROCEDURE | root@localhost | 2013-10-23 20:25:13 | 2013-10-23 20:25:13 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | eliminaralumno | PROCEDURE | root@localhost | 2013-10-23 20:32:52 | 2013-10-23 20:32:52 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | insertaralumno | PROCEDURE | root@localhost | 2013-10-22 21:52:42 | 2013-10-22 21:52:42 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | modificaralumno | PROCEDURE | root@localhost | 2013-10-23 20:31:09 | 2013-10-23 20:31:09 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | test | test_multi_sets | PROCEDURE | root@localhost | 2010-05-04 05:29:03 | 2010-05-04 05:29:03 | DEFINER | | latin1 | latin1_swedish_ci | latin1_swedish_ci | +------------+-----------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 57 rows in set (0.09 sec) mysql> describe perfil; +-------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+----------+------+-----+---------+-------+ | cod_perfil | char(5) | NO | PRI | NULL | | | cargo | char(20) | NO | | NULL | | | descripcion | char(70) | YES | | NULL | | +-------------+----------+------+-----+---------+-------+ 3 rows in set (0.05 sec) mysql> select * from perfil; +------------+--------+------------------------------+ | cod_perfil | cargo | descripcion | +------------+--------+------------------------------+ | CAR01 | Cajero | Encargado de manejar la caja | +------------+--------+------------------------------+ 1 row in set (0.00 sec) mysql> drop procedure consultare; Query OK, 0 rows affected (0.06 sec) mysql> delimiter // mysql> describe empleado; -> // +------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+----------+------+-----+---------+-------+ | id | char(10) | NO | PRI | NULL | | | nombre1 | char(20) | NO | | NULL | | | nombre2 | char(20) | YES | | NULL | | | apellido1 | char(20) | NO | | NULL | | | apellido2 | char(20) | NO | | NULL | | | direccion | char(15) | NO | | NULL | | | telefono | char(10) | NO | | NULL | | | estado | char(20) | NO | | NULL | | | cod_perfil | char(5) | NO | MUL | NULL | | +------------+----------+------+-----+---------+-------+ 9 rows in set (0.01 sec) mysql> create procedure consultare(in _id char(10)) -> begin -> select nombre1,nombre2,apellido1,apellido2,direccion,telefono,estado from empleado where id=_id; -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> select * from empleado; -> // +-------+----------+---------+-----------+-----------+-----------+----------+--------+------------+ | id | nombre1 | nombre2 | apellido1 | apellido2 | direccion | telefono | estado | cod_perfil | +-------+----------+---------+-----------+-----------+-----------+----------+--------+------------+ | VEN01 | Santiago | | Garcia | Pati¤o | Rionegro | 6147089 | Activo | CAR01 | +-------+----------+---------+-----------+-----------+-----------+----------+--------+------------+ 1 row in set (0.00 sec) mysql> delete from empleado; -> // Query OK, 1 row affected (0.15 sec) mysql> delimiter ; mysql> delete from empleado; Query OK, 1 row affected (0.02 sec) mysql> select * from empleado; +-------+----------+---------+-----------+-----------+-----------+----------+--------+------------+ | id | nombre1 | nombre2 | apellido1 | apellido2 | direccion | telefono | estado | cod_perfil | +-------+----------+---------+-----------+-----------+-----------+----------+--------+------------+ | VEN01 | Santiago | | Garcia | Pati¤o | Medellin | 5612512 | Activo | CAR01 | +-------+----------+---------+-----------+-----------+-----------+----------+--------+------------+ 1 row in set (0.00 sec) mysql> select * from perfil; +------------+---------------+------------------------------+ | cod_perfil | cargo | descripcion | +------------+---------------+------------------------------+ | CAR01 | Cajero | Encargado de manejar la caja | | CAR02 | Secretario(a) | Administrativo | +------------+---------------+------------------------------+ 2 rows in set (0.00 sec) mysql> select * from empelado; ERROR 1146 (42S02): Table 'final.empelado' doesn't exist mysql> select * from empleado; +-------+----------+---------+-----------+-----------+-----------+----------+--------+------------+ | id | nombre1 | nombre2 | apellido1 | apellido2 | direccion | telefono | estado | cod_perfil | +-------+----------+---------+-----------+-----------+-----------+----------+--------+------------+ | SEC01 | Diana | Milena | Pati¤o | Ramirez | Rionegro | 6148089 | Activo | CAR02 | | VEN01 | Santiago | | Garcia | Pati¤o | Medellin | 5612512 | Activo | CAR01 | +-------+----------+---------+-----------+-----------+-----------+----------+--------+------------+ 2 rows in set (0.00 sec) mysql> drop procedure consultare; Query OK, 0 rows affected (0.04 sec) mysql> delimiter // mysql> create procedure consultare(in _id char(10)) -> begin -> select nombre1,nombre2,apellido1,apellido2,direccion,telefono,estado,cod_perfil from empleado where id=_id; -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> describe proveedor; -> // +---------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+----------+------+-----+---------+-------+ | cod_proveedor | char(10) | NO | PRI | NULL | | | nombre | char(20) | NO | | NULL | | | direccion | char(15) | NO | | NULL | | | telefono | char(10) | NO | | NULL | | +---------------+----------+------+-----+---------+-------+ 4 rows in set (0.11 sec) mysql> delimiter // mysql> delimiter ; mysql> show procedure status; +------------+-----------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +------------+-----------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | final | consultarc | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarcompra | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultardomicilio | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultare | PROCEDURE | root@localhost | 2013-11-22 16:10:31 | 2013-11-22 16:10:31 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarf | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarpedido | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarperfil | PROCEDURE | root@localhost | 2013-11-22 14:11:10 | 2013-11-22 14:11:10 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarproducto | PROCEDURE | root@localhost | 2013-11-22 12:49:15 | 2013-11-22 12:49:15 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarproveedor | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarsuper | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | creardomicilio | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | crearf | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | crearp | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | crearpedido | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | eliminarc | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | eliminare | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertarc | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertarcompra | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertardetallecompra | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertare | PROCEDURE | root@localhost | 2013-11-22 13:40:41 | 2013-11-22 13:40:41 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertarproducto | PROCEDURE | root@localhost | 2013-11-22 12:45:20 | 2013-11-22 12:45:20 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertarproveedor | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertarsuper | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | llevarcargo | PROCEDURE | root@localhost | 2013-11-22 14:35:47 | 2013-11-22 14:35:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificarc | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificarcargo | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificardomicilio | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificare | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificarpedido | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificarproducto | PROCEDURE | root@localhost | 2013-11-22 12:47:13 | 2013-11-22 12:47:13 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificarproveedor | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula | consultar_carrera | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | consultar_estudiante | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | consultar_materia | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | consultar_usuario | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula | eliminar_carrera | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | eliminar_estudiante | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | eliminar_materia | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | eliminar_usuario | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula | insertar_carrera | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | insertar_estudiante | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | insertar_materia | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | insertar_usuario | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula | modificar_carrera | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | modificar_estudiante | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | modificar_materia | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | modificar_usuario | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | validar_password | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | consultaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:22 | 2013-10-22 21:30:22 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | eliminaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:23 | 2013-10-22 21:30:23 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | insertaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:23 | 2013-10-22 21:30:23 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | modificaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:23 | 2013-10-22 21:30:23 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | consultaralumno | PROCEDURE | root@localhost | 2013-10-23 20:25:13 | 2013-10-23 20:25:13 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | eliminaralumno | PROCEDURE | root@localhost | 2013-10-23 20:32:52 | 2013-10-23 20:32:52 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | insertaralumno | PROCEDURE | root@localhost | 2013-10-22 21:52:42 | 2013-10-22 21:52:42 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | modificaralumno | PROCEDURE | root@localhost | 2013-10-23 20:31:09 | 2013-10-23 20:31:09 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | test | test_multi_sets | PROCEDURE | root@localhost | 2010-05-04 05:29:03 | 2010-05-04 05:29:03 | DEFINER | | latin1 | latin1_swedish_ci | latin1_swedish_ci | +------------+-----------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 57 rows in set (0.01 sec) mysql> delimiter // mysql> delimiter ; mysql> alter table proveedor add estado char(20) not null after telefono; Query OK, 0 rows affected (0.28 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> describe proveedor -> ; +---------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+----------+------+-----+---------+-------+ | cod_proveedor | char(10) | NO | PRI | NULL | | | nombre | char(20) | NO | | NULL | | | direccion | char(15) | NO | | NULL | | | telefono | char(10) | NO | | NULL | | | estado | char(20) | NO | | NULL | | +---------------+----------+------+-----+---------+-------+ 5 rows in set (0.02 sec) mysql> delimiter // mysql> create procedure eliminarproveedor(in _cod_proveedor char(10)) -> begin -> update proveedor set estado='Inactivo' where cod_proveedor=_cod_proveedor; -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> drop provedure insertarproveedor; -> // ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'provedure insertarproveedor' at line 1 mysql> drop procedure insertarproveedor; -> // Query OK, 0 rows affected (0.06 sec) mysql> create procedure insertarproveedor(in _cod_proveedor char(10), in _nombre char(20), in _direccion char(15), in _telefono char(10), in _estado char(20)) -> begin -> insert into proveedor(cod_proveedor,nombre,direccion,telefono,estado) values (_cod_proveedor, _nombre, _direccion, _telefono, _estado); -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> select * from proveedor; -> // +---------------+------------+-----------+----------+--------+ | cod_proveedor | nombre | direccion | telefono | estado | +---------------+------------+-----------+----------+--------+ | PROV01 | Fritolight | Medellin | 3456789 | Activo | +---------------+------------+-----------+----------+--------+ 1 row in set (0.00 sec) mysql> drop procedure consultarproveedor; -> // Query OK, 0 rows affected (0.04 sec) mysql> create procedure consultarproveedor(in _cod_proveedor char(10)) -> begin -> select nombre,direccion,telefono,estado from proveedor where cod_proveedor=_cod_proveedor; -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> update proveedor set estado='Activo'; -> // Query OK, 1 row affected (0.02 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> select * from domicilio; -> // Empty set (0.07 sec) mysql> describe domicilio; -> // +---------------+----------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+----------+------+-----+---------+----------------+ | cod_domicilio | int(11) | NO | PRI | NULL | auto_increment | | fecha | date | NO | | NULL | | | hora | char(9) | NO | | NULL | | | descripcion | char(30) | YES | | NULL | | +---------------+----------+------+-----+---------+----------------+ 4 rows in set (0.01 sec) mysql> describe cliente; -> // +-----------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+----------+------+-----+---------+-------+ | cedula | char(10) | NO | PRI | NULL | | | nombre1 | char(20) | NO | | NULL | | | nombre2 | char(20) | YES | | NULL | | | apellido1 | char(20) | NO | | NULL | | | apellido2 | char(20) | NO | | NULL | | | direccion | char(15) | NO | | NULL | | | telefono | char(10) | NO | | NULL | | | estado | char(20) | NO | | NULL | | +-----------+----------+------+-----+---------+-------+ 8 rows in set (0.05 sec) mysql> show tables; -> // +-------------------+ | Tables_in_final | +-------------------+ | cliente | | compra | | detalle_compra | | detalle_domicilio | | detalle_factura | | detalle_pedido | | domicilio | | empleado | | factura | | pedido | | perfil | | producto | | proveedor | | supermercado | +-------------------+ 14 rows in set (0.00 sec) mysql> describe detalle_domicilio; -> // +---------------+----------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+----------+------+-----+---------+----------------+ | cod_domicilio | int(11) | NO | MUL | NULL | auto_increment | | cedula | char(10) | NO | MUL | NULL | | +---------------+----------+------+-----+---------+----------------+ 2 rows in set (0.04 sec) mysql> delimiter ; mysql> describe domicilio; +---------------+----------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+----------+------+-----+---------+----------------+ | cod_domicilio | int(11) | NO | PRI | NULL | auto_increment | | fecha | date | NO | | NULL | | | hora | char(9) | NO | | NULL | | | descripcion | char(30) | YES | | NULL | | +---------------+----------+------+-----+---------+----------------+ 4 rows in set (0.02 sec) mysql> insert into domicilio(fecha,hora,descripcion) values ('2005-05-05','02:05','mercado'); Query OK, 1 row affected (0.05 sec) mysql> select * from detalle_domicilio; Empty set (0.03 sec) mysql> select * from domicilio; +---------------+------------+-------+-------------+ | cod_domicilio | fecha | hora | descripcion | +---------------+------------+-------+-------------+ | 1 | 2005-05-05 | 02:05 | mercado | +---------------+------------+-------+-------------+ 1 row in set (0.00 sec) mysql> insert into detalle_domicilio(cod_domicilio,cedula) values ('DOM02','CED01'); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`final`.`detalle_domicilio`, CONSTRAINT `detalle_domicilio_ibfk_2` FOREIGN KEY (`cedula`) REFERENCES `cliente` (`cedula`) ON DELETE CASCADE ON UPDATE CASCADE) mysql> select * from cliente; +----------+---------+----------+-----------+-----------+-----------+----------+--------+ | cedula | nombre1 | nombre2 | apellido1 | apellido2 | direccion | telefono | estado | +----------+---------+----------+-----------+-----------+-----------+----------+--------+ | 15512675 | Luis | Fernando | Garcia | Pati¤o | Rionegro | 6147089 | Activo | | 39448559 | Diana | Milena | Pati¤o | Ramirez | Medellin | 6147089 | Activo | +----------+---------+----------+-----------+-----------+-----------+----------+--------+ 2 rows in set (0.00 sec) mysql> select * from domicilio; +---------------+------------+-------+-------------+ | cod_domicilio | fecha | hora | descripcion | +---------------+------------+-------+-------------+ | 1 | 2005-05-05 | 02:05 | mercado | +---------------+------------+-------+-------------+ 1 row in set (0.00 sec) mysql> insert into detalle_domicilio(cedula) values ('15512675'); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`final`.`detalle_domicilio`, CONSTRAINT `detalle_domicilio_ibfk_1` FOREIGN KEY (`cod_domicilio`) REFERENCES `domicilio` (`cod_domicilio`) ON DELETE CASCADE ON UPDATE CASCADE) mysql> insert into detalle_domicilio(cod_domicilio,cedula) values (1,'15512675'); Query OK, 1 row affected (0.00 sec) mysql> select * from detalle_factura; Empty set (0.07 sec) mysql> select * from detalle_domicilio; +---------------+----------+ | cod_domicilio | cedula | +---------------+----------+ | 1 | 15512675 | +---------------+----------+ 1 row in set (0.00 sec) mysql> alter table domicilio add cedula_cliente char(10) not null; Query OK, 1 row affected (0.67 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> describe domicilio; +----------------+----------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+----------+------+-----+---------+----------------+ | cod_domicilio | int(11) | NO | PRI | NULL | auto_increment | | fecha | date | NO | | NULL | | | hora | char(9) | NO | | NULL | | | descripcion | char(30) | YES | | NULL | | | cedula_cliente | char(10) | NO | | NULL | | +----------------+----------+------+-----+---------+----------------+ 5 rows in set (0.04 sec) mysql> drop table detalle_domicilio; Query OK, 0 rows affected (0.13 sec) mysql> drop table domicilio; Query OK, 0 rows affected (0.03 sec) mysql> show tables; +-----------------+ | Tables_in_final | +-----------------+ | cliente | | compra | | detalle_compra | | detalle_factura | | detalle_pedido | | empleado | | factura | | pedido | | perfil | | producto | | proveedor | | supermercado | +-----------------+ 12 rows in set (0.00 sec) mysql> create table domicilio -> (cod_domicilio char(5) not null primary key, -> fecha date not null, -> hora char(5) not null, -> descripcion char(70), -> cedula char(10) not null, -> foreign key(cedula) references cliente(cedula) on update cascade on delete casade); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'casade)' at line 7 mysql> create table domicilio -> (cod_domicilio char(5) not null primary key, -> fecha date not null, -> hora char(5) not null, -> descripcion char(70), -> cedula char(10) not null, -> foreign key(cedula) references cliente(cedula) on update cascade on delete cascade); Query OK, 0 rows affected (0.14 sec) mysql> show procedure status; +------------+-----------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +------------+-----------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | final | consultarc | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarcompra | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultardomicilio | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultare | PROCEDURE | root@localhost | 2013-11-22 16:10:31 | 2013-11-22 16:10:31 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarf | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarpedido | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarperfil | PROCEDURE | root@localhost | 2013-11-22 14:11:10 | 2013-11-22 14:11:10 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarproducto | PROCEDURE | root@localhost | 2013-11-22 12:49:15 | 2013-11-22 12:49:15 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarproveedor | PROCEDURE | root@localhost | 2013-11-22 17:25:45 | 2013-11-22 17:25:45 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | consultarsuper | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | creardomicilio | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | crearf | PROCEDURE | root@localhost | 2013-11-22 12:20:46 | 2013-11-22 12:20:46 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | crearp | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | crearpedido | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | eliminarc | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | eliminare | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | eliminarproveedor | PROCEDURE | root@localhost | 2013-11-22 16:19:38 | 2013-11-22 16:19:38 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertarc | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertarcompra | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertardetallecompra | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertare | PROCEDURE | root@localhost | 2013-11-22 13:40:41 | 2013-11-22 13:40:41 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertarproducto | PROCEDURE | root@localhost | 2013-11-22 12:45:20 | 2013-11-22 12:45:20 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertarproveedor | PROCEDURE | root@localhost | 2013-11-22 17:23:55 | 2013-11-22 17:23:55 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | insertarsuper | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | llevarcargo | PROCEDURE | root@localhost | 2013-11-22 14:35:47 | 2013-11-22 14:35:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificarc | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificarcargo | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificardomicilio | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificare | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificarpedido | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificarproducto | PROCEDURE | root@localhost | 2013-11-22 12:47:13 | 2013-11-22 12:47:13 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | final | modificarproveedor | PROCEDURE | root@localhost | 2013-11-22 12:20:47 | 2013-11-22 12:20:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula | consultar_carrera | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | consultar_estudiante | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | consultar_materia | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | consultar_usuario | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula | eliminar_carrera | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | eliminar_estudiante | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | eliminar_materia | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | eliminar_usuario | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula | insertar_carrera | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | insertar_estudiante | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | insertar_materia | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | insertar_usuario | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula | modificar_carrera | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | modificar_estudiante | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | modificar_materia | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | modificar_usuario | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | utf8 | utf8_general_ci | latin1_swedish_ci | | matricula | validar_password | PROCEDURE | root@localhost | 2013-11-22 14:55:47 | 2013-11-22 14:55:47 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | consultaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:22 | 2013-10-22 21:30:22 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | eliminaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:23 | 2013-10-22 21:30:23 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | insertaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:23 | 2013-10-22 21:30:23 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula1 | modificaralumno | PROCEDURE | root@localhost | 2013-10-22 21:30:23 | 2013-10-22 21:30:23 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | consultaralumno | PROCEDURE | root@localhost | 2013-10-23 20:25:13 | 2013-10-23 20:25:13 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | eliminaralumno | PROCEDURE | root@localhost | 2013-10-23 20:32:52 | 2013-10-23 20:32:52 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | insertaralumno | PROCEDURE | root@localhost | 2013-10-22 21:52:42 | 2013-10-22 21:52:42 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | matricula2 | modificaralumno | PROCEDURE | root@localhost | 2013-10-23 20:31:09 | 2013-10-23 20:31:09 | DEFINER | | cp850 | cp850_general_ci | latin1_swedish_ci | | test | test_multi_sets | PROCEDURE | root@localhost | 2010-05-04 05:29:03 | 2010-05-04 05:29:03 | DEFINER | | latin1 | latin1_swedish_ci | latin1_swedish_ci | +------------+-----------------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 58 rows in set (0.18 sec) mysql> drop procedure creardomicilio; Query OK, 0 rows affected (0.30 sec) mysql> delimiter // mysql> describe domicilio// +---------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+----------+------+-----+---------+-------+ | cod_domicilio | char(5) | NO | PRI | NULL | | | fecha | date | NO | | NULL | | | hora | char(5) | NO | | NULL | | | descripcion | char(70) | YES | | NULL | | | cedula | char(10) | NO | MUL | NULL | | +---------------+----------+------+-----+---------+-------+ 5 rows in set (0.00 sec) mysql> create procedure creardomicilio(in _cod_domicilio char(5), in _fecha date, in _hora char(5), in _descripcion char(70), in _cedula char(10)) -> begin -> insert into domicilio(cod_domicilio,fecha,hora,descripcion,cedula) values (_cod_domicilio, _fecha, _hora, _descripcion, _cedula); -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> select * from domicilio; -> // +---------------+------------+-------+-------------+----------+ | cod_domicilio | fecha | hora | descripcion | cedula | +---------------+------------+-------+-------------+----------+ | DOM01 | 2013-05-06 | 12:43 | Mercado | 39448559 | +---------------+------------+-------+-------------+----------+ 1 row in set (0.00 sec) mysql> drop procedure consultardomicilio// Query OK, 0 rows affected (0.06 sec) mysql> create procedure consultardomicilio(in _cod_domicilio char(5)) -> begin -> select fecha,hora,descripcion,cedula from domicilio where cod_domicilio=_cod_domicilio; -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> select * from cliente; -> // +----------+---------+----------+-----------+-----------+-----------+----------+--------+ | cedula | nombre1 | nombre2 | apellido1 | apellido2 | direccion | telefono | estado | +----------+---------+----------+-----------+-----------+-----------+----------+--------+ | 15512675 | Luis | Fernando | Garcia | Pati¤o | Rionegro | 6147089 | Activo | | 39448559 | Diana | Milena | Pati¤o | Ramirez | Medellin | 6147089 | Activo | +----------+---------+----------+-----------+-----------+-----------+----------+--------+ 2 rows in set (0.00 sec) mysql> select * from empleado// +-------+----------+---------+-----------+-----------+-----------+----------+--------+------------+ | id | nombre1 | nombre2 | apellido1 | apellido2 | direccion | telefono | estado | cod_perfil | +-------+----------+---------+-----------+-----------+-----------+----------+--------+------------+ | SEC01 | Diana | Milena | Pati¤o | Ramirez | Rionegro | 6148089 | Activo | CAR02 | | VEN01 | Santiago | | Garcia | Pati¤o | Medellin | 5612512 | Activo | CAR01 | +-------+----------+---------+-----------+-----------+-----------+----------+--------+------------+ 2 rows in set (0.00 sec) mysql> select * from empleado// +-------+----------+---------+-----------+-----------+-----------+----------+--------+------------+ | id | nombre1 | nombre2 | apellido1 | apellido2 | direccion | telefono | estado | cod_perfil | +-------+----------+---------+-----------+-----------+-----------+----------+--------+------------+ | SEC01 | Diana | Milena | Pati¤o | Ramirez | Rionegro | 6148089 | Activo | CAR02 | | VEN01 | Santiago | | Garcia | Pati¤o | Medellin | 5612512 | Activo | CAR01 | | VEN02 | Jair | | Pati¤o | Ramirez | Rionegro | 5612512 | Activo | CAR01 | +-------+----------+---------+-----------+-----------+-----------+----------+--------+------------+ 3 rows in set (0.00 sec) mysql> call consultarc('15512675'); -> // +---------+----------+-----------+-----------+-----------+----------+--------+ | nombre1 | nombre2 | apellido1 | apellido2 | direccion | telefono | estado | +---------+----------+-----------+-----------+-----------+----------+--------+ | Luis | Fernando | Garcia | Pati¤o | Rionegro | 6147089 | Activo | +---------+----------+-----------+-----------+-----------+----------+--------+ 1 row in set (0.03 sec) Query OK, 0 rows affected (0.04 sec) mysql> create procedure consultarcliente(in _cedula char(10)) -> begin -> select cedula from cliente where cedula=_cedula; -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> delimiter ; mysql> create table inicio -> (usuario char(20) not null, -> contrase¤a char(10) not null primary key); Query OK, 0 rows affected (0.34 sec) mysql> delimiter // mysql> drop table inicio; -> // Query OK, 0 rows affected (0.20 sec) mysql> create table inicio -> (usuario char(20) not null primary key, -> contrase¤a char(10) not null); -> // Query OK, 0 rows affected (0.02 sec) mysql> create procedure crearinicio(in _usuario char(20), in _contrase¤a char(10)) -> begin -> insert into inicio(usuario,contrase¤a) values (_usuario, _contrase¤a); -> end -> // Query OK, 0 rows affected (0.00 sec) mysql> exit; -> \c mysql> delimiter ; mysql> exit;