Trigger insertar mysql

Solo disponible en BuenasTareas
  • Páginas : 3 (612 palabras )
  • Descarga(s) : 0
  • Publicado : 27 de noviembre de 2011
Leer documento completo
Vista previa del texto
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.0.51b-community-nt MySQL Community Edition (GPL)

Type 'help;' or'\h' for help. Type '\c' to clear the buffer.

mysql> create database clientes;
Query OK, 1 row affected (0.00 sec)

mysql> use clientes;
Database changed
mysql> create tableclientes(codigo_cliente int primary key, nombre varchar (250
), profesion varchar(100);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL serverversion for the right syntax to use near '' at
line 1
mysql> create table cliente(codigo_cliente int primary key, nombre varchar (250)
, profesion varchar(100);
ERROR 1064 (42000): You have anerror in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '' at
line 1
mysql> create table cliente(codigo_cliente int primarykey, nombre varchar (250)
, profesion varchar(100);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntaxto use near '' at
line 1
mysql> create table cliente(codigo_cliente int primary key, nombre varchar(250),
profesion varchar(100);
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 '' at
line 1
mysql> create table cliente (codigo_cliente int primary key, nombre varchar(250)
,profesion varchar(100);
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 '' at
line 1mysql> create table cliente(codigo_cliente int primary key, nombre varchar(250),
profesion varchar(100));
Query OK, 0 rows affected (0.12 sec)

mysql> describe cliente
-> ;...
tracking img