mysql> use tarea; Database changed mysql> insert into clientes(idcliente,nombre) values( -> (01,'kobacolombia'),(02,'mac pollo'),(03,'colombina'),(04,'studiof'),(05,'mattelsa'),(06,'servientrega'),(07,'giros y finanzas'),(08,'leonisa'),(09,'stop jeans'),(10,'cauchosol')); ERROR 1241 (21000): Operand should contain 1 column(s) mysql> insert into clientes(idcliente,nombre) values(01,'kobacolombia'),(02,'mac pollo'),(03,'colombina'),(04,'studiof'),(05,'mattelsa'),(06,'servientrega'),(07,'giros y finanzas'),(08,'leonisa'),(09,'stop jeans'),(10,'cauchosol'); Query OK, 10 rows affected (0.10 sec) Records: 10 Duplicates: 0 Warnings: 0 mysql> select * from clientes; +-----------+------------------+-------------+ | idcliente | nombre | descripcion | +-----------+------------------+-------------+ | 1 | kobacolombia | NULL | | 2 | mac pollo | NULL | | 3 | colombina | NULL | | 4 | studiof | NULL | | 5 | mattelsa | NULL | | 6 | servientrega | NULL | | 7 | giros y finanzas | NULL | | 8 | leonisa | NULL | | 9 | stop jeans | NULL | | 10 | cauchosol | NULL | +-----------+------------------+-------------+ 10 rows in set (0.08 sec) mysql> insert into cuentas(idcuenta,saldo) values(001,345000),(002,890000),(003,100000),(004,235000),(005,50000),(006,23205),(007,46410),(008,80000),(009,1000000),(010,20000); Query OK, 10 rows affected (0.15 sec) Records: 10 Duplicates: 0 Warnings: 0 mysql> select * from cuentas; +----------+---------+-----------+ | idcuenta | saldo | idcliente | +----------+---------+-----------+ | 1 | 345000 | NULL | | 2 | 890000 | NULL | | 3 | 100000 | NULL | | 4 | 235000 | NULL | | 5 | 50000 | NULL | | 6 | 23205 | NULL | | 7 | 46410 | NULL | | 8 | 80000 | NULL | | 9 | 1000000 | NULL | | 10 | 20000 | NULL | +----------+---------+-----------+ 10 rows in set (0.03 sec) mysql> show tables; +-----------------+ | Tables_in_tarea | +-----------------+ | clientes | | cuentas | | prestamos | +-----------------+ 3 rows in set (0.00 sec) mysql> describe prestamos; +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | idprestamo | int(11) | NO | PRI | NULL | | | descripcion | varchar(45) | YES | | NULL | | | plazo | int(11) | YES | | NULL | | | fecha_inicio | date | YES | | NULL | | | idcliente | int(11) | YES | MUL | NULL | | +--------------+-------------+------+-----+---------+-------+ 5 rows in set (0.01 sec) mysql> insert into prestamos(idprestamo,descripcion,fecha_inicio,plazo) values((01,'PIROSENSOR','01/09/2015',2),(02,'MAGNETICO','03/09/2015',1),(03,'HUMO','11/09/2015',3),(04,'PANICOS','11/09/2015',2), -> (05,'COMPUTADOR','12/09/2015',1),(06,'HERRAMIENTA','15/09/2015',1),(07,'HUMO','18/09/2015',2),(08,'MAGNETICO','19/09/2015',3), -> insert into prestamos(idprestamo,descripcion,fecha_inicio,plazo) values(01,'PIROSENSOR','01/09/2015',2),(02,'MAGNETICO','03/09/2015',1),(03,'HUMO','11/09/2015',3),(04,'PANICOS','11/09/2015',2), -> ; 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 'into prestamos(idprestamo,descripcion,fecha_inicio,plazo) values(01,'PIROSENSOR'' at line 3 mysql> insert into prestamos(idprestamo,descripcion,fecha_inicio,plazo) values(01,'PIROSENSOR','01/09/2015',2),(02,'MAGNETICO','03/09/2015',1),(03,'HUMO','11/09/2015',3),(04,'PANICOS','11/09/2015',2),(05,'COMPUTADOR','12/09/2015',1),(06,'HERRAMIENTA','15/09/2015',1),(07,'HUMO','18/09/2015',2),(08,'MAGNETICO','19/09/2015',3),(09,'PANICOS','25/09/2015',4),(10,'HUMO','31/09/2015',6); ERROR 1292 (22007): Incorrect date value: '01/09/2015' for column 'fecha_inicio' at row 1 mysql> insert into prestamos(idprestamo,descripcion,fecha_inicio,plazo) values(01,'PIROSENSOR','01/09/2015',2),(02,'MAGNETICO','03/09/2015',1),(03,'HUMO','11/09/2015',3),(04,'PANICOS','11/09/2015',2),(05,'COMPUTADOR','12/09/2015',1),(06,'HERRAMIENTA','15/09/2015',1),(07,'HUMO','18/09/2015',2),(08,'MAGNETICO','19/09/2015',3),(09,'PANICOS','25/09/2015',4),(10,'HUMO','31/09/2015',6); ERROR 1292 (22007): Incorrect date value: '01/09/2015' for column 'fecha_inicio' at row 1 mysql> insert into prestamos(idprestamos,descripcion,fecha_inicio,plazo) values(01,'PIROSENSOR',01/09/2015,2),(02,'MAGNETICO',03/09/2015,1),(03,'HUMO',11/09/2015,3),(04,'PANICOS',11/09/2015,2),(05,'COMPUTADOR',12/09/2015,1),(06,'HERRAMIENTA',15/09/2015,1),(07,'HUMO',18/09/2015,2),(08,'MAGNETICO',19/09/2015,3),(09,'PANICOS',25/09/2015,4),(10,'HUMO',31/09/2015,6); ERROR 1054 (42S22): Unknown column 'idprestamos' in 'field list' mysql> describe prestamos; +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | idprestamo | int(11) | NO | PRI | NULL | | | descripcion | varchar(45) | YES | | NULL | | | plazo | int(11) | YES | | NULL | | | fecha_inicio | date | YES | | NULL | | | idcliente | int(11) | YES | MUL | NULL | | +--------------+-------------+------+-----+---------+-------+ 5 rows in set (0.01 sec) mysql> insert into prestamos(idprestamo,descripcion,fecha_inicio,plazo) values(01,'PIROSENSOR',01/09/2015,2),(02,'MAGNETICO',03/09/2015,1),(03,'HUMO',11/09/2015,3),(04,'PANICOS',11/09/2015,2),(05,'COMPUTADOR',12/09/2015,1),(06,'HERRAMIENTA',15/09/2015,1),(07,'HUMO',18/09/2015,2),(08,'MAGNETICO',19/09/2015,3),(09,'PANICOS',25/09/2015,4),(10,'HUMO',31/09/2015,6); Query OK, 10 rows affected (0.17 sec) Records: 10 Duplicates: 0 Warnings: 0 mysql> select * from prestamos; +------------+-------------+-------+--------------+-----------+ | idprestamo | descripcion | plazo | fecha_inicio | idcliente | +------------+-------------+-------+--------------+-----------+ | 1 | PIROSENSOR | 2 | 0000-00-00 | NULL | | 2 | MAGNETICO | 1 | 0000-00-00 | NULL | | 3 | HUMO | 3 | 0000-00-00 | NULL | | 4 | PANICOS | 2 | 0000-00-00 | NULL | | 5 | COMPUTADOR | 1 | 0000-00-00 | NULL | | 6 | HERRAMIENTA | 1 | 0000-00-00 | NULL | | 7 | HUMO | 2 | 0000-00-00 | NULL | | 8 | MAGNETICO | 3 | 0000-00-00 | NULL | | 9 | PANICOS | 4 | 0000-00-00 | NULL | | 10 | HUMO | 6 | 0000-00-00 | NULL | +------------+-------------+-------+--------------+-----------+ 10 rows in set (0.00 sec)