Hi all,
What do you know about the effect of conflicting slave server IDs on
the master in general? And specifically, are you aware of any issues
with MySQL 5.0.27?
Your help is very much appreciated.
Thanks!
David
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
Whil Hentzen wrote:
Baron Schwartz wrote:
Whil Hentzen wrote:
Michael Dykman wrote:
if you see no errors, check your config... are you sure InnoDB is
enabled ?
I can create a new database and add InnoDB tables to it without
problems.
Ack, I lied. No error in the /var/lib/mysql, but there
I suspect that your problem is that you are converting your date field to a
string before sorting. You shouldn't use the same name for the alias as you
do for the field. Try
$result= mysql_query("SELECT date_format(date, '%d/%m/%Y') as
formatted_date, title,
id, display FROM news ORDER BY date DES
$result= mysql_query("SELECT date_format(date, '%d/%m/%Y') as date, title,
id, display FROM news ORDER BY date DESC ");
I have the query above the problem is oders them like so
30/05/2007
29/07/2007
25/0/2007
The order is taken by the first number. Is there any way to order them
properly wit
May I suggest:
SELECT date_format(date, '%d/%m/%Y') as mydate, title,
id, display FROM news ORDER BY date DESC
changing the alias of your formatted date to mydate, the raw value of
date is now available to order by.
- michael dykman
On 9/12/07, Ross Hulford <[EMAIL PROTECTED]> wrote:
> $resul
$result= mysql_query("SELECT date_format(date, '%d/%m/%Y') as date, title,
id, display FROM news ORDER BY date DESC ");
I have the query above the problem is oders them like so
30/05/2007
29/07/2007
25/0/2007
The order is taken by the first number. Is there any way to order them
properly wit
Some processes on a server (64-bit Gentoo Linux with MySQL 5.0.44),
which seemed to be related to I/O on LVM volumes hung and it was
necessary to force reboot it. The mysql data was not on an LVM volume
though it still may have been affected since over time, more and more
processes became unres
> > I have a table with a PRIMARY KEY on id field, whos
> > evalue is populated usin auto_increment.
> >
> >
> > CREATE TABLE `key` (
> > `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
> > `sid` smallint(4) unsigned NOT NULL DEFAULT '0',
> > `email` varchar(128) NOT NULL DEFAULT '',
> > PRIM
Hi,
> I have a table with a PRIMARY KEY on id field, whos
> evalue is populated usin auto_increment.
>
>
> CREATE TABLE `key` (
> `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
> `sid` smallint(4) unsigned NOT NULL DEFAULT '0',
> `email` varchar(128) NOT NULL DEFAULT '',
> PRIMARY KEY (`id`)
Hi All,
I have a table with a PRIMARY KEY on id field, whos
evalue is populated usin auto_increment.
CREATE TABLE `key` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`sid` smallint(4) unsigned NOT NULL DEFAULT '0',
`email` varchar(128) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE K
Vladimir,
I have tried to recompile MySQL 5.1.21 as you
suggested, but unfortunately I got the same error.
Is it possible that some other define needs to be set
?
Thanks in advance for your help,
Mariella
./configure CC=gcc CFLAGS="-DBIG_JOINS=1 -DHAVE_DLOPEN
-O2" CXX=g++ CXXFLAGS="-DBIG_JOI
Hi All,
I would like to be able to use MySQL 5.1.21 with
the PBXT engine.
I have compiled MySQL 5.1.21 64 bits on Debian 4.0
with linux 2.6 with the options specified in the
README that comes with the PBXT source code.
I have copied the binary of the pbxt library into the
lib/mysql directory
When
12 matches
Mail list logo
