Interes

Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.0.45-community-nt-log MySQL Community Edition (GPL)

Type'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
|phpmyadmin |
| test |
+--------------------+
4 rows in set (0.01 sec)
mysql> create database test3;
Query OK, 1 row affected (0.01 sec)
mysql> show databases;+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| phpmyadmin |
| test |
| test3 |+--------------------+
5 rows in set (0.00 sec)
mysql> use test3;
Database changed
mysql> show tables ;
Empty set (0.00 sec)
mysql> create table lista
-> (id int not null auto_increment
-> primary key,-> nombre varchar(10) not null
-> )engine=myisam;
Query OK, 0 rows affected (0.01 sec)
mysql> show tables;
+-----------------+
| Tables_in_test3 |
+-----------------+
| lista|
+-----------------+
1 row in set (0.00 sec)
mysql>
mysql> INSERT INTO LISTA
-> (ID,NOMBRE) VALUES
-> (1,'carlos');
Query OK, 1 row affected (0.02 sec)

mysql> SELECT * FROM LISTA;+----+--------+
| id | nombre |
+----+--------+
| 1 | carlos |
+----+--------+
1 row in set (0.00 sec)
mysql> INSERT INTO LISTA
-> (ID,NOMBRE) VALUES
-> (NULL,'ALBERTO');
Query OK, 1row affected (0.00 sec)
mysql> SELECT * FROM LISTA;
+----+---------+
| id | nombre |
+----+---------+
| 1 | carlos |
| 2 | ALBERTO |
+----+---------+
2 rows in set (0.00 sec)
mysql>INSERT INTO LISTA
-> (NOMBRE) VALUES
-> ('JOSE');
Query OK, 1 row affected (0.00 sec)
mysql> SELECT * FROM LISTA;
+----+---------+
| id | nombre |
+----+---------+
| 1 | carlos |
|...