Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

mysql create table

Posted on 2014-02-01
2
Medium Priority
?
504 Views
Last Modified: 2014-02-01
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
Comment
Question by:magento
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 35

Accepted Solution

by:
Dan Craciun earned 2000 total points
ID: 39826331
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
 
LVL 5

Author Comment

by:magento
ID: 39826340
Dan,

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

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question