Ceriwis

Ceriwis (https://forum.ceriwis.com/forum.php)
-   Programming (https://forum.ceriwis.com/forumdisplay.php?f=63)
-   -   Minta bantuan error import .sql di MySql (https://forum.ceriwis.com/showthread.php?t=574349)

Darkc0der 20th November 2011 09:09 AM

Minta bantuan error import .sql di MySql
 

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>


All times are GMT +7. The time now is 04:18 PM.