Do a "show tables" and see what is the actual table name. I think "group" is a key work and hence its giving you the error.
See the table names in that database. regards anandkl On 4/15/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > Hi, > > I have created a table name group. > > CREATE TABLE `group` ( > `group_id` int(11) NOT NULL, > `group_name` varchar(128) NOT NULL, > `date_created` datetime NOT NULL, > `created_by` int(11) NOT NULL, > `modified_by` int(11) default NULL, > `status` char(1) NOT NULL default 'Y', > PRIMARY KEY (`group_id`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > The table was successfully created without any errors. > After that when i try to describe it. Its giving error. > > mysql> desc group; > ERROR 1064 (42000): 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 'group' at line 1 > mysql> drop table group; > ERROR 1064 (42000): 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 'group' at line 1 > > Does the problem is with table name. > > Thanks, > -- > Krishna Chandra Prajapati > Email-id: [EMAIL PROTECTED] >
