Sock Puppet
Moderators: carlson1, Charles L. Cotton
- tacticool
- Senior Member
- Posts: 1485
- Joined: Tue May 12, 2009 2:41 pm
- SQLGeek
- Senior Member
- Posts: 3268
- Joined: Sun Feb 28, 2010 1:48 am
- Location: Richmond, TX
Re: Sock Puppet
Server error....
Ewww....who wrote that SQL query?
Code: Select all
Error, query failed Table './securetheborder/section' is marked as crashed and last (automatic?) repair failedSELECT SC.*, S.directory, S.default_id, S.section FROM sectioncontent SC, section S WHERE SC.ID = 1 AND SC.section_id = S.section_idPsalm 91:2
-
AJ80
- Senior Member
- Posts: 238
- Joined: Mon Feb 01, 2010 10:37 pm
Re: Sock Puppet
That's nothing compared to some of the SQL monstrosities I've written at work.SQLGeek wrote:Server error....
Ewww....who wrote that SQL query?Code: Select all
Error, query failed Table './securetheborder/section' is marked as crashed and last (automatic?) repair failedSELECT SC.*, S.directory, S.default_id, S.section FROM sectioncontent SC, section S WHERE SC.ID = 1 AND SC.section_id = S.section_id
- cbunt1
- Senior Member
- Posts: 812
- Joined: Mon Feb 09, 2009 12:48 pm
- Location: NW Houston, TX
- Contact:
Re: Sock Puppet
<hijack on>AJ80 wrote:That's nothing compared to some of the SQL monstrosities I've written at work.SQLGeek wrote:Server error....
Ewww....who wrote that SQL query?Code: Select all
Error, query failed Table './securetheborder/section' is marked as crashed and last (automatic?) repair failedSELECT SC.*, S.directory, S.default_id, S.section FROM sectioncontent SC, section S WHERE SC.ID = 1 AND SC.section_id = S.section_id
EEP!! Memories!!!
Back in my Cold Fusion days, I was called in to speed up some of the web apps. Turns out that it's easy money when the original developers start with "Select * from ..." to sort and print 3 records of data!
</hijack>
American by birth, Texan by the grace of God!
- SQLGeek
- Senior Member
- Posts: 3268
- Joined: Sun Feb 28, 2010 1:48 am
- Location: Richmond, TX
Re: Sock Puppet
I'm sure but anytime I see things like "SELECT *"...I want to run away screaming. Not a fan of the non-ANSII joins either.AJ80 wrote:That's nothing compared to some of the SQL monstrosities I've written at work.SQLGeek wrote:Server error....
Ewww....who wrote that SQL query?Code: Select all
Error, query failed Table './securetheborder/section' is marked as crashed and last (automatic?) repair failedSELECT SC.*, S.directory, S.default_id, S.section FROM sectioncontent SC, section S WHERE SC.ID = 1 AND SC.section_id = S.section_id
Psalm 91:2
- cougartex
- Senior Member
- Posts: 1805
- Joined: Fri Jan 01, 2010 3:01 pm
- Location: Golden Triangle
- Purplehood
- Senior Member
- Posts: 4638
- Joined: Thu May 29, 2008 3:35 pm
- Location: Houston, TX