; mysql@lists.mysql.com
Cc: wi...@lists.mysql.com; mysql-h...@lists.mysql.com
Subject: RE: Please help me.
Velentin,
http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html
Note the section for the droping of foreign keys used the contraint name,
not the key name. Try
Velentin,
http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html
Note the section for the droping of foreign keys used the contraint name, not
the key name. Try this and see if it solves the first problem (of removing the
constraint). Then you should be able to drop the
On 6/2/06, yuan edit [EMAIL PROTECTED] wrote:
my operating system is linux redhat 9.0.
i am installing mysql 5.0.x binary distribution.
Which edition is the most fit in the following editions?
You notices most of those files are .asc and .md5 used to verify the
integrity of the archive after
John thegimper wrote:
This is what i need:
Posted by gogman on Monday May 5 2003, @10:42am on the mysql website:
MySQL defaults to an 'OR'. Example: 'dog cat' = 'dog OR cat'. Most fulltext
search engines default to an 'AND'. These include: AltaVista, Fast Search,
Svensson [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Please help me: Boolean fulltext searches, AND instead of
OR
Date: Wed, 23 Mar 2005 22:32:49 +0100
Hi!
On Mar 23, Jessica Svensson wrote:
Is there any way i can get results with AND instead of OR?
Trying to search for black
!!
From: Sergei Golubchik [EMAIL PROTECTED]
To: Jessica Svensson [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: Please help me: Boolean fulltext searches, AND instead
of
OR
Date: Wed, 23 Mar 2005 22:32:49 +0100
Hi!
On Mar 23, Jessica Svensson wrote:
Is there any way i can
I couldn't find much on the variable you were trying to change.
Although it may have changed and now be called ft_boolean_syntax. But
that still won't help you since it doesn't appear to have an option to
change the default separator.
I think you will need to add the + to each word if you want
Hi!
On Mar 23, Jessica Svensson wrote:
Is there any way i can get results with AND instead of OR?
Trying to search for black cat should only return records that contains
both black and cat.
I'm using the following code to get my result:
SELECT * FROM `searchtbl` WHERE MATCH (text)
show results with all words present.
This is what i did, set global ft_boolean_syntax = ' +-()~*:|'
I really appreciate your help!!
From: Sergei Golubchik [EMAIL PROTECTED]
To: Jessica Svensson [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: Please help me: Boolean fulltext searches
= ' +-()~*:|'
I really appreciate your help!!
From: Sergei Golubchik [EMAIL PROTECTED]
To: Jessica Svensson [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: Please help me: Boolean fulltext searches, AND instead of OR
Date: Wed, 23 Mar 2005 22:32:49 +0100
Hi!
On Mar 23, Jessica Svensson
Mohammed Sameer [EMAIL PROTECTED] wrote:
I'm running a MySQL server on a duel P III 1G, with 2 GB RAM.
MySQL 4.0.18 compiled from source.
We have 2 webservers running apache, And this is the backend database server.
The server is really slow.
a select on a table with 138,247 rows takes about
sorry Egor Egorov, Mutt sent the mail to your private inbox ;)
resending to the mailing list.
On Wed, May 19, 2004 at 02:02:29PM +0300, Egor Egorov wrote:
Mohammed Sameer [EMAIL PROTECTED] wrote:
I'm running a MySQL server on a duel P III 1G, with 2 GB RAM.
MySQL 4.0.18 compiled from source.
Something that small shouldn't really need optimizing. What is the size
of your data (mb?, gb?) and what does your query look like? If you are
doing a wild card search on a large text field without a full text
index, then those times may be the best you're going to get. Many times
it's about
On Wed, May 19, 2004 at 08:47:28AM -0400, Brent Baisley wrote:
Something that small shouldn't really need optimizing. What is the size
of your data (mb?, gb?) and what does your query look like? If you are
doing a wild card search on a large text field without a full text
index, then those
I wouldn't upgrade until you know where the bottleneck is (CPU, disk,
network, or RAM). Since you are using professional software, I
wouldn't try to change the queries. Have you made changes to your
my.cnf file? Since you have enough ram to hold all the data, ram is
probably not your
On Wed, May 19, 2004 at 11:36:38AM -0400, Brent Baisley wrote:
I wouldn't upgrade until you know where the bottleneck is (CPU, disk,
network, or RAM). Since you are using professional software, I
wouldn't try to change the queries. Have you made changes to your
my.cnf file? Since you have
on 05/19/2004 08:36 AM, Brent Baisley at [EMAIL PROTECTED] wrote:
I wouldn't upgrade until you know where the bottleneck is (CPU, disk,
network, or RAM). Since you are using professional software, I
wouldn't try to change the queries. Have you made changes to your
my.cnf file? Since you have
As this is really a PHP specific question, you may get a better response on the PHP
general mailing list at http://www.php.net/mailing-lists.php
Anyway, if my limited experience in PHP serves correctly, you may need to call
echo(mysql_error()); near the potentially troublesome code.
Regards,
On Friday 28 March 2003 13:59, Ing.Peter Misovic wrote:
i have deleted mysql database,
can i restore it with start defaults ?
mysql_install_db is your solution. :)
Thailon, Slovakia
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by
Natale,
please address these general questions to [EMAIL PROTECTED]
InnoDB requires that the indexes are created explicitly. It would require a
change to MySQL to automate the creation of them.
Without indexes foreign key checks would be very slow because then every
check would have to do a
At 23:49 29/5/2002 -0400, Charles Brown wrote:
Hi,
I removed the user= and password= entries from the my.ini
file, because I didn't like seeing a password exposed in plain text.
This seemed to have no effect on MySQL at all. What are those
entries for? Do I need them? What should they be? The
Whats your INSERT statement look like? And does it give any errors back?
-Nick
I am
using MySql with Visual Basic.
I Got an ERROR when trying to add a new record in
situation as under.
I have a table Company
and a field in that table EmpName char
(20)
and one record is there value is =
Hi try http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/page1.html
for good tutorials on PHP and MySQL, although biased toward Unix, I suppose
it should work in a similar way on IIS. Maybe wrong?!
snip
?
$dbuser = 'root';
$dbhost = 'localhost';
$dbpass
Although this is not a php list...
mysql_connect() returns TRUE on success and FALSE on
failuer, so testing $link like if($link) means it
did connect.
your script should read:
$link=mysql_connect(localhost)
// the !(bang as it is called) means NOT
// so !TRUE == FALSE
if(!$link) {
On Thu, 29 Nov 2001, anandakkumar araskumar wrote:
Hi all
Iam new to php and iam learning that from scratch.I
came across a problem in connecting mysql from php
script.I run php in windows2000 under IIS configured
to personal web server.I have installed mysql
with server and client and
katty Iniguez [EMAIL PROTECTED] writes:
I use Linux RedHat 7.0
I installed and Configured MySQL-3.23.42
I am installing icradius-0.18.1
installing icradius I got the following:
make: /usr/bin/ld: cannot find -lmysqlclient
collect2: ld returned 1 exit status
make: *** [radius]
From: katty Iniguez [EMAIL PROTECTED]
make: /usr/bin/ld: cannot find -lmysqlclient
collect2: ld returned 1 exit status
make: *** [radius] Error 1
Now, i added the line: /proc/6/fd/mysqlclient - - - (that is where I found
lmysqlclient)
This location probably isn't what you want. You
On Fri, Aug 31, 2001 at 05:44:11PM +0800, Wang Aocheng wrote:
Dear All,
I have a question:
How can build multi-master-host?
I have 3 mysql hosts,I want to use mysql data replicate. thanks!
And you want all 3 to be masters?
If so, you need to configure them in a
Read the man page for gcc and note the command line switch to point the
linker at specific libraries, then use those switches on the command line.
This is a linker error, rather than a compiler error:
Example:
g++ myGreatProgram.cpp -L/usr/mysql/lib -lmysqlclient
On Wednesday 18 July 2001
[root@sp mysql]# chown -R root /usr/local/mysql -- The problem
chown: /usr/local/mysql: No such file or directory
Where is mysql installed this messages says it's not in /usr/local/mysql
Search your system.. and chown the equivalent of the /usr/local/mysql
Bye,
B.
At 10:41 4-4-01 +0200, hanan khader wrote:
Hi friends ...
I have sent once my problem, but don't know why, I haven't recieved any
answer or solution for it ...
Perhaps because you try to run MySQL on Windows.. I think most people on
this list are familiar with MySQL on Linux.
I found a link
HI,
If I understand your question, you need two queries:
select count(*) as count, ip, value from log group by ip
select count(*) as count, ip, value from log group by ip,value
that leads to the right direction! thanks! It shows me a the ips with
their values and how many times they are in the
Hi,
something, that gets quite near to what I want is:
select a.id, a.value, b.value
from test as a left join test as b on a.id=b.id
group by a.id, a.value having a.valueb.value;
It spits out the right data, but not the way I want...
++---+---+
| id | value | value |
Hi,
sometimes one has to have the feeling, that somebody wants to help to
get it done better! :) I think I got it:
select a.id, a.value from test as a left join test as b on a.id=b.id
where a.value b.value group by a.id,a.value;
Its good to check logtables!
Of course I would appreciate
I can't to compile this
I'm getting the following error on my gmake (most snipped for brevity).
gcc -DSOLARIS2=280 -DUSE_HSREGEX -DUSE_EXPAT -I./lib/expat-lite
-DNO_DL_NEEDED -I/usr/local/include -I/usr/local/include/mysql `./apaci`
-L/usr/local/lib -R/usr/local/lib \
-o httpd
35 matches
Mail list logo