Hi! I'm doing the tutorial "Struts 2 + Spring 2 + JPA + AJAX" located at
http://struts.apache.org/2.0.11/docs/struts-2-spring-2-jpa-ajax.html.
I have installed and configured MySQL and created a database named
"quickstart". But I get a syntax error when running this script:
CREATE TABLE 'quickstart'.'Person' (
'id' INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
'firstName' VARCHAR(45) NOT NULL,
'lastName' VARCHAR(45) NOT NULL,
PRIMARY KEY('id')
)
ENGINE = InnoDB;This is exactly the same script from the tutorial. The error
report reported by MySQL Query Browser is:
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
''quickstart'.'Person' (
'id' INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
'fi' at line 1
I really can't figure out what's wrong with the script. I'm running this
version of MySQL on a Windows XP computer:
Server version: 5.0.41-community-nt MySQL Community Edition (GPL)
I'd really appreciate it if anyone could help me out. Thank you.
Lewis LI
E-mail: [EMAIL PROTECTED]
Phone: +86-755-8619 3841
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
