FRIHOST • FORUMS • FAQ • TOS • BLOGS • DIRECTORY
You are invited to Log in or Register a Frihost Account!

Error while creating the SQL table pls help

   Frihost Forum Index -> Scripting -> Php and MySQL
 


tamilparks
Error
SQL query:

CREATE TABLE `admin` (

`user` varchar( 50 ) default NULL ,
`password` varchar( 50 ) default NULL
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

MySQL said:

#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 'DEFAULT CHARSET=latin1' at line 4



the above said is the error while i am importing the SQL in my phpmyadmin area.. so can any one pls help me
rvec
you could try to do a search on the forums Wink
http://www.frihost.com/forums/vt-84756.html
ashok
Delete the default Charset setting. As our Mod said, you could've searched first...
tamilparks
ok thanks rvec and ashok,

first i have not searched i am sorry for that.. thanks for the help ............now its working..

thanks alot dear friends.
pollux1er
tamilparks wrote:


CREATE TABLE admin (

user varchar( 50 ) default NULL ,
password varchar( 50 ) default NULL
) ENGINE = MYISAM DEFAULT CHARSET = latin1;



Try the query like that. It it does not work tell us.
Diablosblizz
pollux1er wrote:
tamilparks wrote:


CREATE TABLE admin (

user varchar( 50 ) default NULL ,
password varchar( 50 ) default NULL
) ENGINE = MYISAM DEFAULT CHARSET = latin1;



Try the query like that. It it does not work tell us.


If you read above it has been solved.
tamilparks
hellow dear friends, thanks for your help now its working the site name is http://www.funworld.frih.net/jokes/index.php
http://www.funworld.frih.net/quotes/index.php

please close the topic
rvec
-close-
This topic is locked: you cannot edit posts or make replies.    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2007 Frihost, forums powered by phpBB.