ssddddw




Microsoft Windows [Versión 6.2.9200]
(c) 2012 Microsoft Corporation. Todos los derechos reservados.

C:\Users\carlos paul>cd c:/xampp/mysql/bin

c:\xampp\mysql\bin>mysql -h localhost -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 29
Server version: 5.5.32 MySQL Community Server (GPL)

Copyright (c) 2000, 2013,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> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
|cdcol |
| itsg |
| performance_schema |
| phpmyadmin |
| test |
| webauth |
+--------------------+
7 rows in set (0.00 sec)

mysql>use itsg;
Database changed
mysql> show tables;
+-----------------+
| Tables_in_itsg |
+-----------------+
| alumnos |
| carreras |
| socioeconomicos |
+-----------------+
3rows in set (0.00 sec)

mysql> select *from carreras;
+-------------+----------------+----------+
| ID_CARRERAS | NOMBRE_CARRERA | CREDITOS |
+-------------+----------------+----------+
|1 | sistemas | 111 |
| 2 | industrial | 111 |
| 3 | gestion | 111 |
| 4 | mecanica | 111 |
| 5 | electronica| 111 |
| 6 | computacion | 111 |
| 7 | maestria | 111 |
| 8 | enfermeria | 111 |
| 9 | doctorado | 111 |
|10 | protitucion | 111 |
| 11 | psicologia | 111 |
| 12 | derecho | 111 |
| 13 | marino | 111 |
| 14 | soldado...