> 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
> 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,
Is there a tutorial or step-by-step introduction to fulltext searches with
MySQL somewhere?
Regards,
Eivind :-o
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.
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
> 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
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 Thre
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
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 try
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
- Original Message -
From: "Ritu Singla" <[EMAIL PROTECTED]>
To: "Eivind A. Sivertsen" <[EMAIL PROT
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
-
Before posting, please check:
http:/
You can also tail -f the logfile of mysqld...
>> tail -f /var/log/mysqld.log
...or something like that...
Eivind
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://list
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(
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 sui
14 matches
Mail list logo
