On Thu, 18 Oct 2001, Kyle Hayes wrote:
> On Thursday 18 October 2001 09:45, Bill Adams wrote:
> > Matthew Bloch wrote:
> > > I'm running several MySQL installation (all version 3.23.37 under Linux)
> > > under what I presume are some fairly harsh conditions, and wondered what
> > > circumstances
Hi,
We currently use in one of our projects 3.23.41 with two-way replication as follows:
|--| GPW replication |---|
| MySQL 1 | --> | MySQL 2 |
|GPW Master| |GPW Sla
On Thu, 18 Oct 2001, Jani Tolonen wrote:
> Adrian D'Costa writes:
> > > If you 'office system' is, for example, Sun Solaris, you will see only
> > > 1 mysqld process with 'top'. The fact that in Linux 'top' shows
> > > actually more than 1 process can be regarded as a bug in the way 'top'
> >
On Fri, Oct 19, 2001 at 03:46:49PM +1000, Chris Aitken wrote:
> Hi,
>
> Something ive been thinking about for a while but havent been able
> to come up with a definitive answer is this...
>
> Is there a system out there which can take over from the normal
> (unix based... FreeBSD/Linux t
Hi,
Something ive been thinking about for a while but havent been able to come
up with a definitive answer is this...
Is there a system out there which can take over from the normal (unix
based... FreeBSD/Linux type) telnetd method of authenticating a login off
/etc/master.passwd and
On Thu, Oct 18, 2001 at 11:41:08AM -0400, Wai Lee wrote:
> Hi,
>
> I am experiencing a very slow performance while I am building an index on a
> table. The following are some facts of system and the table I am dealing
> with:
>
> Table size: 13,857,354
> Number of distinct value in the column I
Hi,
I found different round result at below
mysql> select round(1.235,2);
++
| round(1.235,2) |
++
| 1.24 |
++
1 row in set (0.00 sec)
mysql> select round(1.325,2);
++
| round(1.325,2) |
++
|
Has anyone encountered locking problems using JDBC with InnoDB tables and
transactions? I am wondering if the MySQL JDBC was designed to handle
transactions properly since InnoDB is a relatively recent addition to MySQL.
The problem I am running into is the 100 locking error, as if the
previ
On Thu, Oct 18, 2001 at 08:02:04PM -0700, Bob Farnworth wrote:
>
> I am looking for some information on throughput (I.E. transactions
> per second) for MySQL. Anyone have some or some suggestions? I
> realize there is no hardware listed.
You've given no specifics, so here's my generally recomme
Could you also give a sample of the results you're getting that are incorrect? You
don't have to give every field, just the title should do.
Steve Meyers
> -Original Message-
> From: Ashwin Kutty [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 18, 2001 11:31 AM
> Cc: [EMAIL PROT
Hi Bob,
> I am looking for some information on throughput
> (I.E. transactions per second) for MySQL.
> Anyone have some or some suggestions?
> I realize there is no hardware listed.
Nor anything else ;-)
Performance also depends on your database, type of query, etc.
Generally speaking, MySQL i
I've a little bit problem about running mysqld
server. I've run "/etc/rc.d/init.d/mysqld start" it
will appear "mysqld dead but subsys locked". But if i
stop the service, it will fail. It is also happened
when i kill the service.
The other problem is when i run mysql it will
appear "can't
I am looking for some information on throughput (I.E. transactions per second) for
MySQL. Anyone have some or some suggestions? I realize there is no hardware listed.
Bob Farnworth
Find the best deals on the web at AltaVista Shopping!
http://www.shopping.altavista.com
MySQL automagically changes all char columns to varchar if there is one or
more variable-length columns' present. The TEXT column in your first
example is causing ALL char() columns to be converted to varchar(). In
your second example, since there are NO variable-length columns, the
char() colum
I am using MySQL Admin to create a new database called CustomerInvoice. I
enter 10 fields and some of them I set to CHAR(5) or CHAR(9). See Field
InstallerID and Claim below. MySQL Admin creates the following command and
sends it to MySQL using root login.
CREATE TABLE `CustomerInvoice` (`Invo
Hi,
we're trying to recommend that clients upgrade to version 3.23.36, and
wanted to ensure that it's stable. Particularly, have there been any bugs
regarding any bugs regarding the use of COUNT(DISTINCT since then?
In other words, if our software performs a COUNT(DISTINCT column) FROM
SomeTable
Well. this is not working.
Jani (or anyone),
After some confusing operations (as I said, i'm not good in AIX) I
found that libc.a and libbsd.a are installed in /usr/local/lib or /usr/lib,
were the others libraries are.
I alse tried to compile as if the os version was 4.
Hi Matthew,
We had a similar problem that caused us to need to run myisamchk much more
than we wanted to.
It turned out that MySQL was not being shutdown when Unix was.
Symptom: The MySQL server error log did NOT show normal shutdown messages.
Cause 1: The normal method of shutting down MySQL u
Hi,
There is no AUTO_INCREMENT() function. AUTO_INCREMENT is a
directive that you specify when you create a table.
Try this:
CREATE TABLE test
(
Id int unsigned not null auto_increment,
primary key (id)
);
INSERT INTO test VALUES (NULL), (NULL), (NULL), (NULL), (NULL);
SELECT * FROM test
Hi All,
Anyone know if the MySQL API
can be called from GPC (GNU Pascal Compiler)
programs? (instead of just C)
Thanks,
Roger
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysq
On Thursday 18 October 2001 12:31, Bill Adams wrote:
> Kyle Hayes wrote:
> > > I found yesterday (at the advice of this list) that adding an
> > > occasional call to "FLUSH TABLES" fixed my corruption problems. I
> > > would do that right before the disconnect or program exit.
> >
> > What kernel
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
Now that the patch for Gemini has been created and made
available for the new MySQL 4.0 alpha release we are
back whole again.
I am told that binaries for the complete MySQL 4.0
with support for Gemini tables are now available via
mysql.org for everyone to use (MyISAM and InnoDB also).
These
On Thu, 18 Oct 2001, Jessica Tishmack wrote:
> > Jessica Tishmack wrote:
> > Basically, I want to merge two tables together, then do a select on the
> > resulting table. But I want to do this without having to actually create
> > a new merged table
> >
> >
> > Perhaps you want
Well, if you mean searching for INFO stored in a DB, just use LIKE syntax or
FULLTEXT index. If you mean searching your site, use the
FileSystemObject(in ASP). Email for details
- Original Message -
From: "Chris Blessing" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, Octobe
Are there currently any "hacks" to force 2-way
master/master replication with mysql, (either 3.x or
4.0). I want to mirror a database driven website in
various cities/countries, and each local copy needs to
get updated and propagate its changes to all other copies.
__
Jessica,
What you can do is do a join. This accomplishes exactly what you want.
Here is a example SELECT for you:
SELECT t1.Badge, t1.FirstName, t1.LastName, t2.demographics FROM people AS
t1, info AS t2 WHERE t1.Badge = t2.Badge;
This allows you to take two tables, and do a select result of w
Is there any way to give a database user access to use a column in a
where clause but not to select the column?
Ernie Hershey
Software Developer, Hospitality and Travel Services
Radiant Systems, Inc
3925 Brookside Parkway
Alpharetta, GA 30022
> Jessica Tishmack wrote:
> Basically, I want to merge two tables together, then do a select on the
> resulting table. But I want to do this without having to actually create
> a new merged table
>
>
> Perhaps you want a MERGE table?
> http://www.mysql.com/doc/M/E/MERGE.html
Th
Hi all-
Sooner or later I'll be in charge of databasing our site (no, it's not
already databased). That's a good thing, I've really been pushing for it.
However, I'm a bit confused on how to go about searching the site. I'm not
sure if I want to go the "indexing/crawling" route where some app r
Well of course, the sql I gave was simply to demonstrate the table.field
notation.
-C
-Original Message-
From: Jon Gardiner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 3:16 PM
To: 'Chris Blessing'; Jessica Tishmack; [EMAIL PROTECTED]
Subject: RE: multiple tables with same
Kyle Hayes wrote:
> > I found yesterday (at the advice of this list) that adding an occasional
> > call to "FLUSH TABLES" fixed my corruption problems. I would do that right
> > before the disconnect or program exit.
>
> What kernel are you using? Some of the 2.4 series have... odd... behavior
Hi!
At 03:03 PM 10/18/01 -0400, you wrote:
>Being an *NIX developer for longer than I care to recall and using Linux
>since .99r, I would disagree about a buggy io subsystem. There may be some
But some disk drivers may be buggy. That would
explain why some machines run totally stable
while oth
At 19:10 18/10/2001 +0200, [EMAIL PROTECTED] wrote:
Hi!
I am guessing that you are run the client tool called mysql.exe.
The servers of MySQL begin with the name mysqld, then you have in
your /mysql/bin directory the following servers:
mysqld-opt.exe
mysqld-max.exe
mysqld-nt.exe
mysqld-max-nt.ex
Wouldn't that give you every combination of rows from pets1 and pets2? The
"union" operation is the construct that was designed for this type of thing.
MySQL 3.x doesn't support it, but the MySQL 4.0 syntax will be:
select * from pets1 where owner='lisa' union select * from pets2 where
owner='li
On Thursday 18 October 2001 09:45, Bill Adams wrote:
> Matthew Bloch wrote:
> > I'm running several MySQL installation (all version 3.23.37 under Linux)
> > under what I presume are some fairly harsh conditions, and wondered what
> > circumstances cause tables to be corrupted and need fixing with
Hi there,
I am trying fulltext to speed up my queries; but what would the query
line be,
when I would like to match the phrase: "This is a text"?
With a like query i would do "WHERE column LIKE '%This Is a text%';"
I've tried "MATCH column AGAINST("'+this +is +a +test'");" but this
returns,
all
Hello All,
Background:
-Site has 8000 uniques per day, average of 300 online at once hammering the
forums.
-POST table has over 350,000 entries
When doing a backup with mysqldump and then trying to re-import the data to a
test
server, we keep getting:
ERROR 1030 at line 207477: Got error 28 f
Hello All,
Background:
-Site has 8000 uniques per day, average of 300 online at once hammering the
forums.
-POST table has over 350,000 entries
When doing a backup with mysqldump and then trying to re-import the data to a
test
server, we keep getting:
ERROR 1030 at line 207477: Got error 28 f
Being an *NIX developer for longer than I care to recall and using Linux
since .99r, I would disagree about a buggy io subsystem. There may be some
issues with marshalling and /or threads (usually a coding/synchronization
issue not a thread issue), but I would suspect it is relating to db cachin
Same thing still applies, just change the table names in the SQL I sent
earlier.
-C
-Original Message-
From: Jessica Tishmack [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 2:58 PM
To: [EMAIL PROTECTED]
Subject: Re: multiple tables with same fields
> table pets1
> name
You can use the table.field notation like:
select * from cats, dogs where cats.owner = 'lisa' || dogs.owner = 'lisa';
select cats.food, dogs.owner from cats, dogs;
etc. etc.
(note: '||' is the "or" logical operand)
Good luck!
-C
-Original Message-
From: Jessica Tishmack [mailto:[EMAIL
> table pets1
> name foodowner
> fluffypurina kim
> fido kibbles lisa
>
>
> table pets2
> name foodowner
> snowy meowmix cheryl
> whiskers 9lives lisa
>
>
> Then I want to select all r
Is there a way to select records from multiple tables that have the same
fields, without doing a join?
Basically, I want to merge two tables together, then do a select on the
resulting table. But I want to do this without having to actually create
a new merged table. Example:
table pets1
nam
> Hi!
>
> > "Michael" == Michael T Babcock <[EMAIL PROTECTED]> writes:
>
> Michael> On Wed, Oct 17, 2001 at 12:49:26AM +0300, Michael Widenius wrote:
> >> We agreed a long time ago with NuSphere that the small hooks would be
> >> copyrighted by MySQL AB, but as the concrete paperwork has not
>I do keep forgetting about it. And it seems that MySQL has a 'Dynamic FAQ'
>linked from their site. Perhaps we could get them to add a link to the
>bitbybit version too? (MySQL Folks?)
Ideally linked from this page:
http://www.mysql.com/documentation/index.html
-
"Carsten H. Pedersen" wrote:
> >
> > What about FAQ-o-Matic?
> > http://faqomatic.sourceforge.net/
> > We would just need it hosted somewhere.
>
> Not to put a too fine point on it, but how 'bout
> referring them to: http://www.bitbybit.dk/mysqlfaq?
>
> I thought this address was well published b
Hi !!!
> -Original Message-
> From: Cenk Akyüz [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 18, 2001 1:55 AM
> To: [EMAIL PROTECTED]
> Subject: MyODBC:Update with SQLSetPos doesnt work with some "kind of"
> primary keys?
>
>
> MySQL Version: 3.23.42-max-nt
> MyODBC Version:2.50.39
At 10:21 AM -0700 10/18/01, Bill Adams wrote:
>Now that I have had some coffee I am thinking that the subjects like
>"URGENT! HELP NEEDED" are just the worse ever. Cathy, Please just fix the
>capitalization from your marketing dept. the next time and I for one will not
>complain. And rest assure
Eric,
That's nice and all that you can have an extra tool to use because of spam -
I mean, they ARE real products. Most people consider TV infomercials to be
useless, but some people find use out of them. The problem is that it's
annoying to see these types of advertisements. The reason you don't
I agree.
The attitude I have towards MySQL-related announcement messages on this list
is roughly the same as the attitude I have towards all the other
messages...read them if they look interesting, ignore them if they don't. I
really doubt most people read _every_ message on this list, and if the
Hello All!
> would be cool. Or another moderated list that contains announcements for all
> things MySQL related. I would sign up for that 'though I think a web-site
> would be better.
http://www.mysql.com/documentation/lists.html :
[EMAIL PROTECTED] announce
This is for announcement of new v
> Please try our latest 3.23 version and see if problems still persists.
Yes, it also occurs for mysqld Ver 3.23.43 for pc-linux-gnu on i686.
Please try and reproduce it using
http://www.ebi.ac.uk/~lijnzaad/mysql/bugreport.tar.gz.
Hi,
This is complete crap. One of the tools I use is because of an email I saw
on this list that might have been called spam.
I say that this type of email is on topic. Maybe they could have eased up on
the BS tone of the email, but I would still want to know about a new
product. The only other
Point well taken.. The query is as follows:-
SELECT * FROM dddeli WHERE title LIKE "%$keyword%" ORDER BY title desc LIMIT
$start,$end;
Where $keyword is the keyword to search by from the field title, $start
and $end are to dictate which page of the results, etc..
title is varchar(128)
and dd
In the last episode (Oct 18), Terry Westry said:
> Good morning:
>
> My vendor (Campus Pipeline) directed me to your website to obtain some
> documentation, but they did not specify the title of the documentation
> to retrieve. I am to locate information on performing data recovery
> with update
I am a new mysql user. I have been unable to start mysql on my laptop running
Windows 2000. Each time I start mysql, I get the following error:
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061). I have
searched through the archive for earlier mails on this problem. This looks like
Replying to myself just HAS to be in bad taste. But I guess I burt out my taste
buds a while ago. ;)
Bill Adams wrote:
> Ravi Raman wrote:
>
> > I'm not sure why there is such an outspoken negative reaction to a
> > commercial software company announcing a related product on a mysql
> > list..
Hi,
I am experiencing a very slow performance while I am building an index on a
table. The following are some facts of system and the table I am dealing
with:
Table size: 13,857,354
Number of distinct value in the column I use as index: 176,322
Platform: Linux system with dual CPUs 1G Hz and 4G
Hi all,
Is it possible to define an enumeration as a new MySQL data type and then
define columns using the user defined type?
I've heard that you can produce aliases for types but I can't find anything
in the manual about doing this for ENUMs.
Thanks for your help,
Chris
--
You never considered reading the manual, eh?
Look up types in the manual - check out TEXT type
-Jason Garber
IonZoft.com
At 08:12 AM 10/18/2001 -0500, Purcell, Scott wrote:
>Hello,
>I am working on a school project and I want to use mysql db, as a back end.
>Anyway, I want to make a column rea
Good morning:
My vendor (Campus Pipeline) directed me to your website to obtain some
documentation, but they did not specify the title of the documentation
to retrieve. I am to locate information on performing data recovery
with update logs and repair scripts. Can you please direct me to the
UR
Since it's a LIKE, you need to put the table name in quotes:
SHOW COLUMNS FROM test LIKE 'Var'
This also allows you to use things like 'Var%' in you query.
Steve Meyers
> -Original Message-
> From: TD - Sales International Holland B.V. [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, Oct
Hi!
>Well, for one, I believe that Slashdot uses InnoDB tables, which tend to
handle
>a little better under very high load.
>Steve Meyers
> -Original Message-
>> From: Matthew Bloch [mailto:[EMAIL PROTECTED]]
>> Sent: Thursday, October 18, 2001 3:34 AM> To: [EMAIL PROTECTED]
>> Cc: Peter
Elm Gysel writes:
> Hello,
>
> I'm reading and doing some testing with Specialized SQL Structures.
>
> I've included both mysql++ and custom-macros.hh . I'm using MSVC as
> compiler.
>
> The problem I'm facing is that I can't get it compiled. I get undeclared
> identifiers
>
> syntax error : i
Matthew Bloch wrote:
> I'm running several MySQL installation (all version 3.23.37 under Linux)
> under what I presume are some fairly harsh conditions, and wondered what
> circumstances cause tables to be corrupted and need fixing with myisamchk.
> This is happening once every few days and it'
Philip Johannessen wrote:
> Im currently in a debate with someone who prefers PostgreSQL. He says that
> MySQL is unstable etc. Can you please give me examples of some well known
> sites built on MySQL so I can tell him that MySQL rocks?
PostgreSQL: Unless something has changed in the more recen
It would help if you posted the actual query and results you are getting, instead of
showing "simulated" results. You mention the query below in your first post, but you
never give the actual results of it.
Steve Meyers
> -Original Message-
> From: Ashwin Kutty [mailto:[EMAIL PROTEC
I have the same problem with RedHat 7.1 (fully updated) and a Pentium.
Any answer/solution?
-Mensaje original-
De: Jean-Luc Fontaine [mailto:[EMAIL PROTECTED]]
Enviado el: miercoles, 17 de octubre de 2001 9:33
Para: [EMAIL PROTECTED]
Asunto: redaht 7.1 / AMD K6-2: 4.0 rpm error (illegal i
Hi Riccardi,
>
> I want to import data from text file that contains decimal number
> (occasionaly with 9 decimal) but mysql import only 2 decimal.
> My columns is set to DECIMAL(6,9)
> Hi, Moreno
>
try
DECIMAL(15,9)
because I think the first argument specifies the total number of digits.
Ravi Raman wrote:
> I'm not sure why there is such an outspoken negative reaction to a
> commercial software company announcing a related product on a mysql
> list...
As another poster pointed out, this is a HELP list. If someone posted to the
list looking for a product where Lasso meets that n
Trim won't work because the newline is in the middle of the string. Try using the
REPLACE function, ie
UPDATE hotel SET nome_hotel=replace(nome_hotel, '\n', '')
For the second question, it actually doesn't matter if it's CAPS or not. The group by
will be done in a case insensitive manner. H
Well, for one, I believe that Slashdot uses InnoDB tables, which tend to handle a
little better under very high load.
Steve Meyers
> -Original Message-
> From: Matthew Bloch [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 18, 2001 3:34 AM
> To: [EMAIL PROTECTED]
> Cc: Peter Tapho
Riccardi Moreno wrote:
> I want to import data from text file that contains decimal number
> (occasionaly with 9 decimal) but mysql import only 2 decimal.
> My columns is set to DECIMAL(6,9)
Someone correct me if I am wrong: The '9' is how many decimal places after
the period you want and eats u
HI!
Please try our latest 3.23 version and see if problems still persists.
There have been a few bug fixes since 3.23.32 regarding IF().
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, F
Hey there,
first off all, please CC me any replies, as I'm no longer a member of the
list... Sorry about that but I just receive too much... Over 2000 emails a
day is no exception and I can no longer keep track of them.
Ok, for the problem, I want to list the possible values of a enum variable
The harm doesn't come from you offering something beneficial to the MySQL
community. It comes when you abuse the privileges of being on this list and
send spam. While there may not be anything in stone that says not to send
commercial software advertisements, you should know better. The only thing
I am sending this again as I am desperate for some help and believe
this to be a signifigant bug if it actually is one...which it seems to
be. See below for examples.
What is quite puzzling is MySQL's estimation of the number of rows
from each of the self-joins. The conditions on alias queryTab
When running MySQL when only got as far as trying to set up users and
passwords for MySQL using 'mysqladmin' before mysqld restarted. This also
happens when connecting to Mysql with clients we have written and also the
'mysql' program and other MySQL utilities suggesting the problem is not with
ou
I want to import data from text file that contains decimal number
(occasionaly with 9 decimal) but mysql import only 2 decimal.
My columns is set to DECIMAL(6,9)
Hi, Moreno
-
Before posting, please check:
http://www.mysql.com
cedric <[EMAIL PROTECTED]> writes:
> The MySQL manual refers to files in /usr/local/.
> /usr/local/ in RH7.1 is empty.
> Could this be the reason why I'm having so much trouble installing MySQL?
> If so, how can I get rpm to install MySQL in /usr/local/?
Files managed by rpm shouldn't be in /usr
Good reply, Cathy.
I'm not sure why there is such an outspoken negative reaction to a
commercial software company announcing a related product on a mysql
list...Not only can Mysql AB be considered a commercial software company,
but so could myself and many others on this list.
For the record, I (
Hi,
I habe a problem with replication on mysql 3.23.31:
If I issue an ALTER TABLE command at the master, it is not send
to the slaves when the table name is qualified with the database
name.
eg. this doesn't replicate:
ALTER TABLE `database`.`ReplicationTest` ADD `einezahl` INT
DEFAULT '0'
Thankfully we're upgrading in the very near future (this weekend) so I can
take advantage of this and other changes (like temp table memory issues!).
Thanks again for everyone's help!
-Chris
-Original Message-
From: Jay Fesco [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 1
>
> I have a feeling this has something to do with running 3.22
> instead of 3.23.
> ;)
>
> Whadya think?
>
Oops... Yup, according to page 57 of Mr. Dubois' MySQL COUNT() combined
with DISTINCT is a 3.23.2+ feature...
I'll be interested to see the proper answer to this... (besides 'upgrade' -
I
Hello,
I'm reading and doing some testing with Specialized SQL Structures.
I've included both mysql++ and custom-macros.hh . I'm using MSVC as
compiler.
The problem I'm facing is that I can't get it compiled. I get undeclared
identifiers
syntax error : identifier 'sql_dummy_type'
'sql_dummy' :
> > select count(distinct(email)) from subscribes;
> >
> > But that's not legal. Any thoughts/ideas you all could send in would be
> > great. TIA!
> >
> > Chris Blessing
> > [EMAIL PROTECTED]
> > http://www.330i.net
> >
Try:
select count(distinct email) from subscribes;
Jay Fesco
Magical M
Adrian D'Costa writes:
> > If you 'office system' is, for example, Sun Solaris, you will see only
> > 1 mysqld process with 'top'. The fact that in Linux 'top' shows
> > actually more than 1 process can be regarded as a bug in the way 'top'
> > shows things on Linux for threaded applications (
>
> select count(distinct(email)) from subscribes;
select count(distinct email) from subscribes;
should work just fine
Magic word: sql
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_
Thanks Matthias, Jay... I gave that a shot and got an error:
mysql> select count(distinct email) from subscribes;
ERROR 1064: You have an error in your SQL syntax near 'distinct email) from
subscribes' at line 1
I have a feeling this has something to do with running 3.22 instead of 3.23.
;)
Wha
Hi!
Your commands are wrong.
Please have a look how is Makefile in examples written and when
executed, how are examples built.
Use the same method for your code.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /
I found a MySQL system variable
max_binlog_cache_size| 4294967295
would caching have anything to do with it rather than replication?
thanks
Leon.
-Original Message-
From: SAE's System Administrator [mailto:[EMAIL PROTECTED]]
Sent: 18 October 2001 15:22
To: Leon Noble
Cc: [EMAI
Try tuning mysql for faster queries.
You could try indexing you domain name, If you have data fields which have a
common value you can index the rest of the rows by the one common value.
Takes up a bit more space but is faster.
more info @
http://www.mysql.com/documentation/mysql/bychapter/manua
Hello Leon,
Thursday, October 18, 2001, 5:09:13 PM, you wrote:
LN> A quick query, in the directory /usr/local/mysql/var there are
LN> machinename-bin.001, 002, 003 etc files that are being created. What are
LN> these files and what do they do. Can I get rid of them as they are taking up
LN> mass
Thanks for the help everyone. I tried changing the type to timestamp¹ and
that did not fix the problem, however when I changed the type to
int¹ and it worked as it was suppose to.
Thanks,
Lael
Hi All,
A quick query, in the directory /usr/local/mysql/var there are
machinename-bin.001, 002, 003 etc files that are being created. What are
these files and what do they do. Can I get rid of them as they are taking up
massive amounts of space.
Any help greatly appreciated.
thanks
Leon.
--
hi.
store the information in a datetime column for easy handling.
check out the function DATE_ADD() or DATE_SUB() on this page:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
it has examples of usage that could be helpful.
i would do something like this:
select TO_DAYS(secondDate) -
Hi,
I have just stated with JDBC and MySQL. I just don't know how to start playing
with them. How to set up a test database? How to get a datasource? What's the
URL of a datasource? There are a whole lot of help on how to connect, but just
very few about how to load the driver and create a tes
Hi all-
I know this might seem simple, but for some reason I'm stumped. What I'm
trying to do is get a count (from one table) of all the distinct values in a
particular field. So for example, I'd be trying to find out how many unique
email addresses are in the table.
Right now I'm doing this w
>Description:
parsing/executing aggregates involving IF() statements. Everything needed
to reproduce the bug available from
http://www.ebi.ac.uk/~lijnzaad/mysql/bugreport.tar.gz
It's tested and reproduced on MySQL, version 3.23.32 on TrueUnix (two bugs)
or version 3.22.32 on Lin
1 - 100 of 145 matches
Mail list logo
