On Tue, May 1, 2007 22:15, Brown, Charles wrote:
>
> Because I am running on batch mode therefore I'm trying to direct my
> session output to a file -- meaning stdout. But I'm having a problem.
> For instance this input: "use test_db" gave me no output but this input
> "show tables" gave me an out
At 6:20 PM -0400 5/1/07, John Kebbel wrote:
Linux Version: Linux version 2.6.15-28-386
MySQL Version: 5.0.22-Debian_0ubuntu6.06.3-log
I have two queries using REGEXP character classes and their respective
outputs below. The first is supposed to match an upper case character in
a column, but I w
Thank you for stating something obvious that I was completely
overlooking. With normal tables I had created, I would never expect
related tables to be magically updated by something I did to one table.
Because I was dealing with a table in the mysql database that was
created by MySQL, I had assumed
I trust that you realize that you can never expect related tables to
be uodated in the mysql database if you using using SQL to manipulate
them directly. moving on..
I can't think of any mainstream systrm that generally allows usernames
to be changed.. I mean, sure, there is a trivial hack to do
I've discovered that I can type ...
use mysql;
show tables;
describe user;
update user set user='newName' where user='oldName'
However, this seems to have no effect on the user name in the privileges
table when I searched them.
The MySQL site says the alternative way to do this has the same pro
Linux Version: Linux version 2.6.15-28-386
MySQL Version: 5.0.22-Debian_0ubuntu6.06.3-log
I have two queries using REGEXP character classes and their respective
outputs below. The first is supposed to match an upper case character in
a column, but I wind up with 4 rows out of 25 that contain only
Because I am running on batch mode therefore I'm trying to direct my
session output to a file -- meaning stdout. But I'm having a problem.
For instance this input: "use test_db" gave me no output but this input
"show tables" gave me an output.
What is missing, what's the trick. Help me Y'all.
Th
It looks like it was a string named NULL posing as a null value.
I got 0 for ISNULL(suffix), which I assume means false. I tried this
command ...
update persons set suffix = 'Empty' where suffix = '';
It changed the NULLs to Empty.
On Mon, 2007-04-30 at 18:12 -0700, Jeremy Cole wrote:
> Hi Joh
There's a system variable called expire_logs_days that lets you set a
number of days to keep binary logs, and automatically delete logs
older than that. I've heard rumors that using this feature is
problematic. I notice that in the MySQL documentation about binary
logging, it tells you to use "pu
Hi,
Yes I'm using the -q option with mysqldump, but the result is the same.
This is a replicated environment and the master is running FreeBSD and
the slave NetBSD and on the master which only has InnoDB tables there is
no problems to run a dump but the machine is to loaded so we can not
aff
I've had a lot of fun using Toad on Oracle. Quest got a freeware
for MySQL, that i never got around to try, but have a look at:
http://www.quest.com/toad-for-mysql/
On Tue, May 1, 2007 21:36, Afan Pasalic wrote:
> Hi,
> I'm looking for database modeling tool form MySQL. Anybody used the
> MySQL
Have you tried this flag?
-q, --quick Don't buffer query, dump directly to stdout.
On Sun, 29 Apr 2007, Fredrik Carlsson wrote:
> Hi,
>
> I have a problem with mysqldump, its exiting with the message
>
> mysqldump: Error 5: Out of memory (Needed 22042208 bytes) when dumping
> table `t
Hi,
I'm looking for database modeling tool form MySQL. Anybody used the
MySQL Workbench? I know the Workbench is in Alpha production, though
some "hints"?
How about DB Designer?
Thanks for any respond.
-afan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
Jerry Schwartz wrote:
We use NULL all the time with MyISAM tables, and I've never noticed a
problem.
I think there was a bug at one point dealing with NULL and empty
strings, but it strikes me that it was a bug in the new client/server
protocol that was introduced in (4.1? 5.0?).
So, it mig
Caveat emptor: I haven't tested this in about a year.
Are you perchance using a table type of MyISAM? I seem to recall
that MyISAM has a hard time actually representing NULL
internally. [ ... Thinks for a minute ... ] I remember
something about spaces, like, I think I did
INSERT ( val
We use NULL all the time with MyISAM tables, and I've never noticed a
problem.
Well, there was one bizarre bit of business that's already been mentioned:
my predecessor actually put the string "NULL" into a field, and since it
looks the same in the MySQL client that gave me a devil of a time.
Reg
Kevin Hunter wrote:
At 9:06p -0400 on 30 Apr 2007 John Kebbel wrote:
I'm having problems understanding NULL. I grasp what a NULL value is,
A NULL value is rather an oxymoron. It'd be more accurate to say that
NULL means "absence of a value".
but I can't get NULL to perform correctly. F
Baron-
Thank you for the InnoDB Lock Monitor pointer. I now have a greate deal
of informaiton to digest. I will try innotop when I have a chance.
:)
-Paul
>
> Hi Paul,
>
> Power, Paul C. wrote:
> > I have an INSERT waiting for a table lock, and i do not
> understand why.
> >
> > ---TRANSA
At 9:06p -0400 on 30 Apr 2007 John Kebbel wrote:
I'm having problems understanding NULL. I grasp what a NULL value is,
A NULL value is rather an oxymoron. It'd be more accurate to say
that NULL means "absence of a value".
but I can't get NULL to perform correctly. For instance, if I do a
Jesse wrote:
COALESCE(CampCount.Cnt,0) + COALESCE(CounselorCount.Cnt,0) as GT
Duuuh. Why didn't I think of that. What is MySQL's issue with
referring to the variables ("As" assignments, whatever you want to
call them)? I've had issues like this in situations like this one,
when trying to
COALESCE(CampCount.Cnt,0) + COALESCE(CounselorCount.Cnt,0) as GT
Duuuh. Why didn't I think of that. What is MySQL's issue with referring to
the variables ("As" assignments, whatever you want to call them)? I've had
issues like this in situations like this one, when trying to use them in the
Hi Jesse,
Jesse wrote:
The following query works just fine:
SELECT B.BusNum, COALESCE(CampCount.Cnt,0) As Kids, B.CamperCapacity,
COALESCE(CounselorCount.Cnt,0) As Adults, B.AdultCapacity
FROM Buses B
LEFT JOIN (SELECT BusID,Count(*) As Cnt FROM Campers GROUP BY BusID)
AS CampCount ON Camp
The following query works just fine:
SELECT B.BusNum, COALESCE(CampCount.Cnt,0) As Kids, B.CamperCapacity,
COALESCE(CounselorCount.Cnt,0) As Adults, B.AdultCapacity
FROM Buses B
LEFT JOIN (SELECT BusID,Count(*) As Cnt FROM Campers GROUP BY BusID) AS
CampCount ON CampCount.BusID=B.ID
LEFT J
By chance when you set them as null did you use "null" or 'null' setting
it as a string value?
__
Lucas Heuman
Phone 609.485.5401
"Martijn Tonies" <[EMAIL PROTECTED]>
05/01/2007 04:45 AM
To
"MySQL"
cc
Subject
Re: IS NULL Question
> I'm having problems understan
Well, then color me baffled. I don't know why your first query didn't work.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: John Kebbel [mailto:[EMAIL PROTECTED]
> Sent: Monda
hello list,
I saw this article for the suitable filesystem for mysql.
http://www.bullopensource.org/ext4/sqlbench/
>From what I saw,the best filesystem for MyISAM is ext3,the best filesystem for
>InnoDB is Reiserfs.
How about your thought on it?Thanks.
50 AMAZON-Einkaufsgutschein bei Bestellun
Ok, thank you all. It was my mistake. I have quoted the SQL command with
single quotes under Windows.
Octavian
- Original Message -
From: "Stijn Verholen" <[EMAIL PROTECTED]>
To: "Octavian Rasnita" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, May 01, 2007 10:57 AM
Subject: Re: show tables
> I'm having problems understanding NULL. I grasp what a NULL value is,
Actually, you don't :-)
NULL is not a value, it's the lack of value and a state.
A column can have 2 states: NULL or NOT NULL, which is part
of the reason why SQL allows for the IS NULL and IS NOT NULL
clause as opposed t
On Tue, May 1, 2007 09:57, Stijn Verholen wrote:
> Octavian Rasnita wrote:
>>
>> mysql -u user -p database -e 'show tables;' > file.txt
That one works for me, with a litle change. -s (kill's columnnames a.o.).
[EMAIL PROTECTED]:~# mysql -s -u rppt test -e 'show tables;' > file.txt
[EMAIL PROTECT
Octavian Rasnita wrote:
Hi,
I want to print the list of tables (one on a line) from a database
into an external file.
I have tried:
mysql -u user -p database -e 'show tables;' > file.txt
mysql -u root -p information_schema -e 'select table_name from tables
where table_schema="database_name"
Hi,
I want to print the list of tables (one on a line) from a database into an
external file.
I have tried:
mysql -u user -p database -e 'show tables;' > file.txt
mysql -u root -p information_schema -e 'select table_name from tables where
table_schema="database_name";' > file.txt
But the r
31 matches
Mail list logo