Bob Cohen wrote:
Here's my question. I wrote this query:
Select * FROM name WHERE last LIKE "d" AND choice1="2" OR choice2="2" OR
choice3="2";
What I'm looking for are records that satisfy the LIKE "d" condition
But then, Only one of the three other con
Steve Mansfield wrote:
I know this is a thorny old problem, but I'm having trouble resolving it.
Here's the set-up. I'm running Linux. The MySQL data directory (as configured
in my.cnf) is /share/mysql/data/ because I was sharing the data between Linux
and Windows on a dual-boot system. This set
Thomas Nyman wrote:
Hi
I found an instruction on the net concerning "Date Arithmetic" and which
seems to be exactly what I need to hel me get going..however there seems
to be either a mistake on my behalf or on the writers behalf.
Can anyone say whats wrong with this query
$query2="UPDATE KK_
Kip Gordon wrote:
I connect to my data base...
$dbh=mysql_connect ("localhost", "kipples_women", "") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("kipples_hotwomen");
and then I issue a query..
$query="SELECT *
FROM women
Hello,
Where do you get c headers/libraries for mysql on macosx ?
I don't seem to find them by running the mysql installer .pkg.
Thanx in advance.
Best,
hAj
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I connect to my data base...
$dbh=mysql_connect ("localhost", "kipples_women", "") or die ('I cannot connect to
the database because: ' . mysql_error());
mysql_select_db ("kipples_hotwomen");
and then I issue a query..
$query="SELECT *
FROM women
WHERE index = $
> i have a speed problem ;).
>
> table:
> title_id bigint(50),title char(200), cdate datetime
Next time, please provide information about existing indices and provide
output of EXPLAIN of the query...
> query:
> select title, max(cdate) as mdt, count(title_id) as num
> from entry
> where (date_f
Paul:
I did not realize that I sent the response directly to you instead of the
list. In any case, it did not work & now I re-start with a clean RH9
install. I thought why to wait until Monday. I need to get it done.
Thanks again. You gave me lots of new instructions to read about.
Kirt
-Or
Paul:
Did what you said. Here is the output:
% chkconfig --list mysql.server
mysql.server 0:off 1:off 2:on 3:on 4:on 5:on 6:off
What next?
Kirti
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 08, 2004 2:24 PM
To: Kirti S. Bajwa; [EMAIL PROTECTED]
S
Thomas Nyman wrote:
I found an instruction on the net concerning "Date Arithmetic" and which
seems to be exactly what I need to hel me get going..however there seems
to be either a mistake on my behalf or on the writers behalf.
Can anyone say whats wrong with this query
$query2="UPDATE KK_Fatal
hello.
i have a speed problem ;).
table:
title_id bigint(50),title char(200), cdate datetime
query:
select title, max(cdate) as mdt, count(title_id) as num
from entry
where (date_format(cdate, '%Y-%m-%d %H:%i:%s')
between '2004-05-07 00:00:01' AND '2004-05-08 23:59:59')
and
(on = 'Y')
group by ti
hi,
you should set parentheses on it
Select * FROM name WHERE last LIKE "d" AND (choice1="2" OR choice2="2" OR
choice3="2");
without it interprets it as
like "d" and choice1="2"
or
choice2="2"
or
choice3="2"
Regards
Ingo Thierack
--On Freitag, 7. Mai 2004 13:51 -0400
I've heard somwhere that developpers of mySQL 5 are working on implementing
an object oriented database of mySQL is that true? in this case can i have
help on how to use the object side of the database?
thanks
_
MSN Search, le moteu
Paul DuBois wrote:
At 16:02 -0700 5/7/04, Matthias Eireiner wrote:
Hi there,
I have a question regarding the STD()/STDDEV() function. In the manual
it says, that STD() is the square root of VARIANCE() and for VARIANCE
it says it is first implemented in 4.1. But when I look at the 4.1.
changes it
At 14:08 -0400 5/8/04, Kirti S. Bajwa wrote:
Hello List:
I have been learning MySQL. I have installed & tested MySQL server 3-4 times
without problem. This time I used the an "alpha-nightly snapshot" and have
run into problems.
My current Installation:
--
LINUX RH9
Source Insta
Hello List:
I have been learning MySQL. I have installed & tested MySQL server 3-4 times
without problem. This time I used the an "alpha-nightly snapshot" and have
run into problems.
My current Installation:
--
LINUX RH9
Source Installaion: mysql-5.0.1-alpha-nightly-20040504.t
At 16:02 -0700 5/7/04, Matthias Eireiner wrote:
Hi there,
I have a question regarding the STD()/STDDEV() function. In the manual it
says, that STD() is the square root of VARIANCE() and for VARIANCE it says
it is first implemented in 4.1.
But when I look at the 4.1. changes it only says: "Added ne
Hi there,
I have a question regarding the STD()/STDDEV() function. In the manual it
says, that STD() is the square root of VARIANCE() and for VARIANCE it says
it is first implemented in 4.1.
But when I look at the 4.1. changes it only says: "Added new VARIANCE(expr)
function returns the variance o
A hash is a key value pair
i.e. if you want a value for a unique key (in perl anyway) you can do
this...
%status = (
1 => "true",
0 => "false"
);
If I have a variable that hold an integer such as
$test = 1 I c
Hello everybody,
I'm back! (been a subscriber here before, a while ago .. was quite an active
one at that time .. ;)) .. and I'm back for a reason, having a very wicked
problem. The setup is one RedHat linux 9 machine (called "s007"), previously
in use as both our web and database server. As traf
Hello everybody,
I'm back! (been a subscriber here before, a while ago .. was quite an active
one at that time .. ;)) .. and I'm back for a reason, having a very wicked
problem. The setup is one RedHat linux 9 machine (called "s007"), previously
in use as both our web and database server. As traf
Robert Reed wrote:
Greetings,
I've recently inherited a FreeBSD server running MySQL
3.23.54. It's good and stable. I have a second
server that runs as a slave to the first. Everything
goes smoothly until I make changes to a certain table
on my master. This will kill the slave with the error
t
Hi,
Can someone clarify the following.
When I use statement
LOCK TABLES t1 WRITE, t2 READ, ...;
Am I garanteed that locking will be performed in the
order t1, t2, etc.? If not, use of this on multiple
threads will produce locks. Manual says to use this
statement, but it does not say if the order
On Wed, 2004-05-05 at 22:49, Paul DuBois wrote:
> At 22:39 -0400 5/5/04, Nathan Jones wrote:
> > > Hi there,
> >>
> >> I seem to be having a problem retrieving the last inserted ID for a
> >> table.
> >>
> >> The query I am using is as follows:
> >>
> >
> >It's far easier than anyone else has m
Hello,
I have a number of databases, and associated web page files written for
the SmithMicro product WebDNA.
Basically it is a shopping cart program, but I am using it for database
driven dynamically produced web pages.
I need to convert my files to MySQL and use php web pages as the front
end for
Is it possible to copy a working MySQL database and a
page driven by that database to another website? If
so, it would a great learning resource - a working
model.
I jumped into the world of PHP and MySQL a few weeks
ago. I'm now working with PHP includes, but I've
barely scratched the surface of
Bob Cohen wrote:
Here's my question. I wrote this query:
Select * FROM name WHERE last LIKE "d" AND choice1="2" OR choice2="2" OR
choice3="2";
To predict the outcome of this query requires knowledge of the precedence of
AND vs. OR in mysql. I can't find it documented anywhere, but I think AND
Hi MySQL Gurus,
I am pretty green at SQL DB anything, so please bear
with me.
I would like to input new/pertinent data into my main
table as fast/efficiently as possible. From reading
Paul DuBois books, the Reference Manual and a few
other sources I am convinced that LOAD DATA will be
faster tha
El Vie 07 May 2004 00:20, escribió:
(...)
>
> My knowledge of OpenMosix is extremely limited. I've not heard of
> anyone successfully using MySQL with OpenMosix for fail-over. That
> doesn't mean it hasn't been done, but it'd be news to me.
>
> I assume you've also asked on the relevant OpenMosix
Thanks to Bernard, Sunmaia, and Ingo! I knew the query wasn't quite
right.
Bob Cohen
b.p.e.Creative
http://www.bpecreative.com
Design and production services for the web
Put creative minds to work for you
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
Yes, the file permissions do affect whether the table can be updated.
The files need to be writable (in the filesystem sense) by the user
running mysqld.
By default MySQL creates directories umask 0700 and files 0660 unless
the UMASK env variable is set differently when mysqld is started. If yo
Also interested in answer to this one.
Terry Riley
--Original Message-
> Hi List,
>
> When can we expect limits in sub-queries? I am currently on 4.1.0.
>
> 1235 - This version of MySQL doesn't yet support 'LIMIT &
> IN/ALL/ANY/SOME
> subquery'
> Query:
>
--
MySQL Gener
Hi Reed,
Unfortuntaely I am unable to answer your question, but my presentation "Using
MySQL in a Japanese environment ... and avoiding common pitfalls" is online
at
http://www.be-known-online.com/mysql/
Hope that helps.
On Friday 07 May 2004 12:02, Ed Reed wrote:
> Where's the presentations?
I know this is a thorny old problem, but I'm having trouble resolving it.
Here's the set-up. I'm running Linux. The MySQL data directory (as configured
in my.cnf) is /share/mysql/data/ because I was sharing the data between Linux
and Windows on a dual-boot system. This set-up has been working fi
Hi
I found an instruction on the net concerning "Date Arithmetic" and which
seems to be exactly what I need to hel me get going..however there seems
to be either a mistake on my behalf or on the writers behalf.
Can anyone say whats wrong with this query
$query2="UPDATE KK_Fatalie SET datum = D
test disregard
--
=
- Linux rocks!!! http://www.dedserius.com/
=
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
The backslash (\) is an escape character
(http://dev.mysql.com/doc/mysql/en/String_syntax.html).
So to enter a backslash into a text field, you would have to say:
txtSceneFile = "C:\\Data\\test\\foo\\bar.lws".
Lou
- Original Message -
From: "Steve Pugh" <[EMAIL PROTECTED]>
To: <[EMAIL P
<>
Very much. Thanks to all who responded.
http://ciips.ee.uwa.edu.au/~morris/Year2/PLDS210/hash_tables.html was
helpful as well.
Lou
- Original Message -
From: "Andy Ford" <[EMAIL PROTECTED]>
To: "Lou Olsten" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, May 05, 2004 6:
Hello,
this maybe a more related issue with DBI API but I thought I try first posting
here to see why we would be getting this error (24) - Too many open files
Error Message:
DBD::mysql::st execute failed: File './mysql/user.MYD' not found (Errcode: 24)
What would be causing this type of error
You need parenthesis around cond1 OR cond2 OR cond3 otherwise effectively you
are going to get all records matching the following:
last "d" AND choice1="2" + choice2="2" + choice3="2"
Therefore, you select statement should be written:
SELECT * FROM name WHERE last LIKE "d" AND (choice1="2" OR ch
Hello,
I have been working with the C API in version 4.1.1. I encountered a
problem which I thought might be resolved in version 5.0.0, so I have loaded
the RPMs for version 5.0.0 onto my development RedHat Linux system.
-
Problem 1 - can't
My grasp of computing theory isn't terribly strong or theoretical so I hope
others will correct me if anything I say here is inaccurate
I got curious to see if I could find a good basic description of hashing
online so I did a Google search on "hash index". I was surprised how many
hits I had
I am trying to find all my empty records. I am looking for NULLs and Empty
strings but is there a simple way to just as this? I thought MySql may have
something built in.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAI
I beleive this is the built-in word list file you were looking for. And the
word "beyond" was in the list. It would probably be helpful if there were
a SHOW command that listed the active built-in stopwords.
Ed
-
#include "ftdefs.h"
ulong ft_min_word_len=4;
ulong ft_ma
Hi,
I would like to hear from you what would be the best way to design
tables with a conditional relationship between them.
I am callin this a conditional relationship, because the external link
can be to one table or to another, but not for both at the same time,
in the same record.
Here is t
Hi,
I'm using MySQL 3.23.53 on W2000 and I have a following problem: when I
restart the database server then the first attempt to connect from any
client program last cca 30 seconds (too long!!), each next attempt to
connect lasts less than one second. The traffic is usually very small, so it
can'
Joseph,
Have a look at http://dev.mysql.com/tech-resources/features.html. It lets
you compare MySQL to various other popular databases.
Warning: I'd take this information with some caution. I don't mean to
suggest that it is false, just that the emphasis seems to be on making MySQL
look good and
On Thu, May 06, 2004 at 11:29:18AM -0600, Alfredo Cole wrote:
> El Jue 06 May 2004 11:05, escribió:
> > On Thu, May 06, 2004 at 06:55:38AM -0600, Alfredo Cole wrote:
> >
> > At the time I wrote Chapter 8 of High Performance MySQL, I tried to
> > discuss the available options:
> >
> > http://www.o
Here's my question. I wrote this query:
Select * FROM name WHERE last LIKE "d" AND choice1="2" OR choice2="2" OR
choice3="2";
What I'm looking for are records that satisfy the LIKE "d" condition
But then, Only one of the three other conditions need be t
Hi there, I am having some issues between two tables and foreign keys.
Here is the two tables I have setup.
| complaints |CREATE TABLE `complaints` (
`complaintID` int(11) NOT NULL auto_increment,
`ticket_number` varchar(20) NOT NULL default '',
`complainant_name` varchar(100) NOT NULL defa
50 matches
Mail list logo
