Trigger insertar mysql

Páginas: 3 (612 palabras) Publicado: 27 de noviembre de 2011
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
-> ;...
Leer documento completo

Regístrate para leer el documento completo.

Estos documentos también te pueden resultar útiles

  • Aplicacion de Trigger un MySQL
  • Trigger
  • Union, interseccion, insertar, actualizar y eliminar usando consultas en MYSQL
  • INSERTAR, MODIFICAR, ELIMINAR Y CONSULTAR REGISTROS EN MYSQL DESDE C#
  • trigger
  • Trigger
  • Ejemplo insertar modificar y eliminar trigger sql server
  • Que es un trigger?

Conviértase en miembro formal de Buenas Tareas

INSCRÍBETE - ES GRATIS