Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE DATABASE cursophp;
Query OK, 1 row affected (0.02 sec)

mysql> SHOW DATABASES;
+----------------------+
| Database             |
+----------------------+
| information_schema   |
| abarrotes            |
| bddipjavai           |
| celulares_garcilazo  |
| classicmodels        |
| clinica_propedeutica |
| cms                  |
| contacto             |
| cursoh6              |
| cursoh8              |
| cursophp             |
| db_agenda            |
| diplomadojavaweb     |
| domingobd            |
| embotelladora        |
| exceljava            |
| horario6             |
| hospital_dalinde     |
| laboratorio_azul     |
| miscelanea           |
| mjavaweb             |
| muebleriaacme        |
| mybase               |
| mybd                 |
| mysql                |
| nombase              |
| northwind            |
| noticias             |
| paises               |
| personal             |
| prueba               |
| restaurante          |
| rivera               |
| sesion3a             |
| tarcy                |
| test                 |
| tienda               |
| tienda_polaris       |
| tiendadiscos         |
| tiendaenlinea        |
| tiendaonline         |
| tiendita             |
| zapateria_pakar      |
+----------------------+
43 rows in set (0.78 sec)

mysql> USE cursophp;
Database changed
mysql> SHOW TABLES;
Empty set (0.00 sec)

mysql> CREATE TABLE usuarios (
    ->   idusuario INT NOT NULL AUTO_INCREMENT,
    ->   nombre VARCHAR(45),
    ->   usuario VARCHAR(45),
    ->   pass VARCHAR(45),
    ->   PRIMARY KEY(idusuario)
    -> );
Query OK, 0 rows affected (0.30 sec)

mysql> INSERT INTO usuarios VALUES(null, 'Mariana', 'mary', '12345');
Query OK, 1 row affected (0.05 sec)

mysql> CREATE TABLE pais (
    ->   idpais INT NOT NULL AUTO_INCREMENT,
    ->   pais VARCHAR(45),
    ->   PRIMARY KEY(idpais)
    -> );
Query OK, 0 rows affected (0.07 sec)

mysql> )DROP TABLE pais;
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 ')DROP
 TABLE pais' at line 1
mysql> SHOW TABLES;
+--------------------+
| Tables_in_cursophp |
+--------------------+
| pais               |
| usuarios           |
+--------------------+
2 rows in set (0.00 sec)

mysql> DROP TABLE IF EXISTS pais;
Query OK, 0 rows affected (0.10 sec)

mysql> CREATE TABLE paises (
    ->   idpais INT NOT NULL AUTO_INCREMENT,
    ->   pais VARCHAR(45),
    ->   PRIMARY KEY(idpais)
    -> );
Query OK, 0 rows affected (0.13 sec)

mysql> SELECT * FROM paises;
Empty set (0.00 sec)

mysql> SELECT * FROM paises;
Empty set (0.00 sec)

mysql> DESC paises;
+--------+-------------+------+-----+---------+----------------+
| Field  | Type        | Null | Key | Default | Extra          |
+--------+-------------+------+-----+---------+----------------+
| idpais | int(11)     | NO   | PRI | NULL    | auto_increment |
| pais   | varchar(45) | YES  |     | NULL    |                |
+--------+-------------+------+-----+---------+----------------+
2 rows in set (0.05 sec)

mysql> SELECT * FROM paises;
Empty set (0.00 sec)

mysql> SELECT * FROM paises;
Empty set (0.00 sec)

mysql> SELECT * FROM paises;
Empty set (0.00 sec)

mysql> SELECT * FROM paises;
Empty set (0.00 sec)

mysql> SELECT * FROM paises;
Empty set (0.00 sec)

mysql> SELECT * FROM paises;
+--------+---------+
| idpais | pais    |
+--------+---------+
|      1 | Turquia |
+--------+---------+
1 row in set (0.00 sec)

mysql> SELECT * FROM paises;
+--------+---------+
| idpais | pais    |
+--------+---------+
|      1 | Turquia |
|      2 | Venecia |
+--------+---------+
2 rows in set (0.00 sec)

mysql> SELECT * FROM paises;
+--------+---------+
| idpais | pais    |
+--------+---------+
|      2 | Venecia |
+--------+---------+
1 row in set (0.00 sec)

mysql> SELECT * FROM paises;
+--------+---------+
| idpais | pais    |
+--------+---------+
|      2 | Venecia |
+--------+---------+
1 row in set (0.00 sec)

mysql> SELECT * FROM paises;
+--------+---------+
| idpais | pais    |
+--------+---------+
|      2 | Venecia |
+--------+---------+
1 row in set (0.00 sec)

mysql> SELECT * FROM paises;
+--------+---------+
| idpais | pais    |
+--------+---------+
|      2 | México |
+--------+---------+
1 row in set (0.00 sec)

mysql> INSERT INTO paises VALUES(null, 'Noruega');
Query OK, 1 row affected (0.03 sec)

mysql>