Hi
I am starting with c++ api database and was wondering what lib to include in
the
compiling process im using borland 5.5 commandline compiler.
Francois D. Barnard
Property24
Webdeveloper/Programmer
(011) 715 - 6809
083 380 6645
Hi!
On Jan 18, Jason Morehouse wrote:
Hello,
Using a fulltext search on a products database I'm running into some
rather strange results.
I'm using MySQL 3.23.32 on a Redhat 7.1 Linux box.
Thanks in advance for any help,
Cheers,
-Jason
It looks like a bug to me (or two bugs).
Can
Hi
Im new at this c++ api and just like to know what lib to include when i
compile the app.i have found 2 but evenn then i still get allot of errors
when i compile.
Francois D. Barnard
Property24
Webdeveloper/Programmer/Database Admin
(011) 715 - 6809
083 380 6645
Hello
Time to time I see strange overload of MySQL on dedicated server. The server is
powerful enough to handle ~ 500 req/s. MySQL version is 3.23.40
and runs on Linux 2.4.16-SMP. The overload which I mean leds to stop
answering to queries and looks like:
6:24pm up 6 days, 2:34, 2 users,
I am running two different servers, one with the tarball distro and the
other with an rpm. Both are on Redhat 7.1. Upon executing mysql.server or
safe_mysqld the console executes the command but does not return to a
prompt. I can change to another console and see the server started ok. I
can
On Fri, 18 Jan 2002, Larry Brown wrote:
I am running two different servers, one with the tarball distro and the
other with an rpm. Both are on Redhat 7.1. Upon executing mysql.server or
safe_mysqld the console executes the command but does not return to [...]
let's start it with command
Hi,
I'm trying to use the mysql++ API on MacOS X with Project Builder, but I am
not sure what to do to get started.
Any suggestions?
Thanks,
- Chris
--
Christopher Allum [EMAIL PROTECTED]
Alluminity Solutions
PROFLEX-134
Plus en otrolig bonus. HELT GRATIS (se längre ner)
Passa på nu när det är jackpott i helgen, Med vår hjälp kan du plocka hem de
stora vinsterna!
Detta är ett helt nytt sätt att spela på Tipset,
Du kan vara bland de första att plocka hem dom stora vinsterna!
Detta
Hi!
I just forwarder your email about query caching
(Yes, I know that the query cache in MySQL 4.0 has solved this for you but...)
Hello all,
I'm having real trouble trying to optimize MySQL cause I can't believe
that
MSSQL is faster.
My configurations are as follows:
MSSQL 2000 on W2K
Hello!
I have tried to install MySQL on my linux box.
The problem is that files be installed on /usr/bin,why?
By the way I run my application which should run on MySQL, I get the error
message which includes that libmysqlclient.so.6
could not find!!!
What I have down wrong?
best regards
Nasser
On Fri, 18 Jan 2002, Larry Brown wrote:
I just double checked and the doesn't make a difference. It still just
hangs there after executing safe_mysql .
let's try
# exec safe_mysqld
when starting from command prompt
when from rc.x script put it on end of rc.local or in separate file like
help! I upgraded to the most recent version of mysql client (3.23.47) under
SuSE linux 7.1.
now the client does not accept any 8-bit characters any more - any special
character input is discarded (from the keyboard and from the clipboard as
well). how can I change that?
s.m.
Hai!
I tried to install MySQL in my linux box (redhat 7.2) by using the rpm
files.
Where should the files get after installation.
In mine the get to /usr/bin and when i use MySQL with som appliction,i get
error message which includes somethings about could not find
libmysqlclient.so.6
What
Hi
We develop a commercial site, where the mysql db, and the apache
will run on the same machine.
We use PHP to process the data.
What should I set in the mysql.user and mysql.db tables into the
Host field if I want to enable the connections just from the same
server not from everywhere?
'%',
Takacs Istvan wrote:
What should I set in the mysql.user and mysql.db tables into the
Host field if I want to enable the connections just from the same
server not from everywhere?
'%', or 'localhost', or 'www.servername.com' ???
The safest and easiest way is to use the --skip-networking
Hy,
having Replication running now, I would like to know if there are ways
to test if it all _really_ works ok.
Things i know I could do:
- checking that no errors occur in the logs on master and slave
- testing some queries an see if the changes take effect on the master
and the slave in
I'm not using replication, but for a test if it really works I would do some
data manipulations on the master and afterwards a complete mysqldump of
master and replica and diff the result.
s.m.
-
Before posting, please check:
sascha mantscheff wrote:
I'm not using replication, but for a test if it really works I would do some
data manipulations on the master and afterwards a complete mysqldump of
master and replica and diff the result.
ok, this is an new and interesting idea, has anyone an idea how long it
Ihre Nachricht vom Friday 18 January 2002 12:14:
sascha mantscheff wrote:
I'm not using replication, but for a test if it really works I would do
some data manipulations on the master and afterwards a complete mysqldump
of master and replica and diff the result.
ok, this is an new and
sascha mantscheff wrote:
Ihre Nachricht vom Friday 18 January 2002 12:14:
sascha mantscheff wrote:
I'm not using replication, but for a test if it really works I would do
some data manipulations on the master and afterwards a complete mysqldump
of master and replica and diff the result.
ok,
Hi,
I've got 2 mysql server that I want to configure in a hot-standby config in
the following manner:
Two servers with a fibre channel connection to a central storage array. The
data dir of the database is on this
storage array. The OS (linux or solaris, haven't decided yet) sees this
datadir
Henning Sprang wrote:
sascha mantscheff wrote:
I'm not using replication, but for a test if it really works I would
do some data manipulations on the master and afterwards a complete
mysqldump of master and replica and diff the result.
ok, this is an new and interesting idea, has
Yes you can run two or more MySQLD's for one database.
You seem to know the problems with this..
I would use Linux but I just find it easy to use
mysqld is stable but if it is not you could just kill it and restart a new
one.
What is more important is the data, how are you protecting that?
If
Hi!
You have hit the problem of easy installation of MySQL-4.0 :)
From the manual at http://www.innodb.com/ibman.html :
.
2 InnoDB startup options
To use InnoDB tables in MySQL-Max-3.23 you MUST specify configuration
parameters in the [mysqld] section of the configuration file my.cnf, or
Ihre Nachricht vom Friday 18 January 2002 12:14:
sascha mantscheff wrote:
I'm not using replication, but for a test if it really works I would do
some data manipulations on the master and afterwards a complete mysqldump
of master and replica and diff the result.
ok, this is an new and
Hi,
I'm not sure if I understand you but you can't have the datadir/database
filesystem monted read-write on the two servers at the same time. At
least not with consistensy. Perhaps with innodb on raw devices?
/Jörgen
CyberSushi wrote:
Hi,
I've got 2 mysql server that I want to configure
Is it possible to compile and run MySQL as a 64-bit program on Solaris 8?
If so, are there precompiled bits available?
The primary reason for doing this is to determine if a 64-bit version would
allow the database to be larger than 4-gig. I have been told by another
member of our team MySQL
hi,
i have a mysql table with 10 millions rows. Response time is perfect,
but i have some duplicated entries inside ... (maybe 100 - 200 rows)
how can i find them using only SQL ?
i can do it with php but really don't know if it is possible using only a
SQL query ...
best regards.
Brad Teale writes:
A couple of questions about compiling on Solaris.
1) Are the Sun Workshop 6 compilers supported for MySQL and MySQL++?
1a) Can you use the -native flag without problems?
2) Is the binary distribution compiled with Sun or GNU compilers?
Background Info:
We are
Brad Teale writes:
I found the answers to my previous question about MySQL in the manual. Doh!
However, when I tried to compile MySQL, I ran into the following error:
[skip]
processors
hash.c, line 189: reference to static variable hash_key in inline extern
function
hash.c, line 229:
Forgot to CC to the list. Here it goes, in case anyone else has these
problems:
-- Forwarded Message --
Subject: Re: compiling and/or running 64-bit MySQL on Solaris 8/sparc?
Date: Fri, 18 Jan 2002 15:06:57 +0200
From: Markus Lervik [EMAIL PROTECTED]
To: Hatton Steven [EMAIL
you should make a self-join to find the duplicates in one table.
-Original Message-
From: Jean Fabrice Leoni [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 18, 2002 2:00 PM
To: [EMAIL PROTECTED]
Subject: find double
hi,
i have a mysql table with 10 millions rows. Response time is
Hello all!
We've requested a database from different companies, and specifically
said we wanted MySQL or PostgreSQL because of the open source angle
and we're a library.
One company offered MS SQL as the platform and said that they can later on
port it to MySQL. For this they wanted 18 000
Hi
first of all it is ridiculus of the company to offer something
other than your specifications.
if they want to offer you a solution other than what you need,
they have to change the software at their cost not at yours.
in my opinion it is better to not accept this solution at all
and look
On Friday 18 January 2002 15:58, you wrote:
On Fri, Jan 18, 2002 at 03:16:15PM +0200, Markus Lervik wrote:
We've requested a database from different companies, and
specifically said we wanted MySQL or PostgreSQL because of the open
source angle and we're a library.
One company
If you know you're going to port it, it really shouldn't be too difficult.
In fact, if you're creating it with the intention of porting it, you can
(and should) use MSSQL datatypes that are compatible with MySQL. If you
do this, porting is a trivial task at best.
18,000 euro seems a bit steep
Jeremy Zawodny wrote:
On Fri, Jan 18, 2002 at 03:16:15PM +0200, Markus Lervik wrote:
Hello all!
We've requested a database from different companies, and
specifically said we wanted MySQL or PostgreSQL because of the open
source angle and we're a library.
One company offered
Is it possible to replicate between two databases on a single server,
and if not, then what is the next best solution? I administer a
Bugzilla installation with about 1.8GB in a MySQL database. Bugzilla
has a built-in replication solution that copies data from a primary
database optimized
Hi,
I just experienced the following bug in tables created as berkeley
tables:
on bdb tables:
mysql SELECT
jobs.number,jobs.status,jobs.filename,jobs.source_file,verarbeitung.name
FROM verarbeitung right join jobs on (verarbeitung.verarbeitung =
jobs.verarbeitung) order by jobs.number;
I can't say that I am a database specialist, but I still think that there
will be some problems porting a MSSQL to mysql, and this because it seems
that MSSQL is very linked to the operating systems it runs on, i.e. Windows
(only think to the security for MSSQL).
-Original Message-
From:
My concern would be, what is the mysqld without a database going to do.
Wouldn't it need some
kind of dummy data dir. I'm sure the daemon does some random checks of its
data to ensure that
it is still there.
If this is not a problem then this seems fine.
As far as the OS goes, I would like to
It will write a status message over the '# prompt.
Hit enter. Does the prompt return?
Larry Brown wrote:
I just double checked and the doesn't make a difference. It still just
hangs there after executing safe_mysql .
Larry S. Brown
President/CEO
Dimension Networks, Inc.
Member ICCA
(727)
Fournier Jocelyn [Presence-PC] writes:
Hi,
I've notice sometimes DISTINCT clause take a really high amount of time to
remove duplicates whereas it should be really quick (I assume it should be
;))
[skip]
Why does it take so much time to remove duplicates in only 58 rows ??
Thank
Hi,
Yes it is 4.0.1.
But the first query has also to make a temporary table with 2 million rows,
it's why I don't understand the delta between the query without DISTINCT and
the query with DISTINCT.
The remove duplicates doesn't occurs after the join was performed ?? (it
should be really fast in
Chris Allum writes:
Hi,
I'm trying to use the mysql++ API on MacOS X with Project Builder, but I am
not sure what to do to get started.
Any suggestions?
Thanks,
- Chris
--
Christopher Allum [EMAIL PROTECTED]
Sorry about the previous, seemingly stupid question asking for clarification
on the LDFLAGS. I was not able to hit
http://home.earthlink.net/~jaymzh666/mysql.html , so I did not realize that
answer was there. I now seem to have a successfully built MySQL 3.23.47
using what I believe is a
-Original Message-
From: Markus Lervik [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 18, 2002 8:08 AM
To: [EMAIL PROTECTED]
Subject:Fwd: Re: compiling and/or running 64-bit MySQL on Solaris
8/sparc?
On Friday 18 January 2002 13:57, you wrote:
[BIG snip]
checking
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, January 18, 2002 2:14 PM
Subject: Re: Porting from MS SQL to MySQL
Jeremy Zawodny wrote:
On Fri, Jan 18, 2002 at 03:16:15PM +0200, Markus Lervik wrote:
Hello all!
Fournier Jocelyn [Presence-PC] writes:
Hi,
Yes it is 4.0.1.
But the first query has also to make a temporary table with 2 million rows,
it's why I don't understand the delta between the query without DISTINCT and
the query with DISTINCT.
The remove duplicates doesn't occurs after the join
I understand it has to re-iterate if the number of rows in the result
without DISTINCT is greater than the limit clause, but if the result without
DISTINCT is lower, it should be faster to perform the DISTINCT on the result
directly (or perhaps I'm missing something ? ;)).
- Original Message
On Fri, 18 Jan 2002, Markus Lervik wrote:
Hello all!
We've requested a database from different companies, and specifically
said we wanted MySQL or PostgreSQL because of the open source angle
and we're a library.
One company offered MS SQL as the platform and said that they can later on
SNIPSNIP:)
I agree. If they are a seriuos company they should build it after the
customers wishes
i.e if you want mysql the company should build it with mysql.
For 18,000 euro i could build the system myself:)
My two cents
/PM\
What about the customer who asks a car company to
Hello,
I have troubles compiling this program:
#include iostream.h
#include iomanip.h
#include c:/sqlplus/sqlplus.hh
int main()
{return(0);}
As you can see, the program itself isn't very
complicated.
When I run this program (using MS Visual C++), here
are the errors I get. Can anybody help me
Hello-
I've done some searching through archive and the website but can't seem to
find a semi-concrete answer. What's the schedule, if any, for version 4.0
to go stable?
Thanks for any help or pointers.
Steve
-
Before
We are running an extremely large instance of mysql version 3.23.41 on
Solaris 2.8 and have been experiencing memory related server crashes.
The behavior suggests that we are running out of memory / swap, but we have
over 2 gig of memory and 10 gig of swap free.
Our server settings are:
Hatton Steven writes:
Sorry about the previous, seemingly stupid question asking for clarification
on the LDFLAGS. I was not able to hit
http://home.earthlink.net/~jaymzh666/mysql.html , so I did not realize that
answer was there. I now seem to have a successfully built MySQL 3.23.47
Carsten Hammer writes:
Hi,
I just experienced the following bug in tables created as berkeley
tables:
[skip]
Is it in general dangerous to use bdb tables?
Best regards,
Carsten Hammer
No, it is not dangerous to use bdb tables.
Can you upload gzipped dump of the tables to :
- Original Message -
From: [EMAIL PROTECTED]
To: Tony Buckley [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, January 18, 2002 3:34 PM
Subject: Re: Porting from MS SQL to MySQL
SNIPSNIP:)
I agree. If they are a seriuos company they should build it after the
customers
you could use:
file /path-to/mysqld
the output will tell you if mysqld is a 32 or 64 bit ELF executable.
Hatton Steven wrote:
Sorry about the previous, seemingly stupid question asking for clarification
on the LDFLAGS. I was not able to hit
Porting a DB takes more 'than a couple of hours'. What about the written
procedures, the security mappings, the back up and recovery procs, the
fallback arrangements, the testing etc.
Yes, porting a database that was written for MSSQL with no intention of
porting can be a painful
Hallo,
I am developing a database application using Kylix
ver.1 and MySQL 4.23.41-log .
I can connect and execute the query but the problem is
my DBGRID only displays (MEMO) .
Some of my friends said that perhaps it is caused by
the datatype of the field but I tried to change the
datatype of
Unless they are saying they doubt that mySQL is upto, it so it's no good
quoting. They may have a room full of SQLServer people twiddling their
thumbs in which case I agree with you, they are not bucking for the customer
here. On the other hand they have very real doubts that mySQL is upto
These two queries were execute one after the other. I am the only one
who updates this table. I have seen this happen before, and people have
said that perhaps it's a problem with softupdate. I haven't been able
to address it.
I am on FreeBSD 4.2 FreeBSD 3.23.35
There is quite a bit of load
I agree.
I have more experience with MS SQL than mySQL, but there are some MS SQL
specifics that can cause hiccups. But these hiccups can be avoided with
a bullet proof project plan and excellent documentation. You may not be
able to automate all the project procedures and a lot of the
Guy-Maurice Lepoutre writes:
Hello,
I have troubles compiling this program:
#include iostream.h
#include iomanip.h
#include c:/sqlplus/sqlplus.hh
int main()
{return(0);}
As you can see, the program itself isn't very
complicated.
When I run this program (using MS Visual C++),
Is there a way to disable foreign keys temporarily? Specifically,
I'm running 3.23.47 with InnoDB tables, and I need to periodically
dump and reload a table that has foreign key dependencies on it.
Thanks,
Philip
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PROTECTED]
- Original Message -
From: j.urban [EMAIL PROTECTED]
To: Tony Buckley [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, January 18, 2002 4:07 PM
Subject: Re: Porting from MS SQL to MySQL
Porting a DB takes more 'than a couple of hours'. What about the
written
- Original Message -
From: j.urban [EMAIL PROTECTED]
To: Tony Buckley [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, January 18, 2002 4:10 PM
Subject: Re: Porting from MS SQL to MySQL
Unless they are saying they doubt that mySQL is upto, it so it's no good
I would say it would take a month at least to complete the job
correctly. I have seen some top OLAP developers take 3 months to
complete a 30gb DB2 to an Essbase migration including all documentation
and politics involved. Two hours? You should be fired for just
thinking that! Just kidding.
I wasn't talking about migration of a 30gb DB2 system. I was talking
about porting a system that was specifically designed to be ported. If
you design it correctly up front, you can port it very painlessly. You
can easily develop a system that uses the proper datatypes and does NOT
use
Are you seriously saying you could sit down in front a reasonably sized DB
you had never seen before and understand all the business issues and pick it
up and ship to a new RDBMS and platform, rewrite the document, replan what I
Absolutely not. I am saying that if I am tasked with developing
So basically, if you already own Mascon (or buy it from
http://www.scibit.com/ for $49.00), and download the latest
installable
binary releases of MySQL, Apache, etc, you've got the MySQL Studio,
and as a bonus, it features a clean, standard UI, with the standard
Windows style widgets.
Philip,
DROP TABLE always succeeds even if you would have child rows referring to
it.
Thus the way is dump + DROP + CREATE + import
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and
I've had a similar error when creating innodb tables, using a 4.0.1 client,
and a .47 server, if I loaded my create statement from a text file, the
innodb table wouldn't create. Change the type to myisam and it worked fine.
If I wound up creating it line by line, it worked fine. This might
hi list!
I have been working with mysql and php for sometime
now and I have this problem:
I query the server for records and I know the result
is more than a thousand records. How do I seperate them
so I can display a fixed number per page and allow
record navigation on my website?
I hope
Hello Steve,
Friday, January 18, 2002, 5:33:38 PM, you wrote:
SS REALFROM: Steve Suehring [EMAIL PROTECTED]
SS HOUR: 2002011817
SS Hello-
SS I've done some searching through archive and the website but can't seem to
SS find a semi-concrete answer. What's the schedule, if any, for version
Nasser,
Friday, January 18, 2002, 12:26:09 PM, you wrote:
NR I tried to install MySQL in my linux box (redhat 7.2) by using the rpm
NR files.
NR Where should the files get after installation.
NR In mine the get to /usr/bin and when i use MySQL with som appliction,i get
NR error message which
If you only have 2GB of RAM and you are allocating 5120M (=5GB) for the
key_buffer, you have a problem. That should make your system swap like
mad and everything slow to a crawl. Also, note that some of these config
options may effect per-thread allocation. I don't know which ones off the
You
can easily develop a system that uses the proper datatypes
and does NOT
use MSSQL-specific extensions. This type of system can
easily be ported.
Yes, and such an application is likely not to be nearly as efficient on the
original platform. I can see where this kind of design is
original platform. I can see where this kind of design is useful... if you
KNOW you are going to port to MySQL in the future. But in that case, why not
design there in the first place?
I have no idea and I didn't suggest this was a good solution, but the
question was posed, so I simply
How do I seperate them
so I can display a fixed number per page and allow
record navigation on my website?
Use LIMIT in your database query, keeping track of the offset with a
variable. A simple example here (I am sure there are many more out there):
Kevin,
The Mysql documentation suggests you use no more than 75% or 80% of
physical memory to allocate for key_buffer. As Heikki and Jeremy
confirmed for me this week, sort_buffer and record_buffer are the ones
that grow per thread - Heikki suggested 1Mb for each of those. Using
swap as RAM
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have a problem compiling an app that uses the MySQL C API. My program
itself is C++ using Visual C++ 6.0 in Windows 2000, but the C api is plenty
sufficient for me. I suspect the problem comes because when I include C++
streams, I use the
Did you get an answer to this problem. I'm experiencing the same behavior.
Mike Wexler wrote:
When I do
EXPLAIN
SELECT status.itemKey, status.auctionUrl,
status.hideItem, status.auctionId, status.action,
status.auctionHouse
FROM auction.status, inventory.thisItem
WHERE
Hi ppl,
When I set database and user host to % I can't connect to database when using
localhost - authorization fails.
When I connect using domain name, every things works fine.
Q1: What is the problem using localhost?
Q2: How can I set default localhost to domain name?
Thank You.
Best
Hi ppl,
When I set database and user host to % I can't connect to
database when using localhost - authorization fails.
When I connect using domain name, every things works fine.
Q1: What is the problem using localhost?
No problem - just a different type of connection. When
you specify
Description:
When attempting to run mysqld, it says 'Can't create gc thread'.
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all
Hi.
I thought it would be useful to share my findings. They all relate to the
4.0.1 release. It would be nice to have some clarification on whether this is
expected behaviour, whether this behaviour is wrong (i.e. bug, corrupted
index, etc), and what you guys think could be causing it.
1.1)
Unfortunately Mascon doesn't have any ER diagramming tools for schema
modeling. I bought Heraut Solutions' Dezign for Databases for this
purpose a while back, but its somewhat clunky, unprofessional look/feel
has been a bit of a turn off. I've enjoyed using Sybase' Powerdesigner
for this
I had 3.23.41 installed. It came with Rh7.2. I had some mistakes in initial
start up . So I thought i would reinstall it. I downloaded the rpm for
3.23.47. And ran the rpm installation. I am not sure if it did the whole
install. Now I have a safe_mysqld and 2 other mysqld process runinng. But I
Hi!
On Jan 18, Gordan Bobic wrote:
Hi.
I thought it would be useful to share my findings. They all relate to the
4.0.1 release. It would be nice to have some clarification on whether this is
expected behaviour, whether this behaviour is wrong (i.e. bug, corrupted
index, etc), and what
--j2AXaZ4YhVcLc+PQ
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
We use mysql heavily in production with tables over 30GB. We are going
to purchase a new db server soon and the decision to be made now is
whether we should go
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
At 03:44 PM 1/18/2002 -0500, you wrote:
We use mysql heavily in production with tables over 30GB. We are going
to purchase a new db server soon and the decision to be made now is
whether we should go with a 4 cpu 700-900MHz system or a 2 cpu
Islam, Sharif wrote:
I had 3.23.41 installed. It came with Rh7.2. I had some mistakes in initial
start up . So I thought i would reinstall it. I downloaded the rpm for
3.23.47. And ran the rpm installation.
You got the 3.23.47 RPM from MySQL's site, I presume? That RPM is not an
upgrade
Islam, Sharif wrote:
I had 3.23.41 installed. It came with Rh7.2. I had some mistakes in
initial
start up . So I thought i would reinstall it. I downloaded the rpm for
3.23.47. And ran the rpm installation.
You got the 3.23.47 RPM from MySQL's site, I presume? That RPM is not an
Yes
Is this a bug? I can't find an answer to this question in FAQs or archives.
CREATE TABLE aa ( a int);
INSERT INTO aa VALUES (1),(2),(3),(2),(4),(5),(1),(6),(3);
the following :
mysql select a,count(*) as z from aa where z1 group by a;
displays this error:
ERROR 1054: Unknown column 'z' in
Hi,
Try :
SELECT a,COUNT(*) AS z FROM aa GROUP BY a HAVING z1;
Regards,
Jocelyn
- Original Message -
From: Rick Emery [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 18, 2002 10:30 PM
Subject: Column Alias Bug??
Is this a bug? I can't find an answer to this question
Hello,
I'm experincing a problem with my database locking up on some queries.
Any explanation or solutions anyone can provide will be much appreicated.
-
##Scenario: 3 tables: company, co_type_assoc, co_type
##with
is there a max row length for MyISAM tables? I'm having a hard time finding
it.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
count(*) works if I do not alias it with z, and do not use WHERE clause:
mysql select a,count(*) from aa group by a;
+--+--+
| a| count(*) |
+--+--+
|1 |2 |
|2 |2 |
|3 |2 |
|4 |1 |
|5 |1 |
|6 |1 |
1 - 100 of 121 matches
Mail list logo
