Rosen wrote:
Hi,
I have to transfer all data between two tables ( with identical structure
) Is this possible with one query, or I must read from table1 and manually
insert into table2?
Thanks in advance,
Rosen
INSERT INTO `dbase2`.`table1`
SELECT *
FROM `dbase1`.`table1` ;
That will
Hi,
I have a query which works successfully, but which has the potential to be
slow as the database grows.
The query is:
SELECT `id`, LOCATE('my search string', `fulltext`) FROM `contents` WHERE
MATCH (`fulltext`) AGAINST ('my search string' IN BOOLEAN MODE)
So it is getting the ID and
Yeah, I had thought of that, but had not got far with it. I'll have another
go as I was getting errors last time.
Bastien Koert wrote:
Have you tried limiting it first via a subselect and then doing the full
text match?
bastien
From: benmoreassynt [EMAIL PROTECTED]
To: php-db
wrote:
Have you tried limiting it first via a subselect and then doing the full
text match?
bastien
From: benmoreassynt [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Speeding up a query by narrowing it down
Date: Wed, 29 Nov 2006 21:02:03 -0500
Hi,
I have a query which
wrote:
Have you tried limiting it first via a subselect and then doing the full
text match?
bastien
From: benmoreassynt [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Speeding up a query by narrowing it down
Date: Wed, 29 Nov 2006 21:02:03 -0500
Hi,
I have a query which
only slowed the searches down, or had no effect because MySQl
would always stick with the fulltext index.
The fields are
id
filename
fulltext
startdate
enddate
series
volume
Sorry for the multiple posts - my newsreader sucks for some reason.
Thanks for your help
R
Chris wrote:
benmoreassynt
Chris Carter wrote:
I am now trying to run PHP using apache on localhost. Can you please
advice:
1) What exactly I need to download for running PHP on Apache.
2) What should be the location of the downloaded PHP
folder/file/executable so that it interacts easily with Apache.
3) Settings
Chris Carter wrote:
I am now trying to run PHP using apache on localhost. Can you please
advice:
1) What exactly I need to download for running PHP on Apache.
2) What should be the location of the downloaded PHP
folder/file/executable so that it interacts easily with Apache.
3) Settings
Hi,
Not really sure if this is possible.
I am using a fulltext search to search through very large entries. Basically
an entry might contain 200,000 words, which are searched for exact matches.
What I want to do is SELECT, say, the 300 words surrounding the exact match
from the 200,000 word
Thank you very much.
Could you give me a rough idea of what the MySQL query would look like?
I am trying to work out the syntax using string functions like LOCATE,
INSTR, SUBSTRING and SUBSTRING_INDEX.
Many thanks
BMA
Steven Cruz wrote:
I use to perl scripts to do something like this. But
Renzo Clavijo wrote:
?php
if(isset($_REQUEST['send_mail'])){
mail($_REQUEST['address_mail'],$_REQUEST['subject']
$_REQUEST['message']);
}
I would try something like this:
if(isset($_REQUEST['send_mail']))
{
mail($_REQUEST['address_mail'],$_REQUEST['subject']
benmoreassynt wrote:
I would try something like this:
if(isset($_REQUEST['send_mail']))
{
mail($_REQUEST['address_mail'],$_REQUEST['subject']
$_REQUEST['message']);
unset($_REQUEST);
}
As a follow up, if you want to use that in a public environment
12 matches
Mail list logo
