In article <[EMAIL PROTECTED]>,
matt_lists <[EMAIL PROTECTED]> writes:
> I cant tell if this is a bug or a feature.
> Select from table where col <> 'blah'
> I use this all the time with other databases, works great, gives me
> everything that's not "blah"
If those "other databases" return also
Is the INSERT ... SET syntax
(http://dev.mysql.com/doc/mysql/en/INSERT.html) MySQL specific or does
it belong to a SQL (89, 92...?) standard?
Thanks in advance
Fred
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROT
From: "Harald Fuchs" <[EMAIL PROTECTED]>
> Yes, of course. "NULL <> 'blah'" returns NULL, and that's perfectly
> standards-conformant.
Furthermore, it's quite logical.
NULL is meant to indicate that the value is unknown. If a value is unknown
it can be anything.
So, in the example `col` <> 'bla
Frederic Wenzel wrote:
Is the INSERT ... SET syntax
(http://dev.mysql.com/doc/mysql/en/INSERT.html) MySQL specific or does
it belong to a SQL (89, 92...?) standard?
http://dev.mysql.com/doc/mysql/en/Extensions_to_ANSI.html
In general usefull:
http://developer.mimer.com/validator/index.htm
Friedhelm
Hi.
Look at permissions on /var/lib/mysql
(ls -l /var/lib/mysql).
And, btw, it's not /var/liv, but /var/lib.
MySQL should have ability to read this directory.
See INSTALL-BINARY in the distribution directory and follow instructions in it exactly.
Don't forget about mysql_install_db!
Of course, it is good to upgrade to much more stable version.
Karam Chand <[EMAIL PROTECTED]> wrote:
> Hello,
>
> MySQL has released 4.1.7
>
> http://lists.mysql.com/announce/226
>
> As you can see there have been some bugfixes in
> libmysqlclient. I am using libmysql.dll provided
Hi.
Uncommon situation.
Please tell me, what OS do you use, MySQL version and how was it compiled?
Is there any clues at the end of .err file?
"J S" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have this query which used to work really fast but now it just seems to
> lock up the tab
Hi,
I am doing a dbconversion form oracle to mysql.
I would like to know the equivivalents in mysql for
1) Parameter file like init.ora in oracle
2) system package like diutil in oracle
Thanks,
Narasimha
Confidentiality Notice
The information contained in this electronic message and a
Hi there,
I am a novice with mysql on the terminal side using shell.
Basically I need to back up a database and have it saved locally from my
server. I have tried using phpmyadmin but it fails as I think the data is
too large.
I have tried the following:
mysqldump -u admin -p --databases yabbse
In article <[EMAIL PROTECTED]>,
"Jigal van Hemert" <[EMAIL PROTECTED]> writes:
> NULL is meant to indicate that the value is unknown. If a value is unknown
> it can be anything.
> So, in the example `col` <> 'blah', col can be anything, including 'blah'.
> If you take that into consideration the o
From: "Harald Fuchs" <[EMAIL PROTECTED]>
> In article <[EMAIL PROTECTED]>,
> "Jigal van Hemert" <[EMAIL PROTECTED]> writes:
>
> > Fortunately there is function COALESCE() that will return the first
argument
> > that is not NULL. In case of NULL values you can use a default value for
an
> > expres
[snip]
That's up to you of course. Personally, I think some things are better
handled by the database and some are better handled by the programming
language. Things like conditional logic tend to be best handled by the
programming language in my view. Your mileage may vary ;-)
[/snip]
AT the risk
mysqldump running very slow. what might be the reason
Server details
===
Dell
RAM : 4 GB
Innodb_buffer_pool_size : 1000MB
i am using --quick option in mysqldump
Thanks
Anil
DBA
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:
On Oct 27, 2004, at 10.26, Schalk Neethling wrote:
Greetings
After installing the new release of MySQL ( i.e. MySQL 4.1), I know
get the following error from phpMyAdmin when using any of the auth
types:
Error
#1251 - Client does not support authentication protocol requested by
server; consider
After I ran some database updates last night, it seems to be working OK
again today. Not sure what happened! Thanks anyway.
JS.
Hi.
Uncommon situation.
Please tell me, what OS do you use, MySQL version and how was it compiled?
Is there any clues at the end of .err file?
"J S" <[EMAIL PROTECTED]>
That failed with an err27 as well. How do I set the debug flag on myisamchk
?
--debug=/tmp/debug doesn't work.
JS.
Hi.
Sounds OK, but don't forget to make a backup.
"J S" <[EMAIL PROTECTED]> wrote:
> Thanks for your reply Gleb. I tried running with --safe-recover instead
of
> -qr but that cause
If I attempt to insert a record that has a duplicate key on a unique index, I
get an error message of the form:
ERROR 1062: Duplicate entry '1' for key 2
I'd like to get a little more information so as to provide the user with a
meaningful message. Specifically: what index is "Key 2"? Is there
Paul Fierro wrote:
One of my slaves stopped running due to a corrupted relay log. The error
file shows:
Error writing file 'dbs2.log' (errno: 28)
Error in Log_event::read_log_event(): 'read error', data_len: 160,
event_type: 2
$ perror 28
Error code 28: No space left on device
You are out of
- Original Message -
From: "Barry Zimmerman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 28, 2004 7:24 AM
Subject: Ho do I backup
> Hi there,
>
> I am a novice with mysql on the terminal side using shell.
>
> Basically I need to back up a database and have it sav
Hi all!!!
in what part of the documentation can i find references to this
configure options:
--with-example-storage-engine
Enable the Example Storage Engine
--with-archive-storage-engine
Enable the Archive Storage Engine
--with-csv-stor
At 9:32 -0400 10/28/04, Victor Medina wrote:
Hi all!!!
in what part of the documentation can i find references to this
configure options:
--with-example-storage-engine
Enable the Example Storage Engine
--with-archive-storage-engine
Enable the A
I believe this will work as you want:
select h1.*
FROM hist h1
LEFT JOIN hist h2
on h1.tel = h2.tel
and h2.date_h < '20041027'
where h1.date_h = '20041027'
and h2.tel is null;
This query should return all of the rows from the hist table where the tel
value appears for the date yo
Maybe I am just being dense this morning but I am confused why you think
that your nodes are different things depending on how many children they
have (nodes, groups, entities, ahhh!)...
If you have two sets of hierarchies that share the same nodes, you may
want to build two trees rath
You won't get any reasonable answers like this. How big is your db? How long
does mysqldump actually take? If you tell this, people can tell you if this
is like expected or too slow. Good answers depend on good questions.
But a hint: You can't expect mysqldump to run in fractions of seconds.
Dep
OKI! =) is there any place where i can get some info about them?
On Thu, 2004-10-28 at 09:47, Paul DuBois wrote:
> At 9:32 -0400 10/28/04, Victor Medina wrote:
> >Hi all!!!
> >
> >in what part of the documentation can i find references to this
> >configure options:
> >
> > --with-example-storage
Hi!!!
How can i specify the location of the log files in the my.cnf file?
(general, error, and bin log)
Best Regards
Vic
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Thursday 28 October 2004 08:22 am, Rhino wrote:
> - Original Message -
> From: "Barry Zimmerman" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, October 28, 2004 7:24 AM
> Subject: Ho do I backup
>
> > Hi there,
> >
> > I am a novice with mysql on the terminal side using
At 10:57 -0400 10/28/04, Victor Medina wrote:
OKI! =) is there any place where i can get some info about them?
The example engine is just a stub for developers to see how to get
started writing a storage engine. If you use ENGINE=EXAMPLE,
the table is created, but you can't actually store anything
> i struggled w/ this for a while, before learning
> that even though i had
> mysql 4.1 installed, php4 was being compiled w/ it's
> own built-in mysql
> libraries, which are pre-4.1, hence the error.
> compiling php5 will
> solve the problem, as it's included mysql libraries
> are apparently
I am looking for someone that uses mysql and lives in the Puget Sound
area. I am willing to pay someone for a little personalized help in
getting started with the basics. I know very little about databases,
but know I need to have the capability on my web site for many reasons.
I would like this
On Thu, 28 Oct 2004 12:24:02 +0100, Barry Zimmerman
<[EMAIL PROTECTED]> wrote:
>
> I have tried the following:
>
> mysqldump -u admin -p --databases yabbse > yabbsebackup.sql
>
> It seemed to work, but where can I find the yabbsebackup.sql file? Not very
> experienced with backing up.
Barry,
T
I choosed to use mysql-4.1.5-gamma due to the UTF-8 support but failing
to compile in on Solaris 8 (Sparc)
Earlier I got problem with not finiding gCC and I created a symbolic
link to the gcc in the /usr/local/bin and the compilation went on fine
till I hit the error below.
mkdir .libs
gCC -O -
Hi...
I have a db that I'm writing. It's for a business directory and one of the
fields/columns in the table needs to have a list of business types in it
(i.e. retail, auto, computer and so on). Since there may be more than one
category that a business fits under I was wondering if "SET" is the
Hi.
Thank you!
It looks like you've found a bug:
http://bugs.mysql.com/bug.php?id=6309
Seems, you have myisamchk compiled without debug support.
See:
http://dev.mysql.com/doc/mysql/en/Compiling_for_debugging.html
http://dev.mysql.com/doc/mysql/en/MyODBC_Unix_debugging_options.html
Hi!
I searched near and far but could not find the slightest hint
about what is causing my MySQL problems. I have a couple of
servers running 3.23 and 4.0x just perfect but after updating
one machine to 4.1, I can no longer start mysqld.
Here is the error message:
==
On 10/28/2004 8:07 AM, gerald_clark <[EMAIL PROTECTED]>
wrote:
>
>
> Paul Fierro wrote:
>
>> One of my slaves stopped running due to a corrupted relay log. The error
>> file shows:
>>
>> Error writing file 'dbs2.log' (errno: 28)
>> Error in Log_event::read_log_event(): 'read error', data_len:
Heh, I don't think you're being dense. I can barely understand what I
meant. I'll try to clarify I bit more.
What I have is a sequence of entities (for this example the entities
will be letters). I'm trying to use MySQL to hold the possible
combinations of entities.
The unique entities in a s
Hi Stefan,
Sorry for not giving complete details
it a very small database around 12 Gb data. But on my other servers which
are low in configuration i am getting dump very fast
for me it is taking nearly 5 Hrs to compleate dump
Thanks
Anil
DBA
-Original Message-
From: Stefan Kuhn [mailto
Hi,
I have a table of grades like this:
title, section, instructor, letter_grade, number_grade, uid
With data that would look like this:
English, 1, Smith, B, 88, 1
English, 1, Smith, B, 86, 1
English, 1, Smith, B+, 89, 1
Math, 1, Jones, A, 95, 2
Math, 1, Jones, B, 85, 2
Math, 2, Smith, C, 75, 3
Ma
I'm trying to create a view from two tables address and address_association.
So I did the following and expect they are the same:
CREATE VIEW associated_address AS
select t0.association_id AS association_id,
t0.property_dict AS property_dict,
t0.type_id AS type_id,
t0.owner_id AS owner_id,
t0.own
Aman Raheja wrote:
Latest realease is 4.1.7 in 4.1.x but I am looking for 4.1.5 source
download.
Pointers will be helpful.
Thanks
Aman
http://downloads.mysql.com/archives.php?p=mysql-4.1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
Something like
SELECT uid,
AVG(number_grade) AS average_grade,
SUM(IF(letter_grade = 'A', 1, 0)) AS A_count,
SUM(IF(letter_grade = 'B+', 1, 0)) AS B+_count,
SUM(IF(letter_grade = 'B', 1, 0)) AS B_count,
SUM(IF(letter_grade = 'B-', 1, 0)) AS B-_count,
I'd like to setup an application to store equipment configuration data in a
MySql database. The basic setup is that each equipment has a certain number
of parameters which may change over time. I'd like to track these changes
over time and want to be able to create queries which determine the statu
Hi, I'm totally new at this so have no idea whether I'm asking for something
easy or quite difficult.
I am working in MySQL 3.23.58/PHP and am trying to construct a rather complex
query. I have three tables: resources (containing resid, descr, title, url),
topicdir (containing topicid, resid) and
Hi,
How can i increase the size of the log file and log buffer size?
i tried to change it on my.cnf file but it return this error message:
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880
bytes
InnoDB: than specified in the .cnf file 0 67108864 bytes!
041028 0:10:49 Can'
http://dev.mysql.com/doc/mysql/en/JOIN.html
-Original Message-
From: Emily Lena Jones [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 28, 2004 1:05 PM
To: [EMAIL PROTECTED]
Subject: many-to-many query
Hi, I'm totally new at this so have no idea whether I'm asking for something
easy or
Your system sounds more like BNF (Backus-Naur Form) expression evaluator
than a regular expression evaluator. Both are similar in that you can
specify sequences of things (letters or words or symbols) to appear in
certain orders and in certain quantities. Once a BNF or regex expression
is parse
Oops, I meant to copy the list on this reply too.
Rhino
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "Andy B" <[EMAIL PROTECTED]>
Sent: Thursday, October 28, 2004 4:00 PM
Subject: Re: column choices for certain data
>
> - Original Message -
> From: "Andy B" <[EMA
I suspect that you actually have two records in address_association that
don't match up with a record in address. Yes, either a data mismatch or
data duplication would be suspected in a case like this.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Elim Qiu" <[EMAIL PROTEC
Check out this section in the manual on innodb log files.
http://dev.mysql.com/doc/mysql/en/Adding_and_removing.html
-Eric
On Thu, 28 Oct 2004 15:47:27 -0500, Oropeza Querejeta, Alejandro
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> How can i increase the size of the log file and log buffer size?
>
>
Hi...
Thanks for the info/help here. I understand everything up to the part where
it talks about referencing more than 1 table to each other and the foreign
keys and all that stuff...
basically I got lost. Not because you explained it wrong but because I
haven't got the foggiest clue what keys/
- Original Message -
From: "Emily Lena Jones" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 28, 2004 4:05 PM
Subject: many-to-many query
> Hi, I'm totally new at this so have no idea whether I'm asking for
something
> easy or quite difficult.
>
> I am working in My
Hey come n visit Dhaka + Learn( free) MySQL, have a holiday too.!!!
Bill wrote:
I am looking for someone that uses mysql and lives in the Puget Sound
area. I am willing to pay someone for a little personalized help in
getting started with the basics. I know very little about databases,
but know I
Hi there, I have Mysql 4.1 on my development machine, I have been
trying to test out if I am going to be able to do this. What I would
like to do is return a one to many resultset but without the duplicated
results in the first query. Hows is this going to be possible ? I would
like to get all
See my remarks interspersed below.
Rhino
- Original Message -
From: "Andy B" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 28, 2004 5:09 PM
Subject: Re: column choices for certain data
> Hi...
>
> Thanks for the info/help here.
No problem; that's what the list is
Installing MySQL 4.1.7 (upgrading from 4.1.3) on MacOS X erased the contents
of /usr/local/mysql/data -- the privs and data of the previous installation.
FYI
Luckily (and unfortunately) we have a backup of that database from last
week. (The guy that did it here in the office is still in a bit of
So, do you have a question or are you just bragging? ;-)
Rhino
- Original Message -
From: "Steven Roussey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 28, 2004 7:20 PM
Subject: Upgrading MySQL erased all data
> Installing MySQL 4.1.7 (upgrading from 4.1.3) on Ma
- Original Message -
From: "electroteque" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 28, 2004 6:33 PM
Subject: Sub queries
> Hi there, I have Mysql 4.1 on my development machine, I have been
> trying to test out if I am going to be able to do this. What I would
Hi List,
How do I dump the data from console to the text file from the output generated by
SELECT statement ?
Thanks,
Nikhil.
Quoting Rhino <[EMAIL PROTECTED]>:
> I wasn't sure if you understood the concept of association tables so forgive
> me if I told you things you already knew; I didn't mean to be patronizing.
No problem--you weren't patronizing at all, and I did tell you I was new at
this!
> With respect to you
electroteque wrote:
Also I am trying to push for 4.1 to be installed on the servers i
build web apps on. When will be a possible date to say that gamma
which is practically production quality, to actually say production
quality ? heheh. Our systems guy will only trust it if it says that,
god on
I've created two temporary tables:
CREATE TEMPORARY TABLE `activenodes` (
`id` smallint(6) unsigned NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
`rsrcc` bigint(21) NOT NULL default '0',
PRIMARY KEY (`id`)
);
CREATE TEMPORARY TABLE `activelayers` (
`id` int(10) unsigned
Ok thanks a bunch, I'll take this information and see what I can come up
with.
Chris
[EMAIL PROTECTED] wrote:
Your system sounds more like BNF (Backus-Naur Form) expression evaluator
than a regular expression evaluator. Both are similar in that you can
specify sequences of things (letters or wo
Dear Gleb,
[EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# chown -R root /var/lib/mysql
[EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# chown -R mysql /var/lib/mysql
[EMAIL PROTECTED] mysql-standard-4.0.21-pc-linux-i686]# chgrp -R root /var/lib/mysql
[EMAIL PROTECTED] bin]# ls
co
Hi all ,
I am trying to install the latest 4.17-standard Linux release on our server and and it
gets caught in an endless loop of crashes.
I have read the error logs , and followed the stack trace advice from the docs , but
to be honest Im not sure how to interpret what it reports.
Here is w
>>
> The keyword UNION should ensure that all duplicate rows are removed
> from the combined result set. If you use UNION ALL instead of UNION,
> the duplicates are left in the result set.
>
Yeh right, funny, early versions of 4.0, UNION had in the docs this was
only avail in 4.1, i am so sure i
There are several ways to get output to a text file, from the Unix shell
you can:
> mysql -e "select * from table" database > output.txt
or if you're looking for more of a log of what happened in the MySQL
client, from the MySQL shell:
> tee output.txt
> select * from table;
Mulley, Nikhil wrot
Hi all,
I had no problem with compiling 4.1.2-alpha (or 4.0.x)
and it has been working fine. But for both
4.1.5-gamma and 4.1.7, when I get to make test, all
the tests fail. Normally, alias (the first one) fails
and the whole thing stops, but using --force, they all
fail. I get a log error abou
Hello, I was wondering if people consider the on line docs at the mysql
web site to be equivalent to their books
regarding the database administration. Does the book go into more
detail, or is all the contents of that book online?
Thanks for the clarification, and pointers to good online mysql
a
Hello!
I have situation where I need to find the next autoindex of a table - not just
max(field) because the next autoindex may not jive with the number created by
max(field)
Any ideas?
Am I making sense?
Thanks!
R. Whitney
Transcend Development
"Producing the next phase of your internet presenc
In mysql version 4.1.7 running on Redhat 3ES I get the following error from
mysql dump.
$ mysqldump -u root -p govern > test.sql
Enter password:
mysqldump: Got error: 1017: Can't find file: './govern/VT_SY_LANGUAGE.frm'
(errno: 24) when using LOCK TABLES
This file does in fact exist and mysql h
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 28, 2004 9:26 PM
Subject: Re: Sub queries
>
> >>
> > The keyword UNION should ensure that all duplicate rows are removed
> > from the combined result set. If you use UNION ALL instead of UNION
-- Original message from Richard Whitney <[EMAIL PROTECTED]>:
--
> Hello!
>
> I have situation where I need to find the next autoindex of a table - not just
> max(field) because the next autoindex may not jive with the number created by
> max(field)
http://dev.mysql.
perror 24
Error code 24: Too many open files
Looks like you've hit a system limit.
Michael
Tom Crimmins wrote:
In mysql version 4.1.7 running on Redhat 3ES I get the following error from
mysql dump.
$ mysqldump -u root -p govern > test.sql
Enter password:
mysqldump: Got error: 1017: Can't find f
-- Original message --
From: Tom Crimmins <[EMAIL PROTECTED]>
>
> $ mysqldump -u root -p govern > test.sql
> Enter password:
> mysqldump: Got error: 1017: Can't find file: './govern/VT_SY_LANGUAGE.frm'
> (errno: 24) when using LOCK TABLES
>
perror says 24 is too m
>>
> There are obviously many possible variations of your query; I just
> stated one that was pretty close to your original query. It's really
> not clear to me yet what you were trying to do so I just wanted to show
> you typical syntax.
>>
>>
Ok sorry ppl I should have given a typical example i
Hello,
I was able to compile mysql 4.0 and 4.1 (static) successfully with
intel compiler 8.0 on an IA32 system running redhat enterprise linux
3.0. However when I tried to compile with intel compiler 8.1 with the
same options (same as ones used by mysql AB, except i link statically)
I kept getting
77 matches
Mail list logo
