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

Diablosblizz

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-

pls help about mysql errorr
Pls help, onmouseover popup image frm database
How to make a image view from bluring to sharp ?
Account creation pm
Database Privilege

Error in phpBB table>>phpbb_sessions(pls help)
Help with else if and database script
CD copy error... pls help
How to edit SQL files?
CSS Help...

Sql/Phpbb error...
HELP! : Uninstalling phpBB2 mod
mySQL create table problem (parse error)..
SQL Error while installing PHPBB
Basic Socket Programming Error in Linux.. Pls help