miércoles, 6 de febrero de 2013

mysql veterinaria

Microsoft Windows [Version 6.0.6001]
Copyright (c) 2006 Microsoft Corporation.  All rights reserved.
C:\Users\familia leyva>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:
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
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 1
Server version: 5.5.16 MySQL Community Server (GPL)
Copyright (c) 2000, 2011, 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> create database veterinaria;
Query OK, 1 row affected (0.02 sec)
mysql> use veterinaria
Database changed
mysql> create tabla datos_perro;
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 'tabla
 datos_perro' at line 1
mysql> create table datos-perro;
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 '-perr
o' at line 1
mysql> create tabla datos_perro(ID varchar(15),nombre varchar(30),sexo varchar(1
0),fecha_nacimiento varchar(15),especie varchar(20),peso varchar(15),raza varcha
r(30),alzada varchar (30));
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 'tabla
 datos_perro(ID varchar(15),nombre varchar(30),sexo varchar(10),fecha_nacim' at
line 1
mysql> create table datos_perro(ID varchar(15),nombre varchar(30),sexo varchar(1
0),fecha_nacimiento varchar(15),especie varchar(20),peso varchar(15),raza varcha
r(30),alzada varchar (30));
Query OK, 0 rows affected (0.16 sec)
mysql> create table datos_propietario(ID varchar(20),nombre varchar (30),profesi
on varchar(30),direccion varchar (30),telefono varchar(15));
Query OK, 0 rows affected (0.14 sec)
mysql> create table datos_medio(entorno varchar(40),nutricion varchar (40),estil
o_de_vida varchar(40));
Query OK, 0 rows affected (0.19 sec)
mysql> create table constantes_fisiologicas(temperatura varchar (20),frecuencia_
cardiaca varchar(40),pulso varchar(30));
Query OK, 0 rows affected (0.22 sec)
mysql> create table analisis_sistema(piel_y_anexos varchar(40),lesiones_y_anexos
 varchar(40),descripcion_de_las_lesiones_linfonodos varchar(40),musculoso_esquel
etico varchar (40),nervioso varchar(40),otros varchar(40),respiratorio varchar(4
0),genital varchar (40),urinario varchar (40),respiratorio varchar(40),cardiovas
cular varchar (40),digestivo varchar(40),signos_digestivos varchar(40),organos_d
e_los_sentidos varchar(40));
ERROR 1060 (42S21): Duplicate column name 'respiratorio'
mysql>
mysql> create table analisis_sistema(piel_y_anexos varchar(40),lesiones_y_anexos
 varchar(40),descripcion_de_las_lesiones_linfonodos varchar(40),musculoso_esquel
etico varchar (40),nervioso varchar(40),otros varchar(40),sist_resp varchar(40),
genital varchar (40),urinario varchar (40),respiratorio varchar(40),cardiovascul
ar varchar (40),digestivo varchar(40),signos_digestivos varchar(40),organos_de_l
os_sentidos varchar(40));
Query OK, 0 rows affected (0.14 sec)
mysql> create table sistema_musculoso(inspeccion varchar(40),palpacion varchar(2
0),pruebas_especificas varchar(40));
Query OK, 0 rows affected (0.16 sec)
mysql> create table sistema_nervioso(pares_craneales varchar(40),reflejos_postul
ares varchar(40),estado_mental varchar(40),reacciones_postulares varchar(40));
Query OK, 0 rows affected (0.14 sec)
mysql> create table sistema_respiratorio(vias_aereas varchar(40),sonidos_respira
torios varchar(40),patrones_resp varchar(40),sintomas varchar(40));
Query OK, 0 rows affected (0.14 sec)
mysql> create table sistema_cardiovascular(membranas_mucosas varchar(40),caracte
risticas_pulso varchar(40),region_precordial varchar(40),auscultacion varchar(40
),otros varchar (40));
Query OK, 0 rows affected (0.20 sec)

No hay comentarios:

Publicar un comentario