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
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;'
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 PROTECTED]:~#
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
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: mysql@lists.mysql.com
Sent: Tuesday, May 01, 2007 10:57 AM
Subject:
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 Bestellung
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: Monday,
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 mysql@lists.mysql.com
cc
Subject
Re: IS NULL Question
I'm having
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
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
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
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
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
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.
---TRANSACTION 0
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.
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.
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 (
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
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
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
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
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
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
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
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.
Thx.
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
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
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
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
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
30 matches
Mail list logo
