Darkc0der
20th November 2011, 09:09 AM
agan2 smua, gw ada masalah neh gan ama import file .sql.
jd gan gw punya db yg uda di dump ke .sql.
pas gw import di mysql gw error gan.
error nya
"#1064 - 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 'from INTEGER NOT NULL,
PRIMARY KEY (id_mst_country)
)' at line 14 "
http://static.kaskus.us/images/smilies/bingungs.gif, http://static.kaskus.us/images/smilies/bingungs.gif
minta pencerahan dari agan2 smua dunk
thanx b4
neh potongan query yg error gan :
CREATE TABLE mst_country
(
id_mst_country INTEGER NOT NULL,
country_name VARCHAR(55) NOT NULL,
citizen VARCHAR(55),
otherinfo TEXT,
created_by INTEGER,
created_date DATETIME,
lastedit_by INTEGER,
lastedit_date DATETIME,
id_mst_receivesend INTEGER,
ref_project INTEGER,
ref_mail INTEGER,
from INTEGER NOT NULL,
PRIMARY KEY (id_mst_country)
)
;
</div>
jd gan gw punya db yg uda di dump ke .sql.
pas gw import di mysql gw error gan.
error nya
"#1064 - 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 'from INTEGER NOT NULL,
PRIMARY KEY (id_mst_country)
)' at line 14 "
http://static.kaskus.us/images/smilies/bingungs.gif, http://static.kaskus.us/images/smilies/bingungs.gif
minta pencerahan dari agan2 smua dunk
thanx b4
neh potongan query yg error gan :
CREATE TABLE mst_country
(
id_mst_country INTEGER NOT NULL,
country_name VARCHAR(55) NOT NULL,
citizen VARCHAR(55),
otherinfo TEXT,
created_by INTEGER,
created_date DATETIME,
lastedit_by INTEGER,
lastedit_date DATETIME,
id_mst_receivesend INTEGER,
ref_project INTEGER,
ref_mail INTEGER,
from INTEGER NOT NULL,
PRIMARY KEY (id_mst_country)
)
;
</div>