Do you have a "quickstart" schema in your db? musachy
On Nov 20, 2007 12:43 AM, Lewis Li <[EMAIL PROTECTED]> wrote: > 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] > > -- "Hey you! Would you help me to carry the stone?" Pink Floyd --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
