At 10:50 +1300 2/14/03, Defryn, Guy wrote:
Is auto completion a feature that only works in Mysql4?
No.
However, I have never noticed it to work on Windows. Are you using
Windows?
Cheers
Sql,query
-
Before posting,
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, 14 February 2003 11:03 a.m.
To: Defryn, Guy
Subject: Re: RE: Auto-completion
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter
Hi,
I've got a problem:
I'm using Berkeley DB tables in my database, but mysql fails to restart
after dropping such database. Mysql claims that it can't restore some of
database tables on start and fails to do it, because tables' files do not
physically exists after database dropping...
I can
On Thu, Feb 13, 2003 at 03:33:31PM -0600, Paul DuBois wrote:
At 12:43 -0800 2/13/03, John Oliver wrote:
I've got MySQL installed via RPM on a Red Hat 8.0 machine. How do I
enable InnoDB?
If it's MySQL 4, install the -Max RPM on top of your existing installation
to get a server with InnoDB
On Thu, Feb 13, 2003 at 03:33:31PM -0600, Paul DuBois wrote:
At 12:43 -0800 2/13/03, John Oliver wrote:
I've got MySQL installed via RPM on a Red Hat 8.0 machine. How do I
enable InnoDB?
If it's MySQL 4, install the -Max RPM on top of your existing installation
to get a server with InnoDB
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John Oliver wrote:
On Thu, Feb 13, 2003 at 03:33:31PM -0600, Paul DuBois wrote:
At 12:43 -0800 2/13/03, John Oliver wrote:
I've got MySQL installed via RPM on a Red Hat 8.0 machine. How do I
enable InnoDB?
If it's MySQL 4, install the -Max
Stefan and Paul,
When adding ORDER BY counterid, all rows are sorted correctly, but it should not be
needed. All the other tables are sorted correctly at the start, and has always been.
This is the structure of the ID field in the second and third table:
FieldType
On Thu, Feb 13, 2003 at 04:39:44PM -0600, Mark Matthews wrote:
Trust me. You most likely do not want to run the RedHat RPMs. They tend
to have a lot of stability issues.
Head on over to http://www.mysql.com/ and download the RPMs we provide.
Your life will be easier.
Okey-dokey, I'll give
Stefan and Paul,
When adding ORDER BY counterid, all rows are sorted correctly, but
it should not be needed. All the other tables are sorted correctly
at the start, and has always been.
I'm not sure where you got that idea. There is NO guarantee about the
order in which rows are returned
Ok, I guess you're right. It's just that it has never happend to me before.
Thanks for your help.
Regards,
Viktor
- Original Message -
From: Paul DuBois
To: [EMAIL PROTECTED]
Sent: Thursday, February 13, 2003 11:48 PM
Subject: Re: Re: Strange sorting in table
Stefan and Paul,
At 0:01 +0100 2/14/03, Viktor Vasiliou wrote:
Ok, I guess you're right. It's just that it has never happend to me before.
Thanks for your help.
In general, when you simply insert rows into a table, that's the order
in which they're returned. That's just happy coincidence, and not
to be relied
I removed the Red Hat MySQL RPMs (which worked fine, other than not
supporting InnoDB) and installed the 3.23.55-1 RPMs from mysql.com When
I try to start it:
[joliver@joliver-lnx joliver]$ sudo /etc/rc.d/init.d/mysql start
[joliver@joliver-lnx joliver]$ Starting mysqld-max daemon with databases
John,
[joliver@joliver-lnx joliver]$ sudo /etc/rc.d/init.d/mysql start
[joliver@joliver-lnx joliver]$ Starting mysqld-max daemon with databases
from /var/lib/mysql
030213 15:01:06 mysqld ended
Have you tried
mysqld --console
already? This will not solve your problem, but at least it will
At 12:31 PM 2/13/03 , Luc Foisy wrote:
I still don't understand do you mean the actual row
number or just a
display number.
There is no relevant data or use to this number.
It is the row number of the returned result set, purely
for display.
That means no field exists or should
Hi all.
Hi spam filter. SQL. Query.
I'm writing some code in Access 2002 which builds an sql string and then
saves it as a pass-through query.
I would like to be able to build in some new-line characters or
something so that the query is nicely formatted so that when I (or my
boss) goes back
Daniel Kasak wrote:
Hi all.
Hi spam filter. SQL. Query.
I'm writing some code in Access 2002 which builds an sql string and
then saves it as a pass-through query.
I would like to be able to build in some new-line characters or
something so that the query is nicely formatted so that when I (or
On Fri, Feb 14, 2003 at 12:52:49AM +0100, Stefan Hinz wrote:
Have you tried
mysqld --console
already? This will not solve your problem, but at least it will
display quite some output to help you find the cause of the prob.
[joliver@joliver-lnx joliver]$ sudo /usr/sbin/mysqld --console
On Thu, Feb 13, 2003 at 02:10:18PM -0500, Luc Foisy wrote:
BUT
SELECT Data, CASE WHEN 0 != 0 THEN 'Something' END FROM table
will return two columns, Data and CASE WHEN 0 != 0 THEN 'Something' END. It
would be better if I could do..
SELECT Data, CASE WHEN 0 != 0 THEN 'Something' AS 'A
Hello,
I just setup replication on mysql 3.23.55 and seem to be having some problems.
The slave machine does not seem to want to copy all the data on start. I
have a table with 54,000 rows on the master, and after I load up the slave
there are only 54,850 on that machine.
I can drop the
Hi all,
Of interest to Mac OSX users.
http://www.aaronfaby.com/mysql.php
Contains everything you'll need to get MySQL installed and working on OSX.
He also has installers for Apache and PHP (http://www.aaronfaby.com/).
Goodness, I wasted days getting MySQL installed originally but using
his
Probably a simple error here, been a few years since i last did SQL work...
I've got 2 tables (actually just one aliased
nevermind just typing this much allowed me to figure it out :) Love the
way you can spend a whole day trying to figure something out, and then
as soon as you try to explain
I am using MySQL version 4.0.10 on both Slave and Master. I am running a
Visual Basic front end connected to MySQL via MySQL ODBC v3.51.04. When
using MySQLCC, adding records to the master database will work fine, the
server shows the additional record added. When using our app in VB, a
record
Hi,
Our intranet system is using mysql. At the moment authentication is done
using a password and login kept in mysql. Our webmail system authenticates
using ldap.
We are also going to use ldap to authenticate for our intranet. Advantage
for the user will be only to having to remember one
Hello,
I face a problem in transfering a mysql db from 1 machine to another. I used
the mysqldump command to take the dump of a db from machine A running linux.
I put the same on to a machine B running on linux. Then I used the mysqldump
command to create the database. In all 15 tables should
101 - 124 of 124 matches
Mail list logo