; 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 this
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 c
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,
G
efaults to AND instead of OR.
> > Almost every search engine i have tried, google etc. works like this.
> > "black horse cat dog" only show results with all words present.
> >
> > This is what i did, set global ft_boolean_syntax = ' +-><()~*:""&|'
&
7;
>
> I really appreciate your help!!
>
> >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,
>
> 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@list
t dog" only 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.mys
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 (tex
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 t
At 11:15 AM 10/1/2004, you wrote:
Content-Type: text/plain; charset="UTF-8"
Content-Language: en
Hi,
I am trying to install MySQL without any joy. I would appreciate if you
could help me please. Here I have listed the steps I took it to install.
1. I double click on âINSTALL-BINARYâ in âmysql
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
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 h
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 bottlene
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 tho
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 op
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 s
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 take
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 b
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 tabl
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 b
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 valu
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
";
}
?>
-Original Message-
From: anandakkum
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 a
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) {
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. Y
"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: ***
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 repl
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 1
> k, I followed the instuctions on the MySQL page, downloaded
> mysql-3.23.36-pc-linux-gnu-i686.tar.gz for redhat linux and then
> followed the install directions:
>
>shell> groupadd mysql
>shell> useradd -g mysql mysql
>shell> cd /usr/local
>shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar
>[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,
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;
It´s good to check logtables!
Of course I would appreciate sugg
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.value<>b.value;
It spits out the right data, but not the way I want...
++---+---+
| id | value | value |
++--
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
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
- Original Message -
From: "Peter Holm" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 16, 2001
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 buildmark.
38 matches
Mail list logo
