Remove all the single quotes and try; it works for me fine that way. MySQL documentation is available http://dev.mysql.com/doc/#manual.
d. --- Lewis Li <[EMAIL PROTECTED]> wrote: > Yes, I created a database named "quickstart" before > running the script. A > database is the same as a schema. > Can you successfully run the script with your MySql? > > Lewis > ----- Original Message ----- > From: "Musachy Barroso" <[EMAIL PROTECTED]> > To: "Struts Users Mailing List" > <user@struts.apache.org> > Sent: Tuesday, November 20, 2007 9:59 PM > Subject: Re: Problem running the MySQL script in > "Struts 2 + Spring 2 + JPA > + AJAX" tutorial > > > > 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. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
