mysql> show tables; ERROR 1046 (3D000): No database selected mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | automoviles | | biblioteca | | cdcol | | factura | | libreria | | mysql | | performance_schema | | phpmyadmin | | test | | webauth | +--------------------+ 11 rows in set (0.21 sec) mysql> create database TALLER2; Query OK, 1 row affected (0.01 sec) mysql> create table VENDEDOR -> (id_cliente char (10) not null primary key, -> nombre char (10) not null, -> cupo_credito float(10) not null); ERROR 1046 (3D000): No database selected mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | automoviles | | biblioteca | | cdcol | | factura | | libreria | | mysql | | performance_schema | | phpmyadmin | | taller2 | | test | | webauth | +--------------------+ 12 rows in set (0.02 sec) mysql> use TALLER2; Database changed mysql> create table VENDEDOR -> (id_vendedor char (10) not null primary key, -> nombre char (40) not null, -> zona char (15) not null); Query OK, 0 rows affected (0.31 sec) mysql> create table CLIENTE -> (id_cliente char (10) not null primary key, -> nombre char (40) not null, -> cupo_credito float (10) not null); Query OK, 0 rows affected (0.34 sec) mysql> show tables; +-------------------+ | Tables_in_taller2 | +-------------------+ | cliente | | vendedor | +-------------------+ 2 rows in set (0.00 sec) mysql> alter table VENDEDOR add porcentaje_de_comision float (3) not null; Query OK, 0 rows affected (0.73 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> describe VENDEDOR; +------------------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------------+----------+------+-----+---------+-------+ | id_vendedor | char(10) | NO | PRI | NULL | | | nombre | char(40) | NO | | NULL | | | zona | char(15) | NO | | NULL | | | porcentaje_de_comision | float | NO | | NULL | | +------------------------+----------+------+-----+---------+-------+ 4 rows in set (0.14 sec) mysql> insert into VENDEDOR (id_vendedor,nombre,zona,porcentaje_de_comision) values ('001','luis Meza','norte',0.5); Query OK, 1 row affected (0.05 sec) mysql> inser into VENDEDOR (id_vendedor,nombre,zona,porcentaje_de_comision) values ('002','Camilo Lleras','centro',0.6); 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 'inser into VENDEDOR (id_vendedor,nombre,zona,porcentaje_de_comision) values ('00' at line 1 mysql> insert into VENDEDOR (id_vendedor,nombre,zona,porcentaje_de_comision) values ('002','Camilo Lleras','centro',0.6); Query OK, 1 row affected (0.05 sec)