Is there a tutorial or step-by-step introduction to fulltext searches with
MySQL somewhere?
Regards,
Eivind :-o
sql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
section 6.8 in the manual i think...
Hmm, no; that's about the access privilege system...
I found it in section 24.2, but I feel this topic has gotten a bit scarce
mention in the manual.
Perhaps it deserves more than that...? I sure would appreciate something
extra :-)
Best regards,
plus are you sure you're reading the latest manual? it is chapter 6.8.
The location was correct for the onlien manual. I first tried my stored PDf
version, since I could not reach http://www.mysql.com
There, it was section 24.2. Now I printed then online section 6.8 and will
go through it.
My
I run a MySQL/PHP-based website. In an attempt to make some search
functionality, I search a few specific tables that I find relevant and look
in certain fields when performing a search. A query will generally look
something like this:
SELECT * FROM Books WHERE LongName LIKE '%$kw%' OR ShortName
I have a server (any server, could be a RADIUS, a DNS or a MTA) that
logs to a file in /var/logs/log-file. Is there a way to take the raw
data sent to the log file and INSERT it into a table? Can this be
done on the fly, meaning, the data isn't stored in the flat text file
at all, but
Does anybody know a little more about what the info in mysqladmin 'status'
tells about the mysqld?
This may sound a little blunt, and maybe I could have found it in the manual
somewhere. But still, I would like to get a few pointers on how to interpret
information like this:
Uptime: 1710735
for MyISAM-Tables use your backup or your replication server, for
transactional tables like Inno-DB or BDB you can use ROLLBACK
A little stupid digression on my behalf here...:
How do you differentiate between transactional and the other type
(called...?) of tables you can use with MySQL...?
It will be very easy if your records have timestamps (automatically set to
the time when the row was created).
Then you could just write something like this:
SELECT * from yadda where yadda_timestamp NOW();
Or, if resolution by date is enough (timestamp has MMDDHHMMSS), you
could
Zac,
what is your indicator of which row it is?
If you have aprimary key for each row, why don't you just use that?
You cant really determine the position of a row if you haven't determined
the criteria that fixes the position, right?
So, you just decide wether you will sort it alphabetically or
If you include the following flag in the startup command, the logfile will
be generated in the given location:
--log=/var/log/mysqld.log
Eivind
sql, query
- Original Message -
From: Ritu Singla [EMAIL PROTECTED]
To: Eivind A. Sivertsen [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED
Here's an example:
-
#! /usr/bin/perl
use Mysql;
$dbh = Mysql-connect(localhost, verycooldatabase, , );
$query = select this from that;
$sth = $dbh-query($query);
// returns one row at the time in array @arr
while(@arr = $sth-fetchrow) {
foreach $data (@arr)
print($data\n);
}
You can also tail -f the logfile of mysqld...
tail -f /var/log/mysqld.log
...or something like that...
Eivind
sql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hummm..one solution is just to exploit the 'at' program of unix/linux
systems...
I use that for backups, table dumps etc. combined with perl or php
scripts...
$0.02;
Eivind
sql, query
-
Before posting, please
I have a question regarding the efficiency of an explicit JOIN statement vs.
an implicit one.
What I mean:
I have a many-to-many mapping through a mapping table. I.e. I have different
types of tools mapped to several categories in which they might belong. For
instance, a complete programming
14 matches
Mail list logo