Unable to delete a record in Mysql
Your error output is strange, it should be:

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 'where cname='Sophore'' at line 1


Which tell you exactly where the error is- you forgot the FROM clause on DELETE:

DELETE FROM company WHERE cname='Sophore';