Base Datos

Microsoft Windows [Versión 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. Reservados todos los derechos.
C:\Users\alumno>cd..
C:\Users>cd..
C:\>cd xampp
C:\xampp>cd mysql
C:\xampp\mysql>cd bin
C:\xampp\mysql\bin>mysql -hlocalhost -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version:5.1.41 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use gustavo;
Database changed
mysql> create table usuarios (nombre varchar(30), clave varchar(10));
Query OK, 0 rows affected (0.04 sec)
mysql> insert into usiarios (nombre, clave) values ('leonardo','payaso');
ERROR 1146 (42S02): Table 'gustavo.usiarios' doesn't existmysql> insert into usuarios (nombre, clave) values ('leonardo','payaso');
Query OK, 1 row affected (0.00 sec)
mysql> insert into usuarios (nombre, clave) values ('MarioPerez','Maarito');
Query OK, 1 row affected (0.00 sec)
mysql> insert into usuarios (nombre, clave) values ('Marcelo','River');
Query OK, 1 row affected (0.00 sec)
mysql> insert into usuarios (nombre, clave) values('Gustavo','River');
Query OK, 1 row affected (0.00 sec)
mysql> delete from usuarios where nombre='leonardo';
Query OK, 1 row affected (0.00 sec)
mysql> select nombre,clave from usuarios;
+------------+---------+
| nombre     | clave   |
+------------+---------+
| MarioPerez | Maarito |
| Marcelo    | River   |
| Gustavo    | River   |
+------------+---------+
3 rows in set (0.00 sec)mysql> delete from usuarios where clave='River';
Query OK, 2 rows affected (0.00 sec)
mysql> select nombre,clave from usuarios;
+------------+---------+
| nombre     | clave   |
+------------+---------+
| MarioPerez | Maarito |
+------------+---------+
1 row in set (0.00 sec)
mysql> delete from usuarios;
Query OK, 1 row affected (0.00 sec)
mysql> select nombre,clave fromusuarios;
Empty set (0.00 sec)

Microsoft Windows [Versión 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. Reservados todos los derechos.
C:\Users\alumno>cd..
C:\Users>cd..
C:\>cd mysql
El sistema no puede encontrar la ruta especificada.
C:\>cd xampp
C:\xampp>cd mysql
C:\xampp\mysql>cd bin
C:\xampp\mysql\bin>mysql -hlocalhost -uroot -p
Enter password:
Welcometo the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.1.41 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use gustavo
Database changed
mysql> drop table if exist usuarios;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQLserver version for the right syntax to use near 'exist
 usuarios' at line 1
mysql> drop table if exists usuarios;
Query OK, 0 rows affected (0.00 sec)
mysql> create table usuarios (nombre varchar(30), clave varchar(10));
Query OK, 0 rows affected (0.04 sec)
mysql> inser into usuarios (nombre, clave) values ('leonardo','payaso');
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 usuarios (nombre, clave) values ('leonardo','payaso')' at line 1
mysql> insert into usuarios (nombre, clave) values ('leonardo','payaso');
Query OK, 1 row affected (0.00 sec)
mysql> insert into usuarios (nombre, clave) values ('Marioperez','Marito');
Query OK, 1 row affected(0.00 sec)
mysql> insert into usuarios (nombre, clave) values ('Marcelo','River');
Query OK, 1 row affected (0.00 sec)
mysql> insert into usuarios (nombre, clave) values ('Gustavo','River');
Query OK, 1 row affected (0.00 sec)
mysql> select * from usuarios;
+------------+--------+
| nombre     | clave  |
+------------+--------+
| leonardo   | payaso |
| Marioperez | Marito |
|...