> -Original Message-
> From: Andy Ingham [mailto:[EMAIL PROTECTED]]
>
> We've been running Cold Fusion with MySQL on the Solaris platform for
> almost two years now and have had such terrible problems with Cold
> Fusion errors that we have begun the process of migrating to
> PHP. Our
>
Yeah, any lookups based on char based columns are slower
than integer queries any day. I'm assuming it's a char
column because you're searching with apostrophe's '0'.
Would a "between" statement in the where clause help?
select * from experian.experian
where latitude between '038631928
> -Original Message-
> From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
> Subject: Re: Disable case sensitivity
> > If is possible, in everything from a Database, but if
> is not, in columns
> > is more important.
>
> Column names are case insensitive.
Correct... Database names
Amazing! I've not had a chance to upgrade a server to
2.4 yet, though I've long imagined that the results would
be similar.
I imagine the biggest performance boost you received is
due to the built-in multi-threading that the 2.4 kernel
enjoys which is currently lacking in the 2.2 kernel.
L
Not knowing the exact internals of how it works...
Assuming that it works much the same way other RDB's
work in their native GL's (generation languages), the
common practice with a relational database is to define/declare
a "cursor" with the SQL statement executed against the database.
After the
Basically, the "mysql_query" submits the sql statement
to the database engine, and the "mysql_fetch_array"
allows retrieval of selected information returned from
the query into an associative array with each columnname
of the query an associative "key" in the array
Example...
--login-to
Rember that the sum function sums the total of all
of the colum specified. Is there multiple rows where
the same c.cid_no occurs many times? If so, then you
need a "group by" and "having" clauses. If not,
then you don't need the sum function.
With a group by, it'd look like this... I think ..
I think it's like this...
alter table hrcontract drop index login
... assuming the name of the key is "login". You can
have key names (which is what a unique constraint
is) and column names of the same name.
If you do a ...
show index from hrcontract
... it'll show you all of the "key_na
Hello,
My boss is going through the mysql.com tutorials starting at ...
http://www.mysql.com/articles/ddws/12.html
... and currently stuck at ...
http://www.mysql.com/articles/ddws/13.html
The boss is using phpMyAdmin to access the database, and everything
has been working just fine
