MySQL Forums
Forum List  »  Stored Procedures

#1064 error
Posted by: Abdul Majid P
Date: July 24, 2014 12:40AM

Hai, My site having an issue, "Bad SubDomain SQL query". We are using PrestaShop, as per forum we tried this code in sql tab,

1.DROP TABLE 'PREFIX_subdomain'; then,

2.CREATE TABLE 'ps_subdomain' (
'id_subdomain' int(10) unsigned NOT NULL auto_increment,
'name' varchar(16) NOT NULL,
PRIMARY KEY ('id_subdomain')
) ENGINE=ENGINE_TYPE DEFAULT CHARSET=utf8;

INSERT INTO 'ps_subdomain' ('id_subdomain', 'name') VALUES (1, 'www');

But it shows error like
" #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 ''ps_subdomain'' at line 1"

We are using,
Server: Localhost via UNIX socket
Server type: MySQL
Server version: 5.1.73-cll - MySQL Community Server (GPLv2)
Protocol version: 10
User: *******@localhost
Server charset: UTF-8 Unicode (utf8)

Kindly Please help, our business is slows down last 2 days.

Options: ReplyQuote


Subject
Views
Written By
Posted
#1064 error
2103
July 24, 2014 12:40AM
1108
July 24, 2014 08:33AM
970
July 24, 2014 05:28PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.