Manual Sql
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Manual Sql as PDF for free.
More details
- Words: 752
- Pages: 8
Microsoft Windows XP [Versión 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\ADSI_M>cd..
C:\Documents and Settings>cd..
C:\>cd xammp El sistema no puede hallar la ruta especificada.
C:\>cd xampp
C:\xampp>cd mysql
C:\xampp\mysql>cd bin
C:\xampp\mysql\bin>dir El volumen de la unidad C no tiene etiqueta. El número de serie del volumen es: A88C-36C7
Directorio de C:\xampp\mysql\bin
05/02/2009 10:55
.
05/02/2009 10:55
..
17/04/2008 12:13
1.503.232 comp-err.exe
13/02/2008 13:49
1.249.280 comp_err.exe
13/02/2008 13:52
69.632 comp_sql.exe
17/04/2008 12:13
103.040 echo.exe
13/02/2008 13:57
1.232.896 gen_lex_hash.exe
17/04/2008 12:13
2.076.672 libmysql.dll
20/12/2007 21:00
626.688 msvcr80.dll
05/02/2009 10:55
5.282 my.cnf
17/04/2008 12:13
1.839.744 myisamchk.exe
17/04/2008 12:13
1.737.344 myisamlog.exe
17/04/2008 12:13
1.761.920 myisampack.exe
17/04/2008 12:13
1.720.960 myisam_ftdump.exe
17/04/2008 12:13
2.052.736 mysql.exe
17/04/2008 12:13
2.003.584 mysqladmin.exe
17/04/2008 12:13
2.060.928 mysqlbinlog.exe
17/04/2008 12:13
1.999.488 mysqlcheck.exe
17/04/2008 11:58
8.486.912 mysqld-debug.exe
17/04/2008 12:13
5.750.784 mysqld-nt.exe
17/04/2008 12:11
5.747.328 mysqld.exe
17/04/2008 12:13
2.048.640 mysqldump.exe
17/04/2008 12:13
1.995.392 mysqlimport.exe
17/04/2008 12:13
2.015.872 mysqlmanager.exe
17/04/2008 12:13
1.995.392 mysqlshow.exe
17/04/2008 12:13
2.122.368 mysqltest.exe
17/04/2008 12:13
2.293.760 mysql_client_test.exe
17/04/2008 12:13
1.557.120 mysql_upgrade.exe
17/04/2008 12:13 20/12/2007 21:01
107.136 myTest.exe 2.957 my_example.cnf
17/04/2008 12:13
1.503.872 my_print_defaults.exe
17/04/2008 12:13
1.487.488 perror.exe
17/04/2008 12:13
1.495.680 replace.exe
13/02/2008 14:07
90.112 udf_example.dll
20/12/2007 21:01
818 winmysqladmin.cnt
20/12/2007 21:00
936.448 winmysqladmin.exe
20/12/2007 21:00
1.856.816 winmysqladmin.hlp
35 archivos
63.538.321 bytes
2 dirs 12.300.484.608 bytes libres
C:\xampp\mysql\bin>*.exe "*.exe" no se reconoce como un comando interno o externo, programa o archivo por lotes ejecutable.
C:\xampp\mysql\bin>mysql -u mysql: option '-u' requires an argument
C:\xampp\mysql\bin>mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.0.51b-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+--------------------+ | Database
|
+--------------------+ | information_schema | | baseautos | baseusuario
| |
| cdcol
|
| datos
|
| ingreso
|
| inscripcion
|
| inscripciones
|
| mysql
|
| persona
|
| phpmyadmin
|
| prueba | test
| |
| usuarios
|
| webauth
|
+--------------------+ 15 rows in set (0.16 sec)
**mysql> create database adsi; Query OK, 1 row affected (0.00 sec)
**mysql> show databases; +--------------------+ | Database
|
+--------------------+ | information_schema | | adsi
|
| baseautos
|
| baseusuario
|
| cdcol
|
| datos
|
| ingreso
|
| inscripcion
|
| inscripciones
|
| mysql
|
| persona
|
| phpmyadmin
|
| prueba
|
| test
|
| usuarios
|
| webauth
|
+--------------------+ 16 rows in set (0.00 sec)
**mysql> use adsi; Database changed
**mysql> create table conductor(idconductor int auto_increment, nombre char(30),ap ellido char(30), horas int, primary key(idconductor)); Query OK, 0 rows affected (0.08 sec)
**mysql> describe conductor; +-------------+----------+------+-----+---------+----------------+ | Field
| Type
| Null | Key | Default | Extra
|
+-------------+----------+------+-----+---------+----------------+ | idconductor | int(11) | NO | PRI | NULL | nombre
| char(30) | YES |
| apellido
| char(30) | YES |
| horas
| int(11) | YES |
| auto_increment |
| NULL | NULL | NULL
|
|
| |
| |
+-------------+----------+------+-----+---------+----------------+ 4 rows in set (0.02 sec)
**mysql> create table autos(idautos int auto_increment, nombre char(20), marca cha r(20), modelo int,idconductor int, primary key(idautos),index(idconductor),forei gn key(idconductor)references conductor(idconductor)); Query OK, 0 rows affected (0.05 sec)
**mysql> describe autos; +-------------+----------+------+-----+---------+----------------+ | Field
| Type
| Null | Key | Default | Extra
|
+-------------+----------+------+-----+---------+----------------+ | idautos | nombre
| int(11) | NO | PRI | NULL | char(20) | YES |
| marca
| char(20) | YES |
| modelo
| int(11) | YES |
| auto_increment |
| NULL | NULL | NULL
|
|
|
|
|
| idconductor | int(11) | YES | MUL | NULL
| |
+-------------+----------+------+-----+---------+----------------+ 5 rows in set (0.00 sec)
**mysql> insert into conductor(idconductor,nombre, apellido,horas)value(1,'fabian' ,'gonzales',1400); Query OK, 1 row affected (0.03 sec)
**mysql> insert into conductor(nombre, apellido,horas)value('catalina','castro',80 0);
|
Query OK, 1 row affected (0.00 sec)
**mysql> insert into autos(nombre, marca,modelo,idconductor)value('sirion','dahiat su',2009,1); Query OK, 1 row affected (0.00 sec)
**mysql> insert into autos(nombre, marca,modelo,idconductor)value('tiburon','hiund ay',2009,2); Query OK, 1 row affected (0.00 sec)
**mysql> select * from conductor; +-------------+----------+----------+-------+ | idconductor | nombre | apellido | horas | +-------------+----------+----------+-------+ |
1 | fabian | gonzales | 1400 |
|
2 | catalina | castro | 800 |
+-------------+----------+----------+-------+ 2 rows in set (0.00 sec)
**mysql> select * from autos; +---------+---------+----------+--------+-------------+ | idautos | nombre | marca
| modelo | idconductor |
+---------+---------+----------+--------+-------------+ |
1 | sirion | dahiatsu | 2009 |
|
2 | tiburon | hiunday | 2009 |
1| 2|
+---------+---------+----------+--------+-------------+ 2 rows in set (0.02 sec)
C:\Documents and Settings\ADSI_M>cd..
C:\Documents and Settings>cd..
C:\>cd xammp El sistema no puede hallar la ruta especificada.
C:\>cd xampp
C:\xampp>cd mysql
C:\xampp\mysql>cd bin
C:\xampp\mysql\bin>dir El volumen de la unidad C no tiene etiqueta. El número de serie del volumen es: A88C-36C7
Directorio de C:\xampp\mysql\bin
05/02/2009 10:55
.
05/02/2009 10:55
..
17/04/2008 12:13
1.503.232 comp-err.exe
13/02/2008 13:49
1.249.280 comp_err.exe
13/02/2008 13:52
69.632 comp_sql.exe
17/04/2008 12:13
103.040 echo.exe
13/02/2008 13:57
1.232.896 gen_lex_hash.exe
17/04/2008 12:13
2.076.672 libmysql.dll
20/12/2007 21:00
626.688 msvcr80.dll
05/02/2009 10:55
5.282 my.cnf
17/04/2008 12:13
1.839.744 myisamchk.exe
17/04/2008 12:13
1.737.344 myisamlog.exe
17/04/2008 12:13
1.761.920 myisampack.exe
17/04/2008 12:13
1.720.960 myisam_ftdump.exe
17/04/2008 12:13
2.052.736 mysql.exe
17/04/2008 12:13
2.003.584 mysqladmin.exe
17/04/2008 12:13
2.060.928 mysqlbinlog.exe
17/04/2008 12:13
1.999.488 mysqlcheck.exe
17/04/2008 11:58
8.486.912 mysqld-debug.exe
17/04/2008 12:13
5.750.784 mysqld-nt.exe
17/04/2008 12:11
5.747.328 mysqld.exe
17/04/2008 12:13
2.048.640 mysqldump.exe
17/04/2008 12:13
1.995.392 mysqlimport.exe
17/04/2008 12:13
2.015.872 mysqlmanager.exe
17/04/2008 12:13
1.995.392 mysqlshow.exe
17/04/2008 12:13
2.122.368 mysqltest.exe
17/04/2008 12:13
2.293.760 mysql_client_test.exe
17/04/2008 12:13
1.557.120 mysql_upgrade.exe
17/04/2008 12:13 20/12/2007 21:01
107.136 myTest.exe 2.957 my_example.cnf
17/04/2008 12:13
1.503.872 my_print_defaults.exe
17/04/2008 12:13
1.487.488 perror.exe
17/04/2008 12:13
1.495.680 replace.exe
13/02/2008 14:07
90.112 udf_example.dll
20/12/2007 21:01
818 winmysqladmin.cnt
20/12/2007 21:00
936.448 winmysqladmin.exe
20/12/2007 21:00
1.856.816 winmysqladmin.hlp
35 archivos
63.538.321 bytes
2 dirs 12.300.484.608 bytes libres
C:\xampp\mysql\bin>*.exe "*.exe" no se reconoce como un comando interno o externo, programa o archivo por lotes ejecutable.
C:\xampp\mysql\bin>mysql -u mysql: option '-u' requires an argument
C:\xampp\mysql\bin>mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.0.51b-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+--------------------+ | Database
|
+--------------------+ | information_schema | | baseautos | baseusuario
| |
| cdcol
|
| datos
|
| ingreso
|
| inscripcion
|
| inscripciones
|
| mysql
|
| persona
|
| phpmyadmin
|
| prueba | test
| |
| usuarios
|
| webauth
|
+--------------------+ 15 rows in set (0.16 sec)
**mysql> create database adsi; Query OK, 1 row affected (0.00 sec)
**mysql> show databases; +--------------------+ | Database
|
+--------------------+ | information_schema | | adsi
|
| baseautos
|
| baseusuario
|
| cdcol
|
| datos
|
| ingreso
|
| inscripcion
|
| inscripciones
|
| mysql
|
| persona
|
| phpmyadmin
|
| prueba
|
| test
|
| usuarios
|
| webauth
|
+--------------------+ 16 rows in set (0.00 sec)
**mysql> use adsi; Database changed
**mysql> create table conductor(idconductor int auto_increment, nombre char(30),ap ellido char(30), horas int, primary key(idconductor)); Query OK, 0 rows affected (0.08 sec)
**mysql> describe conductor; +-------------+----------+------+-----+---------+----------------+ | Field
| Type
| Null | Key | Default | Extra
|
+-------------+----------+------+-----+---------+----------------+ | idconductor | int(11) | NO | PRI | NULL | nombre
| char(30) | YES |
| apellido
| char(30) | YES |
| horas
| int(11) | YES |
| auto_increment |
| NULL | NULL | NULL
|
|
| |
| |
+-------------+----------+------+-----+---------+----------------+ 4 rows in set (0.02 sec)
**mysql> create table autos(idautos int auto_increment, nombre char(20), marca cha r(20), modelo int,idconductor int, primary key(idautos),index(idconductor),forei gn key(idconductor)references conductor(idconductor)); Query OK, 0 rows affected (0.05 sec)
**mysql> describe autos; +-------------+----------+------+-----+---------+----------------+ | Field
| Type
| Null | Key | Default | Extra
|
+-------------+----------+------+-----+---------+----------------+ | idautos | nombre
| int(11) | NO | PRI | NULL | char(20) | YES |
| marca
| char(20) | YES |
| modelo
| int(11) | YES |
| auto_increment |
| NULL | NULL | NULL
|
|
|
|
|
| idconductor | int(11) | YES | MUL | NULL
| |
+-------------+----------+------+-----+---------+----------------+ 5 rows in set (0.00 sec)
**mysql> insert into conductor(idconductor,nombre, apellido,horas)value(1,'fabian' ,'gonzales',1400); Query OK, 1 row affected (0.03 sec)
**mysql> insert into conductor(nombre, apellido,horas)value('catalina','castro',80 0);
|
Query OK, 1 row affected (0.00 sec)
**mysql> insert into autos(nombre, marca,modelo,idconductor)value('sirion','dahiat su',2009,1); Query OK, 1 row affected (0.00 sec)
**mysql> insert into autos(nombre, marca,modelo,idconductor)value('tiburon','hiund ay',2009,2); Query OK, 1 row affected (0.00 sec)
**mysql> select * from conductor; +-------------+----------+----------+-------+ | idconductor | nombre | apellido | horas | +-------------+----------+----------+-------+ |
1 | fabian | gonzales | 1400 |
|
2 | catalina | castro | 800 |
+-------------+----------+----------+-------+ 2 rows in set (0.00 sec)
**mysql> select * from autos; +---------+---------+----------+--------+-------------+ | idautos | nombre | marca
| modelo | idconductor |
+---------+---------+----------+--------+-------------+ |
1 | sirion | dahiatsu | 2009 |
|
2 | tiburon | hiunday | 2009 |
1| 2|
+---------+---------+----------+--------+-------------+ 2 rows in set (0.02 sec)
Related Documents
Manual Sql
October 2019 25
Manual Sql
June 2020 10
Manual Sql
May 2020 7
Manual Sql
May 2020 12
Manual Sql Server 2000
May 2020 16
Sql Payroll Manual Book
November 2019 14More Documents from ""
Ch2-international Flow Of Funds.ppt
May 2020 21
Direito Processual Penal - Varas Especializadas
June 2020 24
