Joe Kaiping writes:
> Is it expected that using the LOWER function should greatly increase query
> time?
The way you do it, yes.
Is that email column a BLOB or a BINARY VARCHAR? If not,
why on earth do you do LOWER() on it? And do you have an
index on the column?
//C
--
Carl Troein - CĂrdan
I obviously missed something because I have installed MySQL
many times but this time MySQL GUI would not except localhost in
MySQL GUI Options.. but it would work with the actual Host name.
Note same versions of all the above with the same Linux kernel
work on two other installs.. All have localh
On Sat, 29 Sep 2001, Benjamin Pflugmann wrote:
> Hi.
>
> On Sat, Sep 29, 2001 at 12:43:25PM +0530, [EMAIL PROTECTED] wrote:
> [...]
> > I am trying the below sql statement:
> > select na.id as naid, na.nid, na.date from newsarticles na, newscodes nc
> > where na.nid=nc.id and na.nid=1 or na.nid=
Hi Srinivas !!
>
> Hi All,
> According to the guidance in the list (Thanks for guidance), I have
> set up MySQL-3.23.42 server on Linux, and unixODBC-2.0.9 &
> MyODBC-2.50.39 on other Linux m/c. I was able to communicate and
> sucessfully execute a test program mentioned in the document.
> Hi All,
> According to the guidance in the list (Thanks for guidance), I have
> set up MySQL-3.23.42 server on Linux, and unixODBC-2.0.9 &
> MyODBC-2.50.39 on other Linux m/c. I was able to communicate and
> sucessfully execute a test program mentioned in the document. Now I
> want to know
Hi All,
According to the guidance in the list (Thanks for guidance), I have
set up MySQL-3.23.42 server on Linux, and unixODBC-2.0.9 &
MyODBC-2.50.39 on other Linux m/c. I was able to communicate and
sucessfully execute a test program mentioned in the document. Now I
want to know what al
Paul DuBois> INSERT IGNORE can't fully assess whether the record is to be
ignored
Paul DuBois> until the record's contents have been generated.
And why can't it wait until after the ignore/don't ignore assessment before
assigning a new id? Call it a bug... call it a design feature... call it
wha
Dear all the mysql DBA:
I'm currently using
mysql Ver 11.9 Distrib 3.23.29a-gamma, for pc-linux-gnu (i686)
May I know is there any workaround for using INTERSECT in this version.
Thanks
SQL and Mysql newbie.
Wee
-
Before p
At 6:45 PM -0500 9/30/01, Reuben D Budiardja wrote:
>Hi,
>I am a newbie in MySQL. I use an auto_increment to insert to one of the
>column. How do I get the value inserted?
>
>The documentation seems to suggest using mysql_insert_id() function. But when
>I tried to call it using
>Select mysql_inser
At 11:44 AM +1200 10/1/01, marcus davy wrote:
>If you specify the keyword IGNORE in an INSERT, any rows that duplicate
>an existing PRIMARY or UNIQUE key in the table are ignored and are not
>inserted.
>But the last_insert_id() function still appears to increment by one
>in situations when the que
At 2:43 AM +0100 10/1/01, Corin Hartland-Swann wrote:
>Hi Monty,
>
>I've been experimenting with ENUM NOT NULL columns without a default
>value. The documentation (section 6.5.3 again) states:
>
>"If no DEFAULT value is specified for a column, MySQL automatically
>assigns one. If the column may ta
Dear all the mysql DBA:
I'm currently using
mysql Ver 11.9 Distrib 3.23.29a-gamma, for pc-linux-gnu (i686)
May I know is there any workaround for using INTERSECT in this version.
Thanks
SQL and Mysql newbie.
Wee
-
Before po
Hi Monty,
I've been experimenting with ENUM NOT NULL columns without a default
value. The documentation (section 6.5.3 again) states:
"If no DEFAULT value is specified for a column, MySQL automatically
assigns one. If the column may take NULL as a value, the default value is
NULL. If the column
You were close to it.
But he way to get the last inserted item on AUTO_INCREMENT field is for
example:
id = mysql_insert_id(&mysql);
printf("The last insert is: %d\n", id);
And mysql is what was return to you when you open your connection to the
database.
Daniel
> Hi,
> I am a newbie in MyS
If you specify the keyword IGNORE in an INSERT, any rows that duplicate
an existing PRIMARY or UNIQUE key in the table are ignored and are not
inserted.
But the last_insert_id() function still appears to increment by one
in situations when the query is not adding any new information to
the tab
MySQL is not Oracle ... and that's a good thing, too! :-)
Tom Haapanen
[EMAIL PROTECTED]
-Original Message-
From: Joe Kaiping [mailto:[EMAIL PROTECTED]]
Sent: 30 September 2001 19:37
To: [EMAIL PROTECTED]
Subject: RE: why would LOWER
Thanks to all for your responses. I had missed t
Hi,
I am a newbie in MySQL. I use an auto_increment to insert to one of the
column. How do I get the value inserted?
The documentation seems to suggest using mysql_insert_id() function. But when
I tried to call it using
Select mysql_insert_id()
or
Select mysql_insert_id() from TABLE_NAME
giv
Thanks to all for your responses. I had missed this important piece of
information in the documentation that Benjamin pointed to and:
http://www.mysql.com/doc/C/H/CHAR.html
"Values in CHAR and VARCHAR columns are sorted and compared in
case-insensitive fashion, unless the BINARY attribute was
Just re-install ... you don't need to uninstall.
- Original Message -
From: "James Pembleton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, September 30, 2001 3:51 PM
Subject: Need to uninstall - Win98
I am just learning MySQL and would like to uninstall so that I can
reinsta
One suggestion if I may.
As this field is for email address and email are not case sensitive in the
first place. Wouldn't it make sense to change the case of all the email in
the database to be lower and also make sure that what even you use to enter
new email address in the database actually con
Hi.
You cannot change the sorting behaviour of MySQL to achieve what you
want.
There are several possible work-arounds, though. One is to save the
numbers in a way (inserting zeros) that sorting will work, if that is
feasible:
5.10
5.13
5.02
5.02.08
5.03
5.27
If the depth (here: 3) of punctuat
Hi.
The problem is that LOWER(email) is an expression and expressions on
the left hand side of an comparison cannot use an index with MySQL
(see also http://www.mysql.com/doc/M/y/MySQL_indexes.html).
If you usually want to compare emails ignoring case, an easier way is
to assure that email is no
I am just learning MySQL and would like to uninstall so that I can
reinstall. I have tried the Windows method but the "Uninst.isu" file cannot
be found. I am considering this database for a software application and
this ability will be needed in testing. Please advise.
James Pembleton
--
Hi.
Sorry, but does your question have to do with MySQL? Wouldn't the PHP
list (or some source about CGI programming) be a better place to ask?
On Sun, Sep 30, 2001 at 08:21:35PM +0200, [EMAIL PROTECTED] wrote:
>
> Ok, This must be a fimiliar login script. I want to change the target of
> werk.
Hi.
On Sun, Sep 30, 2001 at 01:11:52PM -0400, [EMAIL PROTECTED] wrote:
> I am running Apache with mod_perl (Apache::DBI is off) with connections to
> MySQL.
>
> I'm finding that the number of connections used by perlhttpd seems to be
> too high. I did this:
>
> [root@sg3 root]# ps -A | grep mys
Hi.
I am trying to create a SQL statement that sorts by a column that
contains a mix
of numbers and periods, but it doesn't seem to work properly.
The statement I use is:
SELECT ItemNumber FROM Catalog ORDER BY ItemNumber
For instance, here is how the list was sorted:
5.2.8
5.2
5.3
5.13
5.10
Hi.
I am trying to create a SQL statement that sorts by a column that contains a mix
of numbers and periods, but it doesn't seem to work properly.
The statement I use is:
SELECT ItemNumber FROM Catalog ORDER BY ItemNumber
For instance, here is how the list was sorted:
5.2.8
5.2
5.3
5.13
5.10
The table has less than 200,000 records, but the table has quite a few
columns and there is an index on ind for the columns (cust,email). MySQL
3.23.36 is running on a Sparc with 1 gig RAM. The ind table type is MyISAM
and the cust field is an INT and the email field is a VARCHAR.
I was wonderi
Hi.
Have a look at your my.cnf (and the according manual entries). There
you can specify how much memory MySQL is allowed to use.
MySQL doesn't release memory it's allowed to use for caching.
Bye,
Benjamin.
PS: There is nothing such as "linux 7.1". Linux (the kernel) exists in
versio
Hi.
On Mon, Oct 01, 2001 at 12:37:58AM +0800, [EMAIL PROTECTED] wrote:
> On Sun, Sep 30, 2001 at 11:07:37AM -0500, Gunter Leeb wrote:
> > Hi,
> >
> > Consider Name LIKE 'ABC%' finds all names that start with ABC.
> >
> > I am looking for the reverse: I have a string and I am looking for
> > all
You didn't mention how large your table is or if the email and cust fields
are part of an index.
In many situations, the results you are seeing make perfect sense to me. If
email is a part of an index then the LOWER function may need to be performed
on each value of email in the index before the
Hi.
This behaviour is described in http://www.mysql.com/doc/B/u/Bugs.html.
You can circumvent the behaviour with an temporary table for saving
the intermediate result.
Bye,
Benjamin.
On Sun, Sep 30, 2001 at 12:50:37PM +0200, [EMAIL PROTECTED] wrote:
> Hi,
>
>
> I encountered a pro
Hi there,
Is it expected that using the LOWER function should greatly increase query
time? Or is there a MySQL setting that can help speed it up? Below are the
results of a query against a table that has an index on cols (email,cust).
Using LOWER increases the query time by 10.5 seconds. (eek!
Hi.
With MySQL, there is not (yet) a way to do this with a single
command. A poor SQL work-around is possible, but a bit bloated.
On the other hand, ta.f1 is a redundand field (regarding tb.af1) and
therefore you normally would seldom need a command such as the one
below.
One (quite probably no
Hi.
On Sat, Sep 29, 2001 at 05:27:40PM -0500, [EMAIL PROTECTED] wrote:
> I recently lost my main drive (linux), but I was mirroring nightly the
> contents of all my directories to another drive using mirrordir.
>
> I'm a bit of a mysql newbie...can anyone tell me (first) where in the
> directory
Hi
Ok, This must be a fimiliar login script. I want to change the target of
werk.htm in the header to a specific frame. How to do that? something like
in html
Danny
FROM user
WHERE username='$PHP_AUTH_USER' and
password='$PHP_AUTH_PW'";
$result = mysql_query($sql);
$num = m
Hi.
Thanks for the proposal, but my test was with the C library, not with
ODBC as the original one. Aside from that: It's too fast. Using ODBC
only could have made it slower, so it's still to fast regardless.
Bye,
Benjamin.
On Sat, Sep 29, 2001 at 09:29:22PM -0400, [EMAIL PROTECTED]
put an index on shost, that will speed the query
-Original Message-
From: Dan Rowe [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 30, 2001 3:50 PM
To: [EMAIL PROTECTED]
Subject: Slow query problem
I am currently running Mysql 3.23.41 on a E250, 2x 400mhz proc with half a
gig of memo
Dear all,
i used mysql on linux 7.1. And i discovered mysql not free the memory .
pls advise !1
1:24am up 1 day, 10:11, 2 users, load average: 1.13, 1.26, 1.31
65 processes: 63 sleeping, 2 running, 0 zombie, 0 stopped
CPU0 states: 4.2% user, 1.3% system, 0.0% nice, 93.3% idle
CPU1 stat
> ms sql server is in our school and since i want to learn mysql, i want
> to copy the sammple databases from the school to my house. how do i do
> that? from ms sql --> txt --> mysql?
The method I outlined is exactly that mssql->txt->mysql.
Obviously, since the two machines do not seem to be net
I am running Apache with mod_perl (Apache::DBI is off) with connections to
MySQL.
I'm finding that the number of connections used by perlhttpd seems to be
too high. I did this:
[root@sg3 root]# ps -A | grep mysqld | wc
88 3532743
[root@sg3 root]# /etc/httpd/bin/perlhttpdctl restart
On Sun, Sep 30, 2001 at 01:00:07PM -0400, Will French wrote:
> I'm not sure what you mean by "stand-alone". If you mean not connected to a
> network then I don't see how since ms-sql-server only runs on Windows and
> you have specified that your mysql server is linux.
>
> Unless you have a huge
I'm not sure what you mean by "stand-alone". If you mean not connected to a
network then I don't see how since ms-sql-server only runs on Windows and
you have specified that your mysql server is linux.
Unless you have a huge schema (lots of tables and/or lots of columns) I
would suggest using th
how can i transfer a database from sql server to mysql (linux) on a
stand-alone ws?
--
"When you have eliminated the impossible,
whatever remains, however improbable,
must be the truth."
--Sherlock Holmes _The Sign of Four_
--
On Sun, Sep 30, 2001 at 11:07:37AM -0500, Gunter Leeb wrote:
> Hi,
>
> Consider Name LIKE 'ABC%' finds all names that start with ABC.
>
> I am looking for the reverse: I have a string and I am looking for all the records
>that have a name which is the BEGINNING of this
> string. As an example:
Hi,
Consider Name LIKE 'ABC%' finds all names that start with ABC.
I am looking for the reverse: I have a string and I am looking for all the records
that have a name which is the BEGINNING of this
string. As an example: I have'ABCDE' and I want rows contains 'ABCD' or 'ABC' or
just 'A' f
I am currently running Mysql 3.23.41 on a E250, 2x 400mhz proc with half a
gig of memory, 6 9.1gig scsi disks in raid5 and Solaris 7.
The database i have a database with 88365 records and expanding daily (it
holds syslog messages for various servers)
Table desc:
+---+--+--
Hi,
I encountered a problem with a DISTINCT query (mySQL-3.23.42). I need to
order by a field not contained in the field set of the SELECT clause. The
following query works correctly:
SELECT DISTINCT
p.lastchanged AS lastchanged,
p.dam_id AS dam_id,
d.dam AS dam,
I have a table in a mysql database that contains data from two
different languages using two different character sets. I need to be
able to query in either language. Queries that I run against the data
in English seem to run fine. However, queries against the data in
the other language give
run the perror app provided with your distrobution
perror 13
Casey Tourangeau wrote:
>
> Hi,
>
> I'm using MySQL v3.23.42 with Mac OS 10.1, and whenever I try to
> create a database (logged in as root), i get the error "create database
> 'name'. (errno: 13)".
>
> Does anyone h
50 matches
Mail list logo