Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 507
  • Last Modified:

mysql create table

Tried the below showing syntax error at last line

#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 'group varchar(255) )' at line 53

create table magento_customer (
website varchar(255),
email  varchar(255),
group_id varchar(255),
disable_auto_group_change varchar(255),
firstname varchar(255),
lastname varchar(255),
password_hash varchar(255),
billing_prefix varchar(255),
billing_firstname  varchar(255),
billing_middlename varchar(255),
billing_lastname varchar(255),
billing_suffix varchar(255),
billing_street_full varchar(255),
billing_street1 varchar(255),
billing_street2 varchar(255),
billing_street3 varchar(255),
billing_street4 varchar(255),
billing_street5 varchar(255),
billing_street6 varchar(255),
billing_street7 varchar(255),
billing_street8 varchar(255),
billing_city varchar(255),
billing_region varchar(255),
billing_country varchar(255),
billing_postcode varchar(255),
billing_telephone varchar(255),
billing_company varchar(255),
billing_fax varchar(255),
shipping_prefix varchar(255),
shipping_firstname varchar(255),
shipping_middlename varchar(255),
shipping_lastname varchar(255),
shipping_suffix varchar(255),
shipping_street_full varchar(255),
shipping_street1 varchar(255),
shipping_street2 varchar(255),
shipping_street3 varchar(255),
shipping_street4 varchar(255),
shipping_street5 varchar(255),
shipping_street6 varchar(255),
shipping_street7 varchar(255),
shipping_street8 varchar(255),
shipping_city varchar(255),
shipping_region varchar(255),
shipping_country varchar(255),
shipping_postcode varchar(255),
shipping_telephone varchar(255),
shipping_company varchar(255),
shipping_fax varchar(255),
created_in varchar(255),
is_subscribed varchar(255),
group varchar(255)
)

Open in new window

0
magento
Asked:
magento
1 Solution
 
Dan CraciunIT ConsultantCommented:
Group is a reserved word. You cannot use it as a column name: https://dev.mysql.com/doc/refman/5.6/en/reserved-words.html

HTH,
Dan
0
 
magentoAuthor Commented:
Dan,

Good catch . Thanks for the url . I learned it now .
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now