FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Error while creating the SQL table pls help





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-
Related topics
How to edit SQL files?
CSS Help...
Database Privilege
Error in phpBB table>>phpbb_sessions(pls help)
How to make a image view from bluring to sharp ?
pls help about mysql errorr
Pls help, onmouseover popup image frm database
Account creation pm
Help with else if and database script
CD copy error... pls help
pls help me while transfer a wp blog
Getting database connection error while installing wordpress
SQL ERROR [ mysqli ]
oracle sql Alter table from a triggered package procedure
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-2011 Frihost, forums powered by phpBB.