Nils Meyer wrote:
SELECT
SQL_CALC_FOUND_ROWS doesn't make much sense without a where clause by
the way.
LIMIT, not where.
Thanks for the reply... That seems to make sense. I'm talking about the part
of one record being returned containing a field with the number of records.
About the LIMI
Has anyone built a script to add a new slave into a MySQL replication
setup which can operate (for the most part) unattended?
The set of operations is pretty straight forward but right now it's
mostly a manual step which ends up taking a LONG time.
The script would need to:
* connect to a maste
Ysgrifennodd Peter Bradley:
Ysgrifennodd Onur:
Hi Peter,
Please check phpMyAdmin Configuration file ( for Port addr ) .
Thanx
Onur
Hi Onur,
You didn't mention the file name; and as I mentioned I'm a useless
sysadmin. However, I poked about a bit and came up with this
(below). I hope i
Ysgrifennodd Onur:
Hi Peter,
Please check phpMyAdmin Configuration file ( for Port addr ) .
Thanx
Onur
Hi Onur,
You didn't mention the file name; and as I mentioned I'm a useless
sysadmin. However, I poked about a bit and came up with this (below).
I hope it's what you wanted:
*ht
Brian Mansell wrote:
This is totally possible...
Chris say your table is test, and the column is test_col.. use the
following, and if the number is always at the end.. and always has a
space in front of it this will work:
SELECT test_col, SUBSTRING_INDEX(test_col, '', 1) as test_col_str,
SUBSTR
Maybe I should rephrase this in the form of a question :) I have a
table with workstations and timestamps. I'd like to select the record
with the most recent timestamp for each workstation. I know there is a
simple query to accomplish this but I'm having difficulty. Does anyone
have any suggest
Possibly you are opening another connection, using the same handle, when you
re-enter your script. If that is the case, you'll lose track of your
previous connection (the one that has the temporary table). You might also
be accumulating a lot of connections, if this recursion happens multiple
level
On 2/16/07, Juan Eduardo Moreno <[EMAIL PROTECTED]> wrote:
On 2/16/07, Mark Papadakis <[EMAIL PROTECTED]> wrote:
> Good day,
R: are you using MyISAM or InnoDB tables?
InnoDB, only.
> For the past 2 weeks, we have been dealing with some rather strange
problems.
> While nothing changed in t
On 2/16/07, Mark Papadakis <[EMAIL PROTECTED]> wrote:
Good day,
R: are you using MyISAM or InnoDB tables?
For the past 2 weeks, we have been dealing with some rather strange
problems.
While nothing changed in terms of the mySQL server or clients
configuration ( including the options provid
Good day,
For the past 2 weeks, we have been dealing with some rather strange problems.
While nothing changed in terms of the mySQL server or clients
configuration ( including the options provided to the server during
startup, by either my.cnf or as arguments to the executable ), we are
getting t
10 matches
Mail list logo