Manual Sql

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)