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
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 true:
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:
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
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
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
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
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:
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
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
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 choice2=2 OR
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
Hope this helps
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,
test disregard
--
=
- Linux rocks!!! http://www.dedserius.com/
=
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
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 =
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
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?
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 General
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
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
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
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
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
has
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
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
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 mentioned, as of my
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
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
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
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
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 can do
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
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
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:
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
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
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
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 Bob Cohen
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
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_Fatalie
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]
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
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
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 = $id;
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]
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
WHERE
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
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
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 conditions
49 matches
Mail list logo