Solved

mysql create table

Posted on 2014-02-01
2
486 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
2 Comments
 
LVL 34

Accepted Solution

by:
Dan Craciun earned 500 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Introduction Hopefully the following mnemonic and, ultimately, the acronym it represents is common place to all those reading: Please Excuse My Dear Aunt Sally (PEMDAS). Briefly, though, PEMDAS is used to signify the order of operations (http://en.…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

708 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now