SQL scripts

[Sabin, Mihaela]

I compiled a list of errors found in some of the SQL scripts. See http://foss.unh.edu/opencomputing/index.php/CIS605_Class_Notes#Common_mistakes_when_you_write_your_SQL_scripts.

If anybody finds more, please add them to the list.

> -----Original Message-----
> From: internsh...@googlegroups.com
> [mailto:internsh...@googlegroups.com] On Behalf Of Dan Pepin
> Sent: Sunday, March 27, 2011 6:12 PM
> To: Internship2Career
> Subject: i2c Re: this week
>
> Yes, Brice and Aaron, there are a couple things you can do.
> You need to Fix the PHP dbInstall file to match the new SQL that
> Mihaela and I fixed.
> There were a lot of minor mistakes in the SQL file, and we are using
> some new conventions.
> Because 'state' and 'user' are keywords, we will use 'stateName' and
> 'sysuser'.
>
> The insert.sql file will need to be fixed in order to work now. You
> need to try and run the file, find the errors, and fix the errors.
> There is absolutely no way that the file will without testing it
> (especially with Aaron's spelling mistakes :D)
>
> So yea, that's about it, get the DB files working.. They are very
> important, and are the foundation for the rest of the semester.
> The create_tables.sql file should be perfect right now, so if you have
> questions, that file does everything correctly.
>
>
>
> On Mar 27, 12:27 pm, Brice Rader <hockeybp...@gmail.com> wrote:
> > Dan, is there anything you need Aaron and I to do?
>
> --
> We da best