DB
> works.
>
> From the manual:
> SHOW TABLE STATUS does not give accurate statistics on InnoDB tables,
> except for the physical size reserved by the table. The row count is
> only a rough estimate used in SQL optimization.
>
>
> On Nov 16, 2004, at 11:58 AM, Jeff Burgo
I have table with 83,065 rows. Each time I go to MySQL Administrator and
look at the catalogs, the number of Rows reported by the administrator
changes. I can keep clicking refresh and the number of rows fluctuates
between roughly 81,000 and 86,000. I also see similar behavior when I
access the
Good one. I don't know how I missed this either!
Thanks!
"gerald_clark" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> What about
> select distinct a.region, a.city
> from mytable a , mytable b
> where a.region=b.region and a.city <> b.city
>
> Jay Blanchard wrote:
>
> >[snip]
>
Anybody?
""Jeff Burgoon"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Sorry, I forgot to mention I am using version 4.0.20a (no subqueries
> supported)
>
> ""Jeff Burgoon"" <[EMAIL PROTECTED]> wrote in message
&
This will solve your problem and remove the need for the PHP correction.
SELECT lname, teamno, game_pts, sport_pts, ref_pts, adjust_ref_pts,
CASE
WHEN ref_pts + adjust_ref_pts > 15 THEN game_pts + 15
ELSE game_pts + ref_pts + adjust_ref_pts
END AS total_pts,
CASE
WHEN ref_pts + adjust_ref_pts > 15
Sorry, I forgot to mention I am using version 4.0.20a (no subqueries
supported)
""Jeff Burgoon"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I have a simple problem and I'm just wondering the BEST query to solve it.
> I want to return all
I have a simple problem and I'm just wondering the BEST query to solve it.
I want to return all the rows of a table whose foreign key value exists more
than once in that table. IE...
MyTable
Region(foreign key)City
EastBaltimore
EastPhil
I'm populating a new table from excel sheets and for some silly reason
several column values are populated with "\" (not my doing!).
I can easily fix the problem but I was just wondering.
Thanks Everyone.
""Jay Blanchard"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
[snip]
What'
Why does selecting backslash give me an error?
select "\"
gives me...
#1064 - 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
'"\"' at line 1
select "/"
returns "/"
select "\\"
returns "\"
What's the
I'm trying to perform a query where I transpose cell values from a table
into column names with totals. For example, I have the following table and
I'd like to produce the view at the bottom:
SitePartQuantity
Site APart 15
Site A
query, get some records from
> that temp table AND set another variable, then finally get another record
> that contained the values of both temporary variables. After all that, I
> dropped my temporary table and closed the connection. I am nearly 100%
> certain that the combined
MyODBC? If
so, can you tell me how you turn it on/off?
Thanks again!
"Victor Pendleton" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> What version of MySQL are you using? I believe multiple delimited
> statements are available in 4.1.x and later.
>
> J
4.0.20a-max, just because I thought this was the most stable build.
"Victor Pendleton" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> What version of MySQL are you using? I believe multiple delimited
> statements are available in 4.1.x and later.
>
>
I'm writing my first MySQL app in VB.net using myODBC. However I think this
question applies to all languages using MySQL. From what I understand, I
am unable to issue a batch statement of commands separated by commas to
mySQL. I receive an error whenever I try to do so from my app. For this
r
14 matches
Mail list logo
