RE: rank newbie looking for SQL forum
Scott Baker recommended the http://www.sqlcourse.com/ URL. I've just completed an overview/review of the course and have recommended it to several people here where I work in response to recent "How can I learn SQL" questions. Good reference. Many thanks. J.T.Fowler 512-326-6371 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: rank newbie looking for SQL forum
Okay, thanks guys! I'll lob this ball atcha, then: My main data table is 'trcdatabase2'. I currently use perl programs to get our in-house exported flat-file database into web-ready shape, but these can go *really* *slowly*, so I wanted to harness the speed of SQL. I've created a couple of copies of the table, 'newdatabase' & 'readydatabase'; I load the flat-text export file directly into 'newdatabase', then I had it in mind to work various perl/sql transformations upon it which would get funneled into the empty 'readydatabase' table. The first thing I wanted to do was export all of the data which is in both 'newdatabase' & 'trcdatabase2' into the 'readydatabase' table. So I'd basically be moving the rows from the active & web-ready 'trcdatabase2' into 'readydatabase' if & only if the catalog number ('catalog') was still included in the newly-uploaded 'newdatabase'. Here was my best guess: INSERT INTO readydatabase SELECT trcdatabase2.* FROM trcdatabase2, newdatabase WHERE newdatabase.catalog = trcdatabase2.catalog This caused horrible problems. It ran & ran, & then I had some type of monster table ('readydatabase') which nearly kept me from opening the MySQL shell interpreter, & took about 10 minutes just to DROP. Did I set up some kind of infinite loop? Is it because I've failed to set up 'catalog' as a primary key? If the latter, I've got another problem: I seem to have CREATE, but not ALTER TABLE privileges. I'm still waiting to hear back from my sysadmin about this. I hope to do all sorts of similar comparison transformations, & I'm afraid I just don't have table linking down conceptually, or something. Any help would be most appreciated. They're running MySQL 3.22.32 on Red Hat 5.2, incidentally. TIA!! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: rank newbie looking for SQL forum
I haven't participated, but the site at www.sqlteam.com looks useful and does have a number of forums there. HTH, G. > -Original Message- > From: Jason Witherspoon [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 25 January 2001 8:14 > To: [EMAIL PROTECTED] > Subject: rank newbie looking for SQL forum > > > Hi-- > > As stated above, I'm a raw beginner looking for some (probably fairly > simple) SQL conceptual help. Having lurked for a while, I can see that > since this isn't MySQL-specific, there's probably a better forum > in which I > can attempt to iron out my confusion. > > Can anyone point me to a mailing list/usenet group where I can > ask lots of > dumb newbie SQL questions w/o making a major pest of myself? > > I'll be back here in a short while, when I try to bang my head against a > Red Hat MySQL install again. > > Thanks! > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: rank newbie looking for SQL forum
Hi Jason, You have found the right place. No one here minds you asking simple questions, so long as you have checked the manual and the list archive before asking. In particular, Red Hat installs are a frequent topic. This list is supposed to be MySQL specific, but sometimes we get a little side-tracked. Welcome to the MySQL Community - I hope you have as much success with it as we have. Quentin Bennett Infinity Solutions http://www.infinity.co.nz -Original Message- From: Jason Witherspoon [mailto:[EMAIL PROTECTED]] Sent: Thursday, 25 January 2001 10:44 To: [EMAIL PROTECTED] Subject: rank newbie looking for SQL forum Hi-- As stated above, I'm a raw beginner looking for some (probably fairly simple) SQL conceptual help. Having lurked for a while, I can see that since this isn't MySQL-specific, there's probably a better forum in which I can attempt to iron out my confusion. Can anyone point me to a mailing list/usenet group where I can ask lots of dumb newbie SQL questions w/o making a major pest of myself? I'll be back here in a short while, when I try to bang my head against a Red Hat MySQL install again. Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: rank newbie looking for SQL forum
start with: http://www.sqlcourse.com/ At 01:44 PM 1/24/2001 -0800, Jason Witherspoon wrote: >Hi-- > >As stated above, I'm a raw beginner looking for some (probably fairly >simple) SQL conceptual help. Having lurked for a while, I can see that >since this isn't MySQL-specific, there's probably a better forum in which >I can attempt to iron out my confusion. > >Can anyone point me to a mailing list/usenet group where I can ask lots of >dumb newbie SQL questions w/o making a major pest of myself? > >I'll be back here in a short while, when I try to bang my head against a >Red Hat MySQL install again. - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] "Children today are tyrants. They contradict their parents, gobble their food, and tyrannize their teachers." - Socrates - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
rank newbie looking for SQL forum
Hi-- As stated above, I'm a raw beginner looking for some (probably fairly simple) SQL conceptual help. Having lurked for a while, I can see that since this isn't MySQL-specific, there's probably a better forum in which I can attempt to iron out my confusion. Can anyone point me to a mailing list/usenet group where I can ask lots of dumb newbie SQL questions w/o making a major pest of myself? I'll be back here in a short while, when I try to bang my head against a Red Hat MySQL install again. Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php