Sript en Mysql
Publicado por Monica (7 intervenciones) el 27/10/2003 15:34:25
Un favor, quisiera saber cual seria el error si luego de cargar el sript.txt como este, en el MYSQLFRONT:
CREATE TABLE IEFECTO_LEGAL
(
D1_A CHAR(6),
D1_A_P CHAR(6),
D2_EF CHAR(3),
D2_AA CHAR(50),
D2_AP CHAR(50),
TI_A CHAR(5),
D1_D CHAR(15),
D1_E CHAR(4),
EM_A CHAR(40),
D1_S CHAR(15),
CAMPO INT,
CHK CHAR(1),
FEC DATETIME
)\g
INSERT INTO IEFECTO_LEGAL VALUES('130910','034527','DE','(6A.DMYF)','(4A.DF)','O','82','1995','MLM','[229,§125]',6,'A','2003-10-23 09:06:00')\g
INSERT INTO IEFECTO_LEGAL VALUES('131473','129459','MO','(1)','(1,2)','RS','315','2003','DE/SG',NULL,1,'A','2003-10-21 09:36:52')\g
Muestra el siguiente mensaje:
"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 '\g INSERT INTO IEFECTO_LEGAL VALUES('130910','034527','DE','(6A "
CREATE TABLE IEFECTO_LEGAL
(
D1_A CHAR(6),
D1_A_P CHAR(6),
D2_EF CHAR(3),
D2_AA CHAR(50),
D2_AP CHAR(50),
TI_A CHAR(5),
D1_D CHAR(15),
D1_E CHAR(4),
EM_A CHAR(40),
D1_S CHAR(15),
CAMPO INT,
CHK CHAR(1),
FEC DATETIME
)\g
INSERT INTO IEFECTO_LEGAL VALUES('130910','034527','DE','(6A.DMYF)','(4A.DF)','O','82','1995','MLM','[229,§125]',6,'A','2003-10-23 09:06:00')\g
INSERT INTO IEFECTO_LEGAL VALUES('131473','129459','MO','(1)','(1,2)','RS','315','2003','DE/SG',NULL,1,'A','2003-10-21 09:36:52')\g
Muestra el siguiente mensaje:
"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 '\g INSERT INTO IEFECTO_LEGAL VALUES('130910','034527','DE','(6A "
Valora esta pregunta
0