Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
1 registered (id242), 24 Guests and 13 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 05/23/08
Posts: 10
Top Posters (30 Days)
Ruben 51
Gizmo 24
DennyP 24
Dunny 15
SteveS 14
AllenAyres 12
SD 10
dbremer 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#184674 - 05/24/07 12:07 PM SQL: Desc vs Describe
Steve C Offline
enthusiast
Registered: 05/05/06
Posts: 215
Loc: California
What is the difference between the Describe and Desc command? I am using "Desc ubbt_FILES" and "Describe ubbt_FILES"

When I use the Desc command instead of Describe in the SQL Command window, Desc returns a message, "9 row(s) affected by your query", while Describe displays the columns in a table.

It appears the number of rows is the number of columns in the table I am trying to describe, but it worries me because the message implies that I have changed something.

Edit after Rick's post below: Ahh, that explains it. Thanks so much!


Edited by Steve C (05/24/07 01:39 PM)
Edit Reason: Thanks
_________________________
WhitneyZone -- Whitney Hikers Association
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#184679 - 05/24/07 12:59 PM Re: SQL: Desc vs Describe [Re: Steve C]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
The SQL command box in the control panel only recognizes Describe as something that it should display the results. When you do Desc it thinks it's just an update so it shows the number of rows. It doesn't actually update anything, I just need to change it so it will recognize both Desc and Describe.
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Due Date Calculator-Calculate When Your Baby is Due
by StewartMyduedate
Today at 12:54 AM
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
Forum Stats
10491 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image